Pandas to_datetime() issue with specific datetime format

Question

I would like to convert my dataframe from this string to a usable date-time format

01/May/2016:06:38:13 +0100

I'm currently using Python V 3.5.1 :: Anaconda 4.0.0(64-bit)

score 1 · Accepted Answer · edited May 23 '17 at 12:22

1

import time
from time import mktime
from datetime import datetime
df.time = df.time.apply(lambda x: datetime.fromtimestamp(mktime(time.strptime(x, '%d/%b/%Y:%I:%M:%S %z'))))

http://pandas.pydata.org/pandas-docs/stable/generated/pandas.to_datetime.html https://docs.python.org/3.5/library/datetime.html#strftime-and-strptime-behavior How do you convert a Python time.struct_time object into a datetime object?

edited May 23 '17 at 12:22

Community

1
1

answered Jul 18 '16 at 10:39

Alexey Shekhirin

126
7

ValueError: 'z' is a bad directive in format '%d/%b/%Y:%I:%M:%S %z' – SerialDev Jul 18 '16 at 10:43
2

The 'z' directive is currently not supported by pandas `to_datetime` (https://github.com/pydata/pandas/issues/13486) – joris Jul 18 '16 at 10:45
@CMari check it out again – Alexey Shekhirin Jul 18 '16 at 11:09

score 1 · Answer 2 · edited May 23 '17 at 11:44

1

From Joris comment this should do it using dateutil:

from dateutil.parser import parse
a='01/May/2016:06:38:13 +0100'

In[27]:parse(a.replace(':', ' ', 1))
Out[27]: datetime.datetime(2016, 5, 1, 6, 38, 13, tzinfo=tzoffset(None, 3600))

edited May 23 '17 at 11:44

Community

1
1

answered Jul 18 '16 at 11:13

shivsn

7,680
1
26
33

Pandas to_datetime() issue with specific datetime format

2 Answers2