C10PythonIntermediateAbout 100 min to complete
Pivot Tables
Cross-tabulation that turns a transaction log into a summary a manager can read.
Notebook
About 100 minutes to complete
Enrol to read the notebook and download it to run.
What this module covers
Cross-tabulation that turns a transaction log into a summary a manager can read.
By the end of it
- Build pivot tables with rows, columns, values, and aggregation functions
- Distinguish pivot from pivot_table and know when each fails
- Apply multiple aggregations and multiple value columns
- Add row and column totals with margins
- Handle missing combinations with fill_value and dropna
- Use crosstab for frequency and proportion analysis
- Navigate and flatten the resulting MultiIndex columns
- Produce a formatted management report