Format a column for excel date format from Format to Date within python script

Asked Jun 30 '21 at 15:05

Active Jul 01 '21 at 10:30

Viewed 465 times

df.to_excel(filename, index = False)

This is my current code for exporting data frame to an excel, column index 0 and 2 contain dates, but I need these columns to be formatted as an Excel date format. I have read online but I don't understand how to achieve this.

Can someone please explain

import pandas as pd
from datetime import datetime

writer = pd.ExcelWriter(testing.xlsx",  datetime_format='dd/mm/yyyy')

hold.to_excel(writer, "Sheet1", index = False)

writer.close()
print("done")

edited Jul 01 '21 at 10:30

asked Jun 30 '21 at 15:05

George Boast

1

Does this answer your question? [Python Pandas custom time format in Excel output](https://stackoverflow.com/questions/25898839/python-pandas-custom-time-format-in-excel-output) – ifly6 Jun 30 '21 at 15:08
How would you use the answer to target columns 0 and 2 only? – George Boast Jun 30 '21 at 15:12
They apply to all dates – ifly6 Jun 30 '21 at 15:13
I couldn't make this work, do you think you could show me a working example? – George Boast Jun 30 '21 at 15:31
What did you try and what did you get – ifly6 Jun 30 '21 at 15:41
I have added the code in my original post. It does not format the date time variables to a suitable instance in my excel file – George Boast Jun 30 '21 at 16:09
1

@George Boast can you add a sample dataframe (hold) to your example. In the link in the comment above there is a similar example where the formatting clearly works. If it doesn’t work for you it may be that the dates aren’t in datetime format. – jmcnamara Jun 30 '21 at 16:17
I have added a screenshot of data frame hold, with confidential data X out – George Boast Jul 01 '21 at 10:31

Format a column for excel date format from Format to Date within python script

0 Answers0