I am trying to convert date from "16-Dec-21" format to "2021-12-01" format using Pandas in Python in a CSV file. Here's the table:

Here's my code:

ds_com['Date'] = pd.to_datetime(ds_com['Date']).dt.strftime('%Y-%m-%d')

I've also tried

ds_com['Date'] = ds_com['Date'].dt.strftime('%Y-%m-%d')

But it also didn't work.

The new table should look like this:

The table has hundreds of rows.

The current output shows as this when I open the ds_com.csv file in Excel:

The output shows correctly for

print(ds_com['Date'][1])

Thank you.

CodePudding user response：

You could try this. It would cause excel to not auto format

ds_com['Date'] = pd.to_datetime(ds_com['Date']).dt.strftime('="%Y-%m-%d"')