Python pandas groupby aggregate on multiple columns, then pivot

by 
df.groupby('Category').agg({'Item':'size','shop1':['sum','mean','std'],'shop2':['sum','mean','std'],'shop3':['sum','mean','std']})

Or if you want it across all shops then:

df1 = df.set_index(['Item','Category']).stack().reset_index().rename(columns={'level_2':'Shops',0:'costs'})
df1.groupby('Category').agg({'Item':'size','costs':['sum','mean','std']})

More Related Contents:

  1. How to spread a column in a Pandas data frame
  2. Pandas conditional creation of a series/dataframe column
  3. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  4. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  5. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  6. Error: pandas hashtable keyerror
  7. Writing a pandas DataFrame to CSV file
  8. Remove unwanted parts from strings in a column
  9. pandas: How do I split text in a column into multiple rows?
  10. Find row where values for column is maximal in a pandas DataFrame
  11. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  12. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  13. Drop rows containing empty cells from a pandas DataFrame
  14. Why does my Pandas DataFrame not display new order using `sort_values`?
  15. python/pandas: convert month int to month name
  16. How to check if a column exists in Pandas
  17. How to form tuple column from two columns in Pandas
  18. Remove duplicate rows from Pandas dataframe where only some columns have the same value
  19. Convert pandas Series to DataFrame
  20. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  21. How to switch columns rows in a pandas dataframe
  22. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  23. Remove name, dtype from pandas output of dataframe or series
  24. pandas – find first occurrence
  25. How to convert a dataframe to a dictionary
  26. Read CSV into a dataFrame with varying row lengths using Pandas
  27. Filling missing values using forward and backward fill in pandas dataframe (ffill and bfill)
  28. How to open and convert sqlite database to pandas dataframe
  29. Set value on an entire column of a pandas dataframe
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment