Calculating a rolling sum

Continuing with the London bike-sharing data, hourly rental counts can jump dramatically from one hour to the next, making it hard to spot trends. Rolling statistics smooth out this noise by summing over a window of consecutive rows.

polars is loaded as pl. The DataFrame bikes is available with columns time, rentals, and temp.

Diese Übung ist Teil des Kurses

<Kurs>Data Transformation with Polars</Kurs>

Kurs ansehen

Übungsanweisungen

Add a column rolling_total with the 3-hour rolling sum of rentals.

Interaktive praktische Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

# Add a 3-hour rolling sum of rentals
bikes.with_columns(
    pl.col("rentals").____(window_size=____).alias("____")
)

Code bearbeiten und ausführen