Convert object column to datetime column in python

Question

I have a weird format in my objectcolumn in python:

 2020-08-13-09.41.16.474284

How can i convert that column to datetime? I tried:

pd.to_datetime(df['col', format='%Y-%m-%d-%H-%M.%f')

but that leads to an error: ValueError: time data '2020-08-13-10.59.43.324747' does not match format '%Y-%m-%d-%H-%M.%f' (match)

There is typo M - pd.to_datetime(df['col', format='%Y-%m-%D.%H.%M.%f') — jezrael
– jezrael, Commented Dec 1, 2020 at 12:15
see my edit, the %fformat is not correct how can i fix that? — PV8
– PV8, Commented Dec 1, 2020 at 12:16

jezrael · Accepted Answer · 2020-12-01 16:49:45Z

1

You need . for match format:

pd.to_datetime(df['col'], format='%Y-%m-%d-%H.%M.%S.%f')

answered Dec 1, 2020 at 12:17

jezrael

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

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

1 Comment

@MrFuppes Thank you.