# pandas

> A free tool in Python for tables.

**Field:** Data Engineering  
**Category:** Processing  
**Also known as:** Pandas, pandas library

## Think of it like

It is like a math helper for whole tables. You ask for a sum, and it does all the rows.

## Definition

pandas is a free Python library for working with tables as DataFrames. It reads CSV, Excel, JSON, Parquet and SQL tables. It can clean, join, group and reshape data in a few lines. It keeps all the data in memory on one computer. That makes it fast for small and medium data, but it struggles once the data is bigger than memory.

## Example

A data scientist checks a 2 GB export in pandas on a laptop. A 200 GB table would not fit.

## Example code

```python
import pandas as pd

df = pd.read_csv("sales.csv")
print(df.groupby("city")["total"].sum())
```

Read a CSV and print total sales for each city.

## Why it matters

It is the most used table tool in Python. Most data work starts or ends in it.

## Common mistake

Loading a file bigger than memory. Use Polars, DuckDB or Spark, or read only the columns you need.

## Three principles

- **DataFrames in Python.** Read, clean, join, group.
- **All in memory.** On one computer.
- **Small to medium data.** Not for huge tables.

## Related terms

- [DataFrame](https://learn.benibix.com/term/data/dataframe)
- [Polars](https://learn.benibix.com/term/data/polars)
- [Apache Spark](https://learn.benibix.com/term/data/apache-spark)
- [Python](https://learn.benibix.com/term/development/python)
- [Jupyter Notebook](https://learn.benibix.com/term/development/jupyter-notebook)

## Told apart from

- [pandas vs Polars](https://learn.benibix.com/compare/pandas-vs-polars): People think Polars is just a faster pandas, and it is more than that. Both hold a table in memory on one machine. pandas runs each step as soon as you write it, mostly on one core. Polars can plan the whole job first, read only what the answer needs, and use every core. The code looks alike, but the habits differ.

---

Source: https://learn.benibix.com/term/data/pandas
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
