Practice / joins
A regional manager wants to compare each store's daily revenue against its target — but only where both numbers exist.
You have two DataFrames:
actuals
targets
Your task: join on both store and day, and return store, day, revenue, and target for the store-days that appear in both tables.
Assign your answer DataFrame to result. Row order doesn't matter.
actualsinput DataFrame| column | type |
|---|---|
| store | string |
| day | string |
| revenue | double |
| store | day | revenue |
|---|---|---|
| Downtown | Mon | 8 |
| Downtown | Tue | 4 |
| Pier | Mon | 6 |
targetsinput DataFrame| column | type |
|---|---|
| store | string |
| day | string |
| target | double |
| store | day | target |
|---|---|---|
| Downtown | Mon | 7 |
| Pier | Mon | 5 |
| Harbor | Wed | 3 |
storedayrevenuetarget· 2 rowsPass a list of key names to on: actuals.join(targets, on=["store", "day"], how="inner"). Both keys must match for a row to survive.
This problem builds on Joins (~8 min). Pop it open in a new tab if you want a quick recap.