Python:计算需要从数据帧中分组的值的5年滚动CAGR

import pandas as pd
import numpy as np

df = pd.DataFrame({'year': [2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019],
                   'value': [100, 120, 150, 180, 200, 230, 250, 280, 300, 330]})

window = 5
df['cagr'] = ((df['value'] / df['value'].shift(window)) ** (1 / window) - 1) * 100
df['cagr'] = df['cagr'].round(2)  # 保留两位小数

print(df)