如何计算相同特定属性的两个单元格所在的两行之间的日期和时间差异?

2024-09-27 23:23:57 发布

您现在位置:Python中文网/ 问答频道 /正文

我有一个数据集,有主题,有时间,也有时间。我想计算每个特定主题在外出时间和下一次入住时间之间的时间(如再入院时间)。对于每个主题,它可能有几个不同的访问。那我怎么计算呢

ipl_data = {'Subject': ['Riders', 'Riders', 'Devils', 'Devils', 'Kings',
   'Kings', 'Kings', 'Kings', 'Royals', 'Royals', 'Royals'],
   'In_time': ['2152-09-03 07:15:00', "2156-10-18 19:34:00",'2185-07-18 16:46:00','2190-02-23 05:23:00','2131-04-30 07:15:00',\
               '2131-05-12 19:49:00' ,'2134-05-10 11:30:00','2196-12-06 07:13:00','2198-08-02 04:49:00','2198-11-01 22:36:00',\
              '2199-10-20 12:05:00'],
   'Out_time': ['2152-09-08 19:10:00','2156-10-25 14:00:00','2185-07-20 16:00:00','2190-02-25 20:20:00','2131-05-08 14:00:00',\
                '2131-05-25 13:30:00','2134-05-20 13:16:00','2197-01-03 14:00:00','2198-10-26 14:55:00','2198-11-14 14:20:00',\
               '2199-10-23 17:30:00']}
df = pd.DataFrame(ipl_data)
df

enter image description here

预期结果: 两次访问之间的时间:骑士:30天,恶魔:60天,国王:10天,20天,30天,皇室:40天,50天


Tags: 数据indf主题datatime时间out

热门问题