Cross Tabulation

pd.crosstab() computes frequency tables to show how often value combinations occur.

Basic Crosstab

Count combinations of values:

Adding Margins

Include row and column totals:

Normalizing Values

Show percentages instead of counts:

Aggregating Values

Apply functions to a third column:

Multiple Values

Crosstab with multiple row or column variables:

Crosstab vs Pivot Table

Compare the two approaches:

Exercise: Basic Crosstab

Exercise: Percentage Crosstab

Key Points

• pd.crosstab() creates frequency tables
• Counts combinations by default
• margins=True adds totals
• normalize= for percentages ('all', 'index', 'columns')
• Use values= and aggfunc= to aggregate other data
• Simpler than pivot_table for counting