GroupBy & Aggregation in Pandas

Summary

Pandas' equivalent of SQL's GROUP BY — splitting data into groups, applying an aggregate function, and combining results back into a summary table.

• 1Practice a groupby().agg() call summarizing sales by category and month.
• 2Learn to apply multiple aggregate functions in a single groupby call.
• 3Compare the output directly to the same query written in SQL.