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.
Bu egzersiz
Data Transformation with Polars
kursunun bir parçasıdırEgzersiz talimatları
- Add a column
rolling_totalwith the 3-hour rolling sum ofrentals.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
# Add a 3-hour rolling sum of rentals
bikes.with_columns(
pl.col("rentals").____(window_size=____).alias("____")
)