Pandas Groupby and Sum Only One Column

by

The only way to do this would be to include C in your groupby (the groupby function can accept a list).

Give this a try:

df.groupby(['A','C'])['B'].sum()

One other thing to note, if you need to work with df after the aggregation you can also use the as_index=False option to return a dataframe object. This one gave me problems when I was first working with Pandas. Example:

df.groupby(['A','C'], as_index=False)['B'].sum()

More Related Contents:

  1. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  2. Aggregation in Pandas
  3. Groupby value counts on the dataframe pandas
  4. Converting a Pandas GroupBy output from Series to DataFrame
  5. Multiple aggregations of the same column using pandas GroupBy.agg()
  6. Pandas groupby mean – into a dataframe?
  7. Python Pandas max value in a group as a new column
  8. How to loop over grouped Pandas dataframe?
  9. How to access pandas groupby dataframe by key
  10. How to drop duplicates based on two or more subsets criteria in Pandas data-frame
  11. Python Pandas Group by date using datetime data
  12. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  13. Pandas – dataframe groupby – how to get sum of multiple columns
  14. Group dataframe and get sum AND count?
  15. How to summarize on different groupby combinations?
  16. get first and last values in a groupby
  17. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  18. Get the row corresponding to the max in pandas GroupBy [duplicate]
  19. How to get number of groups in a groupby object in pandas?
  20. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?
  21. How to provide a reproducible copy of your DataFrame with to_clipboard()
  22. Combine two columns of text in pandas dataframe
  23. How to apply a function to two columns of Pandas dataframe
  24. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  25. How to reversibly store and load a Pandas dataframe to/from disk
  26. Pandas finding local max and min
  27. python pandas dataframe slicing by date conditions
  28. Python: Removing Rows on Count condition
  29. Remove NaN/NULL columns in a Pandas dataframe?
  30. Group DataFrame in 5-minute intervals

Leave a Comment