我有一个数据集,有主题,有时间,也有时间。我想计算每个特定主题在外出时间和下一次入住时间之间的时间(如再入院时间)。对于每个主题,它可能有几个不同的访问。那我怎么计算呢
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
预期结果: 两次访问之间的时间:骑士:30天,恶魔:60天,国王:10天,20天,30天,皇室:40天,50天
目前没有回答
相关问题 更多 >
编程相关推荐