pandas sum duplicated rows by column

Asked Nov 18 '19 at 12:34

Active Nov 18 '19 at 13:08

Viewed 48 times

i stuck with such problem: i have dataset:

   Name   Year   patent_count   authors
3  Riti   2010        3            2
4  Riti   2010        3            3
5  Aadi   2012        2            1 
6  Aadi   2012        2            3

and i need to groupby this dataframe by Name, Year, patent_count and sum authors to get in conclusion Dataframe like this:

   Name   Year   patent_count   authors
3  Riti   2010        3            5
6  Aadi   2012        2            4

i tried to do it usind pandas groupby.sum(), but it doesn't work

this is real dataset this what i get after group by

edited Nov 18 '19 at 12:48

asked Nov 18 '19 at 12:34

GrandConyon

2

Use `df.groupby(['Name','Year','patent_count']).sum()` – jezrael Nov 18 '19 at 12:35
it doesn't work – GrandConyon Nov 18 '19 at 12:38
Can you create [minimal, complete, and verifiable example](http://stackoverflow.com/help/mcve) ? – jezrael Nov 18 '19 at 12:38
i add images of my real dataset – GrandConyon Nov 18 '19 at 12:49
idk why, but variables authors, publications, forein publications, journal publications drops from dataframe instead of sum – GrandConyon Nov 18 '19 at 12:53
try `df.groupby(['Name','Year','patent_count']).sum().reset_index()` – Pyd Nov 18 '19 at 13:00
Please check new dupe. – jezrael Nov 18 '19 at 13:08

pandas sum duplicated rows by column

0 Answers0