Putting the bike trips into the right time zone

Instead of setting the timezones for W20529 by hand, let's assign them to their IANA timezone: 'America/New_York'. Since we know their political jurisdiction, we don't need to look up their UTC offset. Python will do that for us.

This exercise is part of the course

Working with Dates and Times in Python

View Course

Exercise instructions

  • Import tz from dateutil.
  • Assign et to be the timezone 'America/New_York'.
  • Within the for loop, set start and end to have et as their timezone (use .replace()).

Hands-on interactive exercise

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

# Import tz
from ____ import ____

# Create a timezone object for Eastern Time
et = tz.____('America/New_York')

# Loop over trips, updating the datetimes to be in Eastern Time
for trip in onebike_datetimes[:10]:
  # Update trip['start'] and trip['end']
  trip['start'] = trip['start'].____
  trip['end'] = trip['end'].____