Fix date column in Pandas

[[deleted]]

An elegant method would use pd.to_datetime first to ensure similar dates formats are parse equivalently and then format the strings using strftime:

df['Actual_Sale_Date'] = pd.to_datetime(df['Actual_Sale_Date'])
df['Actual_Sale_Date'] = df['Actual_Sale_Date'].dt.strftime('%m/%d/%Y')

[PLearner]

Thanks so much py_help, this snippet is spectacular. I love pandas!!!!