我有這個數(shù)據(jù)框:對于每個 IMEI,我想檢查是否有后續(xù)DATETIME OF LVD發(fā)生在 12 小時內(nèi)。如果有,則需要將其移除。例如,在此 df 行中,需要刪除 1、6、13、14、15 行。 IMEI DATETIME OF LVD 0 864811031001402 2018-10-04 23:50:00 1 864811031001402 2018-10-05 04:35:00 2 864811031001402 2018-10-15 03:40:00 3 864811031001402 2018-10-21 04:25:00 4 866710038341548 2018-10-27 05:53:00 5 864811031092336 2018-10-17 18:10:00 6 864811031092336 2018-10-17 18:41:00 7 864811031092336 2018-10-21 04:50:00 8 864811031092336 2018-10-23 03:21:00 9 864811031092336 2018-10-24 03:00:00 10 864811031009041 2018-10-13 21:52:00 11 864811031009041 2018-10-27 11:13:00 12 864811031015584 2018-10-27 00:48:00 13 864811031015584 2018-10-28 05:25:00 14 864811031015584 2018-10-28 05:26:00 15 864811031015584 2018-10-28 05:27:00 我可以獲得每條記錄的 delta 時間差(如下),但我如何為每個 IMEI 組做到這一點(diǎn)?df['Delta'] = pd.to_datetime(df['DATETIME OF LVD']).diff() IMEI DATETIME OF LVD Delta0 864811031001402 2018-10-04 23:50:00 NaT1 864811031001402 2018-10-05 04:35:00 0 days 04:45:002 864811031001402 2018-10-15 03:40:00 9 days 23:05:003 864811031001402 2018-10-21 04:25:00 6 days 00:45:004 866710038341548 2018-10-27 05:53:00 6 days 01:28:005 864811031092336 2018-10-17 18:10:00 -10 days +12:17:006 864811031092336 2018-10-17 18:41:00 0 days 00:31:00
添加回答
舉報
0/150
提交
取消