1. 时间差=时间戳相减
data['used_time'] = (pd.to_datetime(data['creatDate'], format='%Y%m%d', errors='coerce') -
pd.to_datetime(data['regDate'], format='%Y%m%d', errors='coerce')).dt.days
# dt.days是提取时间戳的日,类似的还有dt.year
2. 转换时间戳
import datetime
# int转换为时间戳
datetime.datetime.strptime(ds,'%Y%m%d')
pd.to_datetime(data['creatDate'], format='%Y%m%d', errors='coerce')
# int转换为时间戳间隔
delta = datetime.timedelta(days=int1)
# unix时间转换为时间戳
def convert_time(x):
return datetime.datetime.fromtimestamp(x)
df['time_insert'] = df['insert_time'].apply(lambda x:convert_time(x))