Pivot Tables

Pivot tables reshape data to create summary tables with rows and columns from your data values.

Basic Pivot Table

Create a summary table:

Aggregation Functions

Specify how to aggregate values:

Multiple Values

Pivot multiple columns:

Adding Totals

Include row and column totals:

Handling Missing Values

Fill or handle NaN in pivots:

Multiple Index Levels

Create hierarchical pivots:

Exercise: Sales Pivot

Exercise: Pivot with Totals

Key Points

• pivot_table() creates summary tables
• index= for row labels, columns= for column headers
• values= specifies data to aggregate
• aggfunc= sets aggregation (default is 'mean')
• margins=True adds row/column totals
• fill_value= replaces NaN