Converting streams to billions

You are a data analyst at a record company. You have a Spotify dataset containing 25 popular albums with streaming metrics such as total plays, monthly listeners, and popularity scores. The streams column shows total plays as large integers that are hard to read, so you need to convert them to billions using a custom Python function.

polars is loaded as pl. The DataFrame spotify and a to_billions() function are preloaded for you.

Diese Übung ist Teil des Kurses

Data Transformation with Polars

Kurs anzeigen

Anleitung zur Übung

Apply to_billions to the streams column to create a new column called streams_billions.
Specify the return type as pl.Float64 for explicit type control.

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

# Apply to_billions to the streams column
result = spotify.with_columns(
    pl.col("streams").____(
        ____, return_dtype=____
    ).alias("streams_billions")
)

print(result.head())

Code bearbeiten und ausführen