An Instagram-style growth team compares starting and ending follower counts.
Return account_id, handle, net_change, where net change is followers_end - followers_start. Sort by account_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
accounts6 rows| account_id (int) | handle (string) | followers_start (int) | followers_end (int) |
|---|---|---|---|
| 1 | urbanclicks | 120000 | 135000 |
| 2 | dailybrew | 80000 | 76000 |
| 3 | fitwithria | 45000 | 52000 |
| 4 | travelframes | 200000 | 198000 |
| 5 | kitchenlab | 60000 | 61000 |
| 6 | stylefile | 150000 | 165000 |
Column names and order must match. Sort order is specified in the question.