Converting pandas Column to datetime [duplicate]

Question

I am trying to convert a pandas column to datetime. This is my error message.

ValueError: time data '01-JUN-17 00:00:00' does not match format '%d-%b-%y %H.%M.%S' (match)

This is my code :

df['dayofservice'] =  pd.to_datetime(df['dayofservice'], format = '%d-%b-%y %H.%M.%S')

It's still not working for me.

VirtualScooter · Accepted Answer · 2019-07-07 14:44:55Z

4

pandas is man/woman enough to parse this without a format field:

In[90]:
pd.to_datetime('01-JUN-17 00:00:00')

Out[90]: Timestamp('2017-06-01 00:00:00')

So this should work:

df['dayofservice'] =  pd.to_datetime(df['dayofservice'])

VirtualScooter

1,9083 gold badges21 silver badges31 bronze badges

answered Jun 29, 2018 at 14:13

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

Comments

jezrael · Accepted Answer · 2018-06-29 14:12:26Z

0

Change . to : in times like:

df['dayofservice'] =  pd.to_datetime(df['dayofservice'], format = '%d-%b-%y %H:%M:%S')

answered Jun 29, 2018 at 14:12

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges