Practice / aggregations
At The Daily Grind, a store's regulars matter more than its raw order count.
You have the orders DataFrame:
Your task: return each store and a column buyers — the number of distinct customer_ids that ordered there.
Assign your answer DataFrame to result. Row order doesn't matter.
ordersinput DataFrame| column | type |
|---|---|
| order_id | long |
| store | string |
| customer_id | long |
| order_id | store | customer_id |
|---|---|---|
| 1 | Downtown | 100 |
| 2 | Downtown | 100 |
| 3 | Downtown | 101 |
| 4 | Pier | 200 |
storebuyers· 2 rowsgroupBy("store") then agg(F.countDistinct("customer_id").alias("buyers")).
You want unique customers, not the number of orders.
This problem builds on Aggregations & groupBy (~7 min). Pop it open in a new tab if you want a quick recap.