如何计算Python Pandas中的组的移位列

啊啊啊啊啊吖

2019-01-23 阅读量: 1883

我有以下pandas数据帧：

Circuit-ID DATETIME LATE?

78899 07/06/2018 15:30 1

78899 08/06/2018 17:30 0

78899 09/06/2018 20:30 1

23544 12/07/2017 23:30 1

23544 13/07/2017 19:30 0

23544 14/07/2017 20:30 1

我需要计算DATETIME和LATE的移位值？列获得以下结果：

Circuit DATETIME LATE? DATETIME-1 LATE-1

78899 07/06/2018 15:30 1 NA NA

78899 08/06/2018 17:30 0 07/06/2018 15:30 1

78899 09/06/2018 20:30 1 08/06/2018 17:30 0

23544 12/07/2017 23:30 1 NA NA

23544 13/07/2017 19:30 0 12/07/2017 23:30 1

23544 14/07/2017 20:30 1 13/07/2017 19:30 0

0.0000

关注作者

发表评论

啊啊啊啊啊吖

2019-01-23

使用groupby和shift，然后加入它： df.join(df.groupby('Circuit-ID').shift().add_suffix('-1')) Circuit-ID DATETIME LATE? DATETIME-1 LATE?-1 0 78899 07/06/2018 15:30 1 NaN NaN 1 78899 08/06/2018 17:30 0 07/06/2018 15:30 1.0 2 78899 09/06/2018 20:30 1 08/06/2018 17:30 0.0 3 23544 12/07/2017 23:30 1 NaN NaN 4 23544 13/07/2017 19:30 0 12/07/2017 23:30 1.0 5 23544 14/07/2017 20:30 1 13/07/2017 19:30 0.0

0.0000 0 0 回复

CDA考试动态

CDA报考指南

推荐帖子