The sales table records quarterly revenue by category.
Pivot the quarters into columns 1, 2, 3, 4 and return category, 1, 2, 3, 4 with summed revenue in each quarter. Sort by category ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
sales12 rows| sale_id (int) | category (string) | quarter (int) | amount (double) |
|---|---|---|---|
| 1 | Audio | 1 | 100 |
| 2 | Audio | 2 | 120 |
| 3 | Audio | 3 | 90 |
| 4 | Audio | 4 | 110 |
| 5 | Home | 1 | 80 |
| 6 | Home | 2 | 70 |
| 7 | Home | 3 | 60 |
| 8 | Home | 4 | 50 |
| 9 | Office | 1 | 40 |
| 10 | Office | 2 | 45 |
| 11 | Office | 3 | 50 |
| 12 | Office | 4 | 55 |
Column names and order must match. Sort order is specified in the question.