CODEWITHSUNDEEP
pythondatetime
Nobody
Nobody

Reputation: 77

time data does not match format (match)

I got the following error:

time data '23-MAY-2019 12:49:08' does not match format '%d-%m-%yyyy %H:%M:%S' (match)

this is my code:

dfbaseline['Date'] = pd.to_datetime(dfbaseline['Date'], format='%d-%m-%yyyy %H:%M:%S')

What's wrong?

Upvotes: 0

Views: 85

Answers (2)

user459872
user459872

Reputation: 24592

There are two problems with your date format.

pd.to_datetime(dfbaseline['Date'], format='%d-%m-%yyyy %H:%M:%S')
                                              ^^^^^^^^
  • %m is used to match Month in a zero-padded decimal number format(01 to 12).
  • %y will match year without century as a zero-padded decimal number(00, 01, …, 99)

So you have to change,

  • %b to match Month in a locale’s abbreviated name(Jan/Feb/Mar etc)
  • %Y to match Year with century as a decimal number(0001, 0002, …, 2013, 2014, …, 9998, 9999)
pd.to_datetime(dfbaseline['Date'], format='%d-%b-%Y %H:%M:%S')
                                              ^^^^^

See strftime() and strptime() Format Codes for more information.

Upvotes: 1

Rohit Prajapati
Rohit Prajapati

Reputation: 1

You can check out here, Different characters for formatting a DateTime as a string - https://www.ibm.com/docs/en/app-connect/11.0.0?topic=function-formatting-parsing-datetimes-as-strings#:~:text=Characters%20for%20formatting%20a%20dateTime%20as%20a%20string

Upvotes: 0

Related Questions