Calculating weekly rental totals

Beyond filtering, you often need to aggregate data by time periods. To spot trends across July and compare week-over-week demand, calculate weekly rental totals.

polars is loaded as pl. The DataFrame bikes is available, sorted by time.

This exercise is part of the course

Data Transformation with Polars

View Course

Exercise instructions

Group the data by week using group_by_dynamic().
Calculate the sum of rentals and name it total_rentals.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Group the data by week
bikes.____("time", every="____").agg(
  
    # Calculate the sum of rentals
    pl.col("rentals").____().alias("____")
)

Edit and Run Code