使用pandas确定滚动平均值是增加还是减少

import pandas as pd

# 示例数据
data = {'values': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]}
df = pd.DataFrame(data)

# 计算滚动平均值（例如，窗口大小为3）
window_size = 3
df['rolling_mean'] = df['values'].rolling(window=window_size).mean()

# 计算滚动平均值之间的差异
df['mean_diff'] = df['rolling_mean'].diff()

# 确定滚动平均值是增加还是减少
df['is_increasing'] = df['mean_diff'] > 0

print(df)

   values  rolling_mean  mean_diff  is_increasing
0       1          NaN        NaN         False
1       2          NaN        NaN         False
2       3          2.0        NaN         False
3       4          3.0        1.0          True
4       5          4.0        1.0          True
5       6          5.0        1.0          True
6       7          6.0        1.0          True
7       8          7.0        1.0          True
8       9          8.0        1.0          True
9      10          9.0        1.0          True