import pandas as pd
import numpy as np
dic={'id':['a','b','c','d'],
'time1':[20200101,20200102,20200103,20200104],
'time2':['20200101','20200102','20200103','20200104']
}
df=pd.DataFrame(dic)
df['time1']=pd.to_datetime(df['time1'].astype('string'))
df['time2']=pd.to_datetime(df['time2'])
print(df.info())
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/00dc191a11c9957167c1cb7fd451a53d.png)
from datetime import datetime
from dateutil.relativedelta import relativedelta
d=datetime.now()
da=str(d)[:10]
date=datetime.strptime(da,'%Y-%m-%d')
two_year_bf =datetime.strptime(da,'%Y-%m-%d') - relativedelta(days=2)
print(two_year_bf)