How to add multiple rows on dataframe based on a column of distinct values? pandas/python

Asked Jan 10 '18 at 19:34

Active Jan 10 '18 at 19:34

Viewed 216 times

So i have a pandas data frame with a few numeric columns and an id column thats a string in Python

id  a1  a2 a3 a4 
abc 23 33  33 string
dbc 2  3   3 string
abc 3  4   100 string

i want to add all the numeric columns for the same id string.

 id  a1 a2 a3  a4 
 abc 26 37 133 string
 dbc 2  3   3  string

Is there an elegant way if doing it in pandas or do i have to make a unique list of objects in the first column and loop through them and add them?

asked Jan 10 '18 at 19:34

user1775614

What happens to the strings? Are they always the same for rows with the same `id`? – pault Jan 10 '18 at 19:36
Use `groupby` and `agg`. – cs95 Jan 10 '18 at 19:36
I don't care about the string column - i only need the numeric totals. I guess I shouldn't have added that column.. – user1775614 Jan 10 '18 at 19:36

0 Answers0