Practice / spark mental model
A colleague at The Daily Grind wrote some code to list the large drinks along with what the customer actually paid: the price plus the tip. It errors. Fix it; don't start again from scratch.
You have the orders DataFrame:
Your task: return order_id, drink, and paid (where paid is price + tip) for every order with size "large".
Assign your answer DataFrame to result. Row order doesn't matter, and paid is compared with a float tolerance.
ordersinput DataFrame| column | type |
|---|---|
| order_id | long |
| drink | string |
| size | string |
| price | double |
| tip | double |
| order_id | drink | size | price | tip |
|---|---|---|---|---|
| 1001 | oat latte | large | 6.5 | 1 |
| 1002 | drip coffee | small | 3 | 0 |
| 1003 | caramel macchiato | large | 7.25 | 2 |
| 1004 | flat white | medium | 5 | 1.5 |
| 1005 | cold brew | large | 5.5 | 0.5 |
| 1006 | espresso | small | 2.5 | 0.75 |
| 1007 | mocha | large | 6.75 | 0.25 |
| 1008 | latte | medium | 5.25 | 2 |
| 1009 | gold-dust affogato | small | 6.5 | 0.75 |
| 1010 | barrel-aged cold brew | large | 6 | 0.5 |
order_iddrinkpaid· 5 rowsEvery transformation returns a new DataFrame and leaves the old one alone.
Two lines here return something and throw it away. Give each one a name, and
build result from the last name.
This problem builds on Nothing Runs Until You Ask (~4 min). Pop it open in a new tab if you want a quick recap.