1. Learn
  2. /
  3. Courses
  4. /
  5. Data Transformation with Polars

Connected

Exercise

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.

Instructions

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