Ranking albums with tie handling

Your record company publishes an internal leaderboard each week based on the Spotify dataset. Tie handling can change how artists are perceived - several albums share the same listener counts, so you need to compare how different ranking methods handle ties.

polars is loaded as pl. The DataFrame spotify with streaming metrics is preloaded for you.

This exercise is part of the course

Data Transformation with Polars

View Course

Exercise instructions

Create a ranking of monthly_listeners in descending order, aliasing as rank_default.
Add a second ranking with leaderboard-style tie handling, aliasing as rank_min.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Rank albums by monthly_listeners with default and min tie handling
result = spotify.with_columns(
    pl.col("monthly_listeners")
    .____(descending=____)
    .alias("rank_default"),

    pl.col("monthly_listeners")
    .rank(method="____", ____=True)
    .alias("rank_min"),
).sort("rank_default")

print(result.head())

Edit and Run Code