Pandas converting date time in string to datetime format [duplicate]

Question

I have a column in Pandas dataframe which is a datetime entry column in string. I have tried using the the syntax but it gives rise to this error.

Syntax

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

Error
time data '2020-11-01 16:23:12' does not match format '%y-%m-%d %H:%M:%S'

Mattew · Accepted Answer · 2022-02-28 03:57:23Z

1

Yes, you've used the wrong format for the year.

pd.to_datetime(df["Datetime"], format="%Y-%m-%d %H:%M:%S")

answered Feb 28, 2022 at 3:57

Mattew

112 bronze badges

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

Comments

Rahmat Fathoni · Accepted Answer · 2022-02-28 03:36:21Z

0

Try %Y,

this is the cheatsheet: https://strftime.org/

answered Feb 28, 2022 at 3:36

Rahmat Fathoni

1,5001 gold badge5 silver badges10 bronze badges