Working with time in different time zones
Some organizations operate internationally; therefore, the information they collect about events may be recorded alongside the time zone of the area where the event took place. To be able to compare events that occurred across different time zones, we need to set all of the variables within the same zone. In this recipe, we will learn how to unify the time zones of a datetime
variable and then learn how to reassign a variable to a different time zone using pandas.
How to do it...
To proceed with this recipe, we must import pandas and then create a toy DataFrame with two variables, each one containing a date and time in different time zones:
- Import
pandas
:import pandas as pd
- Let’s create a toy DataFrame with one variable with values in different time zones:
df = pd.DataFrame() df['time1'] = pd.concat([ pd.Series( pd.date_range( ...