I read a large Excel file into pandas using read_excel, and the file has date columns. When read into pandas, the dates default to a timestamp. Since the file is large, I would like to read the dates as a string. If that is not possible, then I would at least like to export the date back to Excel in the same format as it is in the original file (e.g. "8/18/2009"). My two questions are: Can I avoid converting the Excel date into a timestamp in pandas? If not possible, how can I write back the date in the original format efficiently? Continue reading...
