I am having a binary excel file which is having datetime columns. While reading through pandas read_excel date time values are automatically converted into integers.
How to read it with datetime values. I want to apply function while reading the file itself from the source.
Manually converting each column will be lengthy and in-efffective
Week_start_date and week_end are date time columns
