# groupby()

*noun*

say it: **“GROOP-by”** **/ˈɡrupˌbaɪ/**

A pandas method that splits a table's rows into groups by the values in one column, so each group can be added up or averaged.

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

**groupby()** is the pandas method that sorts a table's rows into groups by a column's value, so each group can be
totaled, counted or averaged on its own.

```python
import pandas as pd
sales = pd.DataFrame({"store": ["Main", "Elm", "Main"], "cups": [300, 410, 320]})
print(sales.groupby("store")["cups"].sum())
# store
# Elm     410
# Main    620
```

## In a sentence

- “She used **groupby()** to average the test scores by class period.”
- “**groupby()** on the store column gave each store's total cups.”

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

Updated: November 19, 2026

## In other subjects

- [GroupBy() in C#](https://www.ask-codey.com/glossary/groupby)

Source: https://www.ask-codey.com/glossary/groupby-python
