Practice / aggregations
The Daily Grind wants the headline price in each part of the menu.
You have the menu DataFrame:
Your task: return each category and a column top_price — the maximum price in that category.
Assign your answer DataFrame to result. Row order doesn't matter.
menuinput DataFrame| column | type |
|---|---|
| item | string |
| category | string |
| price | double |
| item | category | price |
|---|---|---|
| Latte | drink | 5 |
| Mocha | drink | 6 |
| Muffin | food | 3.5 |
| Bagel | food | 3 |
categorytop_price· 2 rowsgroupBy("category") then agg(F.max("price").alias("top_price")).
This problem builds on Aggregations & groupBy (~7 min). Pop it open in a new tab if you want a quick recap.