问为数据帧中的每个循环获取最后三条记录
EN

Stack Overflow用户

提问于 2022-06-22 06:14:07

回答 1查看 36关注 0票数 1

我有如下所示的数据格式：

    User           Warehouse    R_Number    Date    Missing
0   Delhi_Goa    Goa Warehouse  5046    2022-05-24  TRRFF.1T22AD0041
1   Delhi_Goa    Goa Warehouse  5046    2022-05-24  PPRFP.1T22AD0017
2   Delhi_Goa    Goa Warehouse  5048    2022-05-24  TRRFF.1T22AD0031
3   Delhi_Goa    Goa Warehouse  5048    2022-05-24  TRRFF.1T22AD0037
4   Delhi_Goa    Goa Warehouse  5048    2022-05-24  PPRFP.1T22AD0039
5   Delhi_Goa    Goa Warehouse  5048    2022-05-24  TRRFF.1T22AD0026

我希望遍历DataFrame，并对结果将依赖于最后三条记录的每一行执行操作。

就像。

Loop 1 to fetch index 0 
loop 2 to fetch index 0,1
loop 3 to fetch index 0,1,2
loop 4 to fetch index 1,2,3
loop 5 to fetch index 2,3,4
loop 6 to fetch index 3,4,5

我如何循环最后三张唱片的数据？

python

pandas

回答 1

Stack Overflow用户

回答已采纳

发布于 2022-06-22 06:19:54

使用DataFrame.rolling

for g in df.rolling(3):
    print (g)

   User                Warehouse  R_Number        Date           Missing
0     0  Delhi_Goa Goa Warehouse      5046  2022-05-24  TRRFF.1T22AD0041
   User                Warehouse  R_Number        Date           Missing
0     0  Delhi_Goa Goa Warehouse      5046  2022-05-24  TRRFF.1T22AD0041
1     1  Delhi_Goa Goa Warehouse      5046  2022-05-24  PPRFP.1T22AD0017
   User                Warehouse  R_Number        Date           Missing
0     0  Delhi_Goa Goa Warehouse      5046  2022-05-24  TRRFF.1T22AD0041
1     1  Delhi_Goa Goa Warehouse      5046  2022-05-24  PPRFP.1T22AD0017
2     2  Delhi_Goa Goa Warehouse      5048  2022-05-24  TRRFF.1T22AD0031
   User                Warehouse  R_Number        Date           Missing
1     1  Delhi_Goa Goa Warehouse      5046  2022-05-24  PPRFP.1T22AD0017
2     2  Delhi_Goa Goa Warehouse      5048  2022-05-24  TRRFF.1T22AD0031
3     3  Delhi_Goa Goa Warehouse      5048  2022-05-24  TRRFF.1T22AD0037
   User                Warehouse  R_Number        Date           Missing
2     2  Delhi_Goa Goa Warehouse      5048  2022-05-24  TRRFF.1T22AD0031
3     3  Delhi_Goa Goa Warehouse      5048  2022-05-24  TRRFF.1T22AD0037
4     4  Delhi_Goa Goa Warehouse      5048  2022-05-24  PPRFP.1T22AD0039
   User                Warehouse  R_Number        Date           Missing
3     3  Delhi_Goa Goa Warehouse      5048  2022-05-24  TRRFF.1T22AD0037
4     4  Delhi_Goa Goa Warehouse      5048  2022-05-24  PPRFP.1T22AD0039
5     5  Delhi_Goa Goa Warehouse      5048  2022-05-24  TRRFF.1T22AD0026

票数 3

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/72710490

复制

相似问题

问为数据帧中的每个循环获取最后三条记录
EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问为数据帧中的每个循环获取最后三条记录EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问为数据帧中的每个循环获取最后三条记录
EN