A Facebook-style social team rolls up daily reach by page.
Return page_id, page_name, total_reach for each page. Sort by page_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
page_daily6 rows| page_id (string) | page_name (string) | day (int) | reach (int) |
|---|---|---|---|
| FB1 | Campus Eats | 1 | 1200 |
| FB1 | Campus Eats | 2 | 1500 |
| FB2 | City Runners | 1 | 800 |
| FB2 | City Runners | 2 | 950 |
| FB3 | Weekend Trips | 1 | 2200 |
| FB3 | Weekend Trips | 2 | 1800 |
Column names and order must match. Sort order is specified in the question.