Practice / selecting and filtering
Waveform wants a tidied-up view of its catalog with friendlier column names.
You have the tracks DataFrame:
Your task: return exactly three columns:
song — the track's titleperformer — the track's artistminutes — the duration_sec converted to minutes (duration_sec / 60)Assign your answer DataFrame to result. Row order doesn't matter.
tracksinput DataFrame| column | type |
|---|---|
| track_id | long |
| title | string |
| artist | string |
| duration_sec | long |
| track_id | title | artist | duration_sec |
|---|---|---|---|
| 1 | Neon Skyline | The Glassbirds | 210 |
| 2 | Paper Moons | Ada Vale | 180 |
| 3 | Undertow | The Glassbirds | 240 |
| 4 | Slow Static | Marlow | 150 |
songperformerminutes· 4 rowsInside one select, rename with .alias(...) and build the new column with an
expression: (F.col("duration_sec") / 60).alias("minutes").
This problem builds on Selecting & Filtering (~6 min). Pop it open in a new tab if you want a quick recap.