How to add timezone offset to pandas datetime ?

Question

mydata = [{'datetime' : '2015-09-01 00:00:23.205', 'Timezoneoffset': -5},
      {'datetime' : '2015-09-01 00:41:27.659', 'Timezoneoffset': -6},
      {'datetime' : '2015-09-01 00:13:40.897', 'Timezoneoffset': -1},
      {'datetime' : '2015-09-02 00:42:06.007', 'Timezoneoffset': 5}]
t = pd.DataFrame(mydata)
t.datetime = pd.to_datetime(t.datetime,format='%Y-%m-%d %H:%M:%S.%f')

I would like to create third column which should look like this:

2015-08-31 19:00:23.205
2015-08-31 18:41:27.659
2015-08-31 23:13:40.897
2015-09-01 05:42:06.007

Any help appreciated. Thank you!

EdChum · Accepted Answer · 2016-04-15 13:52:45Z

3

Construct a TimedeltaIndex and add it to the existing datetime column:

In [241]:
t['datetime_off'] = t['datetime'] + pd.TimedeltaIndex(t['Timezoneoffset'], unit='h')
t

Out[241]:
   Timezoneoffset                datetime            datetime_off
0              -5 2015-09-01 00:00:23.205 2015-08-31 19:00:23.205
1              -6 2015-09-01 00:41:27.659 2015-08-31 18:41:27.659
2              -1 2015-09-01 00:13:40.897 2015-08-31 23:13:40.897
3               5 2015-09-02 00:42:06.007 2015-09-02 05:42:06.007

answered Apr 15, 2016 at 13:52

EdChum

397k204 gold badges836 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zero · Accepted Answer · 2016-04-15 13:54:22Z

1

You could convert the type of Timezoneoffset to timedelta64[h] (hours) and then add them

In [105]: t['datetime'] + t['Timezoneoffset'].astype('timedelta64[h]')
Out[105]:
0   2015-08-31 19:00:23.205
1   2015-08-31 18:41:27.659
2   2015-08-31 23:13:40.897
3   2015-09-02 05:42:06.007
dtype: datetime64[ns]

answered Apr 15, 2016 at 13:54

Zero

77.4k22 gold badges153 silver badges153 bronze badges

Collectives™ on Stack Overflow

How to add timezone offset to pandas datetime ?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related