Practice / selecting and filtering
PulsePoint gym wants to celebrate its most dedicated members — the ones who stay a while.
You have the checkins DataFrame:
Your task: return the member and minutes for every visit lasting at least 45 minutes.
Assign your answer DataFrame to result. Row order doesn't matter.
checkinsinput DataFrame| column | type |
|---|---|
| checkin_id | long |
| member | string |
| minutes | long |
| checkin_id | member | minutes |
|---|---|---|
| 1 | Ada | 50 |
| 2 | Ben | 20 |
| 3 | Cara | 45 |
| 4 | Dan | 60 |
| 5 | Ada | 30 |
memberminutes· 3 rowsfilter(F.col("minutes") >= 45) then select("member", "minutes"). "At least
45" includes exactly 45, so it's >=, not >.
This problem builds on Selecting & Filtering (~6 min). Pop it open in a new tab if you want a quick recap.