如何用Python对1分钟采样数据每30分钟计算10分钟窗口极值差?
时间序列数据计算特定窗口极值差问题
我有一组采样间隔为1分钟的24小时时间序列数据,需要每30分钟计算一次特定10分钟时间窗口内的最大值与最小值的差值,例如计算00:00-00:10、00:30-00:40等区间的(最大值-最小值)。
以下是已编写的初始代码:
import pandas as pd import datetime from datetime import datetime
ts = ['25/02/2023 0:00', '25/02/2023 0:01', '25/02/2023 0:02', '25/02/2023 0:03', '25/02/2023 0:04', '25/02/2023 0:05', '25/02/2023 0:06', '25/02/2023 0:07', '25/02/2023 0:08', '25/02/2023 0:09', '25/02/2023 0:10', '25/02/2023 0:11', '25/02/2023 0:12', '25/02/2023 0:13', '25/02/2023 0:14', '25/02/2023 0:15', '25/02/2023 0:16', '25/02/2023 0:17', '25/02/2023 0:18', '25/02/2023 0:19', '25/02/2023 0:20', '25/02/2023 0:21', '25/02/2023 0:22', '25/02/2023 0:23', '25/02/2023 0:24', '25/02/2023 0:25', '25/02/2023 0:26', '25/02/2023 0:27', '25/02/2023 0:28', '25/02/2023 0:29', '25/02/2023 0:30', '25/02/2023 0:31', '25/02/2023 0:32', '25/02/2023 0:33', '25/02/2023 0:34', '25/02/2023 0:35', '25/02/2023 0:36', '25/02/2023 0:37', '25/02/2023 0:38', '25/02/2023 0:39', '25/02/2023 0:40', '25/02/2023 0:41', '25/02/2023 0:42', '25/02/2023 0:43', '25/02/2023 0:44', '25/02/2023 0:45'] temp = ['1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '70', '71'] df = pd.DataFrame(list(zip(ts, 'temp')), columns = ['ts', 'temp'])
代码运行后输出如下:
ts temp 0 2023-02-25 00:00:00 7.189607 1 2023-02-25 00:01:00 7.185260 2 2023-02-25 00:02:00 7.180914 3 2023-02-25 00:03:00 7.176567 4 2023-02-25 00:04:00 7.172220 ... ... ... 1436 2023-02-25 23:56:00 7.661235 1437 2023-02-25 23:57:00 7.623201
内容的提问来源于stack exchange,提问作者Ashu
相关产品推荐
相关产品推荐

