有没有办法更改数据透视表的边距“All”列位置?

2024-09-27 07:33:45 发布

您现在位置:Python中文网/ 问答频道 /正文

我没能找到一个合适的解决办法,所以决定在这里问。我只想更改“All”列并将其放在“values”列的开头(在CPU之前)。有办法吗?你知道吗

可复制代码:

df = pd.DataFrame({'Rep': ['Wendy Yule','Wendy Yule','Wendy Yule','Wendy Yule','Cedric Moss','Cedric Moss','Cedric Moss','Cedric Moss','John Smith','John Smith','Daniel Hilton','Daniel Hilton','Daniel Hilton','Craig Booker','Craig Booker','Craig Booker','Craig Booker'], 
               'Manager': ['Fred Anderson','Fred Anderson','Fred Anderson','Fred Anderson','Fred Anderson','Fred Anderson','Fred Anderson','Fred Anderson','Debra Henley','Debra Henley','Debra Henley','Debra Henley','Debra Henley','Debra Henley','Debra Henley','Debra Henley','Debra Henley'],
               'Product': ['Monitor','CPU','CPU','Maintenance','Software','Maintenance','CPU','CPU','CPU','Maintenance','Software','CPU','CPU','CPU','Maintenance','Software','CPU'],
               'Price': [5000,65000,100000,7000,10000,5000,30000,65000,35000,5000,10000,40000,65000,35000,5000,10000,30000]})

df = pd.pivot_table(df,index=["Manager","Rep"],values=["Price"],
           columns=["Product"],aggfunc=[np.sum],fill_value=0,margins=True)

df = df.reset_index()
df


Tags: dfmaintenancecpufredandersondanielmosshilton

热门问题