How do I sum up all the values related to the specific id in a dataframe?

Question

suppose I have columns in a dataframe like this :

id        value
 a           2 
 a           1  
 b           8
 a           0  
 a           2

I have thousands of ids like these. I want to sum all the values with the same id so that I get a dataframe like :

a   5
b   8

How do I do this in pandas?

score 2 · Answer 1 · answered Apr 18 '18 at 16:48

2

You should use .groupby

df.groupby('id').sum()

answered Apr 18 '18 at 16:48

iDrwish

1 Answers1