Rread excel without formatting date

Question

Pandas 1.1.0 Python 3.8

When i tried to read a excel file with read_excel method

the file is loaded fine, but the excel has date formatting in some columns and pandas change the format automatically

I want to avoid this behavior

Answer 1

You can set the dtypes parameter in read_excel function like

df=pd.read_excel('excel.xlsx', dtypes={'datecolumnname1':str, 'datecolumnnam2':str,...})