user date parser in pandas read_excel date_parser example
Example 1: date parser python pandas
format='%d%m%Y'
Example 2: date parser python pandas
import pandas as pd
values = {'dates': ['20190902','20190913','20190921'],
'status': ['Opened','Opened','Closed']
}
df = pd.DataFrame(values, columns = ['dates','status'])
print (df)
print (df.dtypes)