0

and I encountered a problem when I was using pandas.to_datetime to convert a column to datetime, could you help me to figure out why? Thank you.

enter image description here

I tried to change the format but I don't know what is wrong.

mozway
  • 194,879
  • 13
  • 39
  • 75
user22234214
  • 1
  • Providing CODE instead of images of it helps to get much faster recommendations from the community.it is one of the reasons that you get Downvote – eng Jul 16 '23 at 05:20
  • Please provide enough code so others can better understand or reproduce the problem. – Community Jul 16 '23 at 07:44

1 Answers1

1

you have a row where the Order Date is literally X, you can ignore errors as in to_date(df[...], format=..., errors='ignore')

Vetsin
  • 2,245
  • 1
  • 20
  • 24