Pivot Tables in Pandas

Pivot tables summarize data by two dimensions, like Excel's pivot feature.

pd.pivot_table(df, values='sales', index='region', columns='quarter', aggfunc='sum')

This creates a table with regions as rows, quarters as columns, and sum of sales in each cell.

Multiple aggregations:

pd.pivot_table(df, values='sales', index='region', aggfunc=['sum', 'mean', 'count'])

Multiple values:

pd.pivot_table(df, values=['sales', 'profit'], index='region', aggfunc='sum')

Pivot tables are powerful for quick summaries and understanding patterns across two categorical dimensions.

For advanced pivot techniques, see The Ultimate Pandas Bootcamp.