Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement