# agg()

*noun*

say it: **“AG”** **/ˈæɡ/**

Short for aggregate: a pandas method that works out several summaries for each group, such as a total, an average and a count, in one table.

## What does **agg()** do in pandas?

**agg()**, short for aggregate, is a pandas method that works out several summaries for each group at once, such as a
sum, a mean and a count, and hands them back as one table with a column for each.

```python
import pandas as pd
orders = pd.DataFrame({"size": ["small", "large", "small"], "total": [12.0, 20.0, 14.0]})
print(orders.groupby("size")["total"].agg(["sum", "mean", "count"]))
#         sum  mean  count
# size
# large  20.0  20.0      1
# small  26.0  13.0      2
```

## In a sentence

- “**agg()** gave each pizza size its total, average and number of orders.”
- “One call to **agg()** replaced three separate groupby lines.”

Level: Journeyman · [More Python terms at this level](https://www.ask-codey.com/glossary?category=python&level=3)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/agg
