How to use groupby to get sum of rows in dataframe

Asked Apr 23 '20 at 13:28

Active Apr 23 '20 at 13:28

Viewed 37 times

I have the following dataframe:

     Location    Month    Unit

0    Loc1        1        5

1    Loc1        1        5 

2    Loc1        2        6

3    Loc2        2        6 

4    Loc2        3        7

5    Loc2        3        7

I figured I could use groupby to get the following output:

     Location    Month    Unit

0    Loc1        1        10

1    Loc1        2        6

2    Loc2        2        6

3    Loc2        3        14

However, I have not figured out how to do this. Any suggestions?

asked Apr 23 '20 at 13:28

grimrol123

2

`df.groupby(['Location', 'Month'], as_index=False)['Unit'].sum()` – Quang Hoang Apr 23 '20 at 13:29
Does this answer your question? [Pandas group-by and sum](https://stackoverflow.com/questions/39922986/pandas-group-by-and-sum) – Mayank Porwal Apr 23 '20 at 14:06
@QuangHoang Thank you, that answers my question. – grimrol123 Apr 23 '20 at 15:55

How to use groupby to get sum of rows in dataframe

0 Answers0