How can I aggregate data in a DataFrame using Python?

How can I aggregate data in a DataFrame using Python?

You can use the groupby() function in pandas to aggregate data. What specific aggregation do you need?

I want to calculate the average sales per product category.

You can do that with: df.groupby('category')['sales'].mean(). This will give you the average sales for each category.

What if I want to see the total sales instead?

You can use: df.groupby('category')['sales'].sum(). This will provide the total sales for each category.

Can I aggregate multiple columns at once?

Yes! You can use: df.groupby('category').agg({'sales': 'sum', 'quantity': 'mean'}) to aggregate multiple columns.