Filtering for a time range
Now that you can filter for a single moment, let's filter for a range. To understand the morning commute pattern, find all rows between 7 AM and 10 AM on the first day to analyze the morning rush.
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
- Filter
bikesfor rows wheretimeis between 7 AM and 10 AM on July 1st, 2016.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Filter for morning rush hour (7 AM - 10 AM)
bikes.filter(
pl.col("time").____(
pl.datetime(2016, 7, 1, ____),
pl.datetime(2016, 7, 1, ____)
)
)