Pandas groupby使用选择行中的时间窗口

import pandas as pd

# 创建一个包含时间序列的DataFrame
data = pd.DataFrame({'timestamp': pd.date_range('2022-01-01', periods=10, freq='H'),
                     'value': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]})

# 将timestamp列设置为索引
data.set_index('timestamp', inplace=True)

# 按天进行重采样，计算每天的总和
daily_sum = data.resample('D').sum()
print(daily_sum)

            value
timestamp       
2022-01-01     6
2022-01-02    15
2022-01-03    24

# 使用rolling方法选择滑动窗口内的数据
window_size = 3
rolling_sum = data.rolling(window_size).sum()
print(rolling_sum)

                     value
timestamp                 
2022-01-01 00:00:00    NaN
2022-01-01 01:00:00    NaN
2022-01-01 02:00:00    6.0
2022-01-01 03:00:00    9.0
2022-01-01 04:00:00   12.0
2022-01-01 05:00:00   15.0
2022-01-01 06:00:00   18.0
2022-01-01 07:00:00   21.0
2022-01-01 08:00:00   24.0
2022-01-01 09:00:00   27.0