python-3.x - 如何使用 groupby 计算 vwap（交易量加权平均价格）？

Question

我想计算每个月的 VWAP 值（即每个创建的组）。

data['Month'] = pd.DatetimeIndex(data['Date']).month
data.head()
data['Year'] = pd.DatetimeIndex(data['Date']).year
data.head()
group = data.groupby(['Month', 'Year'])
group.first() 
data['VWAP'] = (np.cumsum(data['Close Price' * data['Total Traded 
Quantity']) / np.cumsum(data['Total Traded Quantity']))

AttributeError：“DataFrame”对象没有属性“数量”

标签： python-3.xpandasmachine-learning

Answer 1

你忘记在数据['收盘价']之后写']'，这是我的代码

df['Month'] = pd.DatetimeIndex(df['Date']).month
df['Year'] = pd.DatetimeIndex(df['Date']).year
group = df.groupby(['Month', 'Year'])
df['VWAP'] = (np.cumsum(df['Close Price'] * df['Total Traded Quantity']) / np.cumsum(df['Total Traded Quantity']))

谢谢...