import pandas as pd
import datetime
data_tr=pd.read_excel('D:\\train.xlsx')
data_tr
data_tr.columns
data_tr['合同签订时间']
def date_tran(dates):
delta=datetime.timedelta(days=dates)
date_1=datetime.datetime.strptime('1899-12-30','%Y-%m-%d')+delta
return datetime.datetime.strftime(date_1,'%Y-%m-%d')