Calculating rental period end times
Now that you can extract time components, let's manipulate the timestamps themselves. Each bike rental in London lasts up to 45 minutes before incurring extra charges. To analyze when bikes become available again, calculate the end time for each rental period by adding 45 minutes to the start time.
polars is loaded as pl. The DataFrame bikes is available with the time column as a Datetime.
This exercise is part of the course
Data Transformation with Polars
Exercise instructions
- Add a column
period_endby offsetting thetimecolumn forward by 45 minutes.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Calculate when each rental period ends
bikes.with_columns(
pl.col("time").____.____("____").alias("____")
)