根据另一个日期列及其pandas中的第一个日期计算时间(以天为单位

import pandas as pd

# 创建一个示例DataFrame
df = pd.DataFrame({'date1': ['2022-01-01', '2022-02-01', '2022-03-01'],
                   'date2': ['2022-01-10', '2022-02-05', '2022-03-15']})

# 将date1和date2列转换为日期类型
df['date1'] = pd.to_datetime(df['date1'])
df['date2'] = pd.to_datetime(df['date2'])

# 计算时间差
df['time_diff'] = df['date2'] - df['date1']
df['time_diff_days'] = df['time_diff'].dt.days

print(df)

       date1      date2 time_diff  time_diff_days
0 2022-01-01 2022-01-10    9 days               9
1 2022-02-01 2022-02-05    4 days               4
2 2022-03-01 2022-03-15   14 days              14