在Python中获取组之间的累积平均值

import pandas as pd
import numpy as np

# 假设有一个包含组和数值的DataFrame
data = pd.DataFrame({'Group': ['A', 'A', 'B', 'B', 'B', 'C', 'C'],
                     'Value': [1, 2, 3, 4, 5, 6, 7]})

# 按照组进行分组
grouped = data.groupby('Group')

# 计算每个组的累积平均值
cumulative_avg = grouped['Value'].cumsum() / grouped.cumcount()

# 将累积平均值添加到原始DataFrame中
data['Cumulative Average'] = cumulative_avg

print(data)

  Group  Value  Cumulative Average
0     A      1            1.000000
1     A      2            1.500000
2     B      3            3.000000
3     B      4            3.500000
4     B      5            4.000000
5     C      6            6.000000
6     C      7            6.500000