How to convert datetime into GMT +7 in Python?

Question

I have a dataframe that looks like that:

 conversation__created_at
0 2020年10月15日T03:39:42.766773+00:00
1 2020年10月14日T11:24:33.831177+00:00
2 2020年10月14日T08:29:44.192258+00:00
3 2020年10月14日T01:42:06.674313+00:00
4 2020年10月13日T12:57:04.218184+00:00

How to convert it into GMT +7?

Answer 1

I assume you have a pandas series because the data you posted looks like one. Then you can use tz_convert, i.e.

import pandas as pd
pd.to_datetime('2020-10-15T03:39:42.766773+00:00').tz_convert('Etc/GMT+7')

As pointed out in the comments, since the datetime carries a T in it, it is of string format, thus we need to convert to datetime first and then convert to the correct timezone.

pd.to_datetime(series).dt.tz_convert('Etc/GMT+7')

• FObersteiner: the OP's input is of dtype string since there still is the 'T' separator between date and time, so pd.to_datetime presumably is required ;-)
• Stefan: @MrFuppes, thanks for pointing that out. I never noticed that T is actually indicating string fromat. I updated my answer.
• FObersteiner: oh and there's one more caveat; 'Etc/GMT+7' is UTC-7 (not +7). not sure what the OP expects here. would be easier if a certain time zone was named.
• ab.trubex: so what's the syntax for +7 (Jakarta)?
• Stefan: @ab.trubex There is the timezone Asia/Jakarta, so you can use this one.

Answer 2

You can use datetime library only.

from datetime import datetime, timedelta, timezone
d = datetime.fromisoformat("2020年10月15日T03:39:42.766773+00:00")
tz = timezone(timedelta(hours=7))
new_time = d.astimezone(tz)

• ab.trubex: how to collaborate it in pandas? do we need for loop?
• HK boy: With a list of time, you can use for loop. This snippet doesn't need pandas.

Answer 3

you can use pytz to set timezone for your datetime instance

for example:

from pytz import timezone
from datetime import datetime
date = datetime.now()
print(date)
tz = timezone("Etc/GMT+7")
date = date.replace(tzinfo=tz)
print(date)

out put:

2020年10月26日 10:33:25.934699
2020年10月26日 10:33:25.934699-07:00

Answer 4

You can apply pytz.timezone on the df

from pytz import timezone
from datetime import datetime
def myDate(x): 
 tz = timezone("Etc/GMT+7")
 dt = x.replace(tzinfo=tz)
 return dt
df['conversation__created_at'] = df.apply(lambda row: myDate(row['conversation__created_at'].to_pydatetime()))

• ab.trubex: once more things, i add df = pd.read_csv('filename.csv')
• FObersteiner: besides that there is a pandas built-in for this task, I think you shouldn't suggest to use replace here. Although this works for static offsets, it causes wrong offsets (LMT) for actual time zones, see pytz localize vs. replace.