The Daily Grind wants a takings-per-store summary.
You have the orders DataFrame:
Your task: return each store and a column total_revenue — the sum of amount for that store.
Assign your answer DataFrame to result. Row order doesn't matter.
Practice / aggregations
Revenue Per Store
easyordersinput DataFrame
Schema
| column | type |
|---|---|
| order_id | long |
| store | string |
| amount | double |
Sample rows
| order_id | store | amount |
|---|---|---|
| 1 | Downtown | 5 |
| 2 | Downtown | 7 |
| 3 | Pier | 4 |
| 4 | Pier | 6 |
| 5 | Pier | 2 |
Expected output shape
storetotal_revenue· 2 rows›Hint
groupBy("store") then agg(F.sum("amount").alias("total_revenue")).
›Lesson refresher
This problem builds on Aggregations & groupBy (~7 min). Pop it open in a new tab if you want a quick recap.
⌘/Ctrl+↵ run · ⇧⌘/Ctrl+↵ submit
Loading editor…
Hit Run to execute your code and see the output here.