python - 遍历日期列表并计算每个间隔之间的天数

Question

如果有人问过这个问题，我很抱歉，但我无法找到解决我的问题的可行方法。我想计算日期列表的每个间隔之间的日期数，看起来像

dates: 

['06/02/2008', '07/01/2008', '10/12/2007', '05/11/2007', '09/10/2007', '10/09/2007', 
'06/08/2007', '10/07/2007', '04/06/2007', '08/05/2007', '10/04/2007', '12/03/2007',
'05/02/2007', '08/01/2007', '11/12/2006', '06/11/2006', '10/10/2006', '05/09/2006',
 '07/08/2006', '10/07/2006', '05/06/2006', '08/05/2006', '10/04/2006', '13/03/2006',
 '06/02/2006', '09/01/2006', '05/12/2005', '07/11/2005', '11/10/2005', '06/09/2005',
'08/08/2005', '11/07/2005', '06/06/2005', '09/05/2005', '04/04/2005', '07/03/2005',
 '09/02/2005']

我曾尝试做类似delta = dates - dates.shift(-1)但没有成功。我想要得到的结果是一个名为 delta 的列表，我收集了每个间隔之间的天数。例如，第一个差异 '06/02/2008' - '07/01/2008' = 30 天。日期格式为'dd/mm/yyyy'

感谢您的帮助!

Answer 1

可以先转换to_datetime然后减去所有没有 first 的值和所有没有 last 的值:

dates = pd.to_datetime(dates, format='%d/%m/%Y')
delta =  dates[:-1] - dates[1:]
print (delta)
TimedeltaIndex(['30 days', '28 days', '35 days', '27 days', '29 days',
                '35 days', '27 days', '36 days', '27 days', '28 days',
                '29 days', '35 days', '28 days', '28 days', '35 days',
                '27 days', '35 days', '29 days', '28 days', '35 days',
                '28 days', '28 days', '28 days', '35 days', '28 days',
                '35 days', '28 days', '27 days', '35 days', '29 days',
                '28 days', '35 days', '28 days', '35 days', '28 days',
                '26 days'],
               dtype='timedelta64[ns]', freq=None)

如果需要整数，请添加 TimedeltaIndex.days :

delta =  (dates[:-1] - dates[1:]).days
print (delta)
Int64Index([30, 28, 35, 27, 29, 35, 27, 36, 27, 28, 29, 35, 28, 28, 35, 27, 35,
            29, 28, 35, 28, 28, 28, 35, 28, 35, 28, 27, 35, 29, 28, 35, 28, 35,
            28, 26],
           dtype='int64')

---

delta =  (dates[:-1] - dates[1:]).days.tolist()
print (delta)
[30, 28, 35, 27, 29, 35, 27, 36, 27, 28, 29, 35, 28, 28, 35, 27, 35, 29, 28, 
 35, 28, 28, 28, 35, 28, 35, 28, 27, 35, 29, 28, 35, 28, 35, 28, 26]