文本样例在最下方,以逗号分隔的情况下,第一列是日期,第二列是精确到秒的时间,
想将第二列统计到分,并且提取第三列在此分钟数出现时的 第一条数据、最后一条数据、分钟内的最大数、分钟内的最小数
第四列第五列只提取 第一条和最后一条 即可
我现在是用循环一条一条数据扯出来对比的,总感觉可以有更好的方法,各位有没有什么好的思路
日期,时间,第三列,第四列,第五列
20240926,15:02:35,7970,369753,280630
20240927,21:12:40,7989,368918,33322
20240927,21:12:41,7990,368918,33323
20240927,21:12:41,7990,368918,33323
20240927,21:12:42,7990,368918,33323
20240927,21:12:42,7990,368918,33331
20240927,21:12:43,7990,368918,33331
20240927,21:12:44,7990,368918,33332
20240927,21:12:45,7989,368917,33333
20240927,21:12:47,7990,368918,33334
20240927,21:12:48,7990,368918,33334
20240927,21:12:48,7990,368918,33338
20240927,21:12:49,7990,368918,33339
20240927,21:12:50,7990,368918,33339
20240927,21:12:51,7989,368917,33340
20240927,21:12:51,7990,368931,33354
20240927,21:12:52,7989,368902,33391
20240927,21:12:53,7989,368903,33392
20240927,21:12:53,7989,368902,33393
20240927,21:12:54,7990,368902,33394
20240927,21:12:54,7990,368902,33394
20240927,21:12:55,7989,368902,33395
20240927,21:12:55,7989,368901,33398
20240927,21:12:57,7990,368902,33399
20240927,21:12:57,7990,368902,33400
20240927,21:12:58,7990,368902,33400
20240927,21:12:58,7989,368908,33415
20240927,21:12:59,7989,368908,33430
20240927,21:12:59,7989,368908,33430
20240927,21:13:00,7988,368944,33485
20240927,21:13:00,7987,368925,33533
20240927,21:13:01,7988,368922,33536
20240927,21:13:01,7988,368898,33573
20240927,21:13:02,7988,368899,33581
20240927,21:13:02,7987,368905,33639
20240927,21:13:03,7987,368923,33702
20240927,21:13:03,7987,368951,33744
20240927,21:13:04,7987,368949,33748
20240927,21:13:04,7987,368950,33757
20240927,21:13:05,7987,368944,33771
|
|