Practice / window functions
An arcade leaderboard ranks players by score, and ties should share a place with no gaps in the numbering.
scores
Your task: return player, points, and a standing — a dense ranking over points from highest to lowest. Players with equal points share a standing, and standings never skip a number (so the score just below a tie is one higher, not two).
Assign your answer DataFrame to result. Row order doesn't matter.
scoresinput DataFrame| column | type |
|---|---|
| player | string |
| points | long |
| player | points |
|---|---|
| Ada | 30 |
| Ben | 30 |
| Cara | 20 |
| Dan | 10 |
playerpointsstanding· 4 rowsF.dense_rank().over(Window.orderBy(F.col("points").desc())). Tied players
share a standing, and — unlike rank() — the next distinct score is only one
higher, never skipping a number.
This problem builds on Window Functions (~9 min). Pop it open in a new tab if you want a quick recap.