日期之间的日期时间差异

Question

我有一个这样的df：

  firstdate                seconddate
0 2011-01-01 13:00:00    2011-01-01 13:00:00
1 2011-01-02 14:00:00    2011-01-01 11:00:00
2 2011-01-02 16:00:00    2011-01-02 13:00:00
3 2011-01-04 12:00:00    2011-01-03 15:00:00
...

Seconddate总是在firstdate之前。我想计算firstdate和seconddate之间的天数之差，如果firstdate和seconddate是同一天，则将其设置为列；如果seconddate是firstdate的前一天，则将其设置为difference=0；如果seconddate是firstdate的前一天，则将其设置为difference=1，依此类推直到一周。我该怎么做呢？

Answer 1

df['first'] = pd.to_datetime(df['first'])
df['second'] = pd.to_datetime(df['second'])

df['diff'] = (df['first'] - df['second']).dt.days

这将添加一个带有diff的列。您可以根据它进行删除

df.drop(df[df.diff < 0].index)

# or

df = df[df.diff > 0]