I have a excel sheet, which i am reading using Python. There's a date column, where the data is in below format:
2017/10/02 13:51:39 BST
2017/11/08 19:55:11 GMT
I need to convert the data to GMT format itself. Any ways to do so?
Asked
Active
Viewed 38 times
0
-
What is BST here? – cs95 Nov 20 '17 at 07:38
-
You need `df['date'] = pd.to_datetime(df['date'])` if need convert `date` column. – jezrael Nov 20 '17 at 07:41
-
Looks like it is British Summer Time. – Anton vBR Nov 20 '17 at 07:53
-
Have a look here: https://stackoverflow.com/questions/12855586/in-python-how-do-i-convert-a-datetime-in-a-specific-local-time-not-my-local-to – Anton vBR Nov 20 '17 at 08:06
-
Yes, BST is british summer time which is 1 hour ahead of GMT. – Zephyr India Nov 20 '17 at 08:53
1 Answers
0
I think you need replace by dict with to_datetime:
df = pd.DataFrame({'date': ['2017/10/02 13:51:39 BST', '2017/11/08 19:55:11 GMT']})
d = {'BST':'+0100', 'GMT':'+0000'}
df['date'] = pd.to_datetime(df['date'].replace(d, regex=True))
print (df)
date
0 2017-10-02 12:51:39
1 2017-11-08 19:55:11
jezrael
- 822,522
- 95
- 1,334
- 1,252