我的数据是从excel中获取的
Invoice Cost centre Invoice Category Price DataFeed Reporting Fequency
RIM Retail QLD 22.25 WEB DWM
R5M Retail SYD 22.25 BWH M
.....
我的数据透视表就像
df = pd.read_excel(file_path, sheet_name='Invoice Details', usecols="E:F,I,L:M")
df['Price'] = df['Price'].astype(float)
df1 = df.groupby(["Invoice Cost Centre", "Invoice Category"]).agg({'Price': 'sum'}).reset_index()
df = pd.pivot_table(df, index=["Invoice Cost Centre", "Invoice Category"],
columns=['Price', 'Reporting Frequency', 'Data Feed'],
aggfunc=len,
fill_value=0)
df2 = df.merge(df1, left_on=["Invoice Cost Centre", "Invoice Category"],
right_on=["Invoice Cost Centre", "Invoice Category"], how='left').fillna(0)
我只想为价格列添加总值。如何在透视表中添加值
预期产出应该是这样的
Invoice Cost Centre Invoice Category (22.25,M,BWH) (40,DWM,WEB)... Price
D3TM Retail QLD 1907.85
EQUITYEMP Retail SYD 104.00
EQUITYEMP 463.15
EQUITYEMP ... 62.40
EQUITYEMP 201.95
**Total=2800**
目前没有回答
相关问题 更多 >
编程相关推荐