大熊猫用月平均值代替日观测值

Question

假设我有一个每天观察的熊猫系列:

pd_series = pd.Series(np.random.rand(26281), index = pd.date_range('2022-01-01', '2024-12-31', freq = 'H'))
pd_series
2022-01-01 00:00:00    0.933746
2022-01-01 01:00:00    0.588907
2022-01-01 02:00:00    0.229040
2022-01-01 03:00:00    0.557752
2022-01-01 04:00:00    0.798649

2024-12-30 20:00:00    0.314143
2024-12-30 21:00:00    0.670485
2024-12-30 22:00:00    0.300531
2024-12-30 23:00:00    0.075403
2024-12-31 00:00:00    0.716685

我想要的是用月平均值代替每个观测值。我知道平均值可以计算为

pd_series.resample('MS').mean()

但是我如何把观察结果放到各自的观察结果中呢?

Answer 1

使用Resampler.transform:

print (pd_series.resample('MS').transform('mean'))
2022-01-01 00:00:00    0.495015
2022-01-01 01:00:00    0.495015
2022-01-01 02:00:00    0.495015
2022-01-01 03:00:00    0.495015
2022-01-01 04:00:00    0.495015

2024-12-30 20:00:00    0.508646
2024-12-30 21:00:00    0.508646
2024-12-30 22:00:00    0.508646
2024-12-30 23:00:00    0.508646
2024-12-31 00:00:00    0.508646
Freq: H, Length: 26281, dtype: float64