What are some examples of using groupby in Python?

Can you explain how to use groupby in Python with some examples?

Sure! The groupby function in Python, especially in libraries like Pandas, is used to split the data into groups based on some criteria.

Can you show me a simple example using a DataFrame?

Absolutely! Here's a basic example:

import pandas as pd

data = {'Category': ['A', 'B', 'A', 'B'], 'Values': [10, 20, 30, 40]}

df = pd.DataFrame(data)

# Group by 'Category' and sum the 'Values'
grouped = df.groupby('Category').sum()
print(grouped)

This will give you the sum of values for each category.

What if I want to apply multiple aggregation functions?

You can use the agg method to apply multiple functions. For example:

grouped = df.groupby('Category').agg({'Values': ['sum', 'mean', 'max']})
print(grouped)

This will provide the sum, mean, and maximum of the values for each category.