ValueError: time data 'X' does not match format '%m/%d/%y %H:%M' (match)

Question

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.

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

Answer 1

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