开始使用免费开始使用

Calculating popularity quantiles

You're continuing to analyze the Spotify dataset containing 25 popular albums with metrics like streams, monthly_listeners, and popularity. The marketing team needs clear tiers for underperforming, typical, and breakout albums. Calculate percentiles to help the team understand how popularity is distributed.

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

本练习是课程的一部分

Data Transformation with Polars

查看课程

练习说明

  • Select the popularity column and calculate the 25th percentile, aliasing it as q25_popularity.
  • Add the 50th and 75th percentiles to the appropriate aliases.

交互式实操练习

通过完成这段示例代码来试试这个练习。

# Calculate the 25th, 50th, and 75th percentiles of popularity
result = spotify.select(
    pl.col("____").____(0.25).alias("q25_popularity"),
    pl.col("popularity").quantile(____).alias("q50_popularity"),
    pl.col("popularity").quantile(____).alias("q75_popularity"),
)

print(result)
编辑并运行代码