A pivot table is a summarized tabular view that groups and aggregates records across selected row and column dimensions. It supports comparisons such as distributor market share by year. section 5.4.3
Use a pivot table to:
- Place years in rows and distributors in columns so each distributor becomes a time-series line. section 5.4.3
- Aggregate repeated observations with a grouping operation before reshaping the result. section 5.4.3
- Cross-reference two categorical variables and optionally visualize their counts or values with a heatmap. section 7.3.1
- Inspect category quality before interpretation by merging equivalent labels and deciding how to handle ambiguous categories. section 5.4.3
Distributor market share by year
Group distributors by Year and Distributor, sum Market share, and unstack Distributor into columns. Before plotting, merge labels such as “eOne Films” and “Entertainment One,” combine “Other” categories, and decide whether to retain only distributors represented in every year. section 5.4.3
