Level 3: Aggregating · Exercise 36 of 63 · Pro

Pivot table with totals

A pandas exercise from Pandasdrill. Solve it with a Python editor in your browser running real pandas, and it is checked the moment you submit.

The task

Build a table of total revenue with one row per region and one column per product. Add a row and a column of totals, both labeled "Total", and show 0 where a region sold none of a product.

What this exercise teaches

margins=True appends a row and a column holding the aggregate across all groups, computed with the same aggfunc, so with sum you get grand totals. The default label is "All"; margins_name renames it. fill_value fills the empty cells before the totals are computed, so the totals still add up.

A hint if you get stuck

pivot_table has margins and margins_name parameters.