/Python/Pandas condense dataframe by summing according to ID

Pandas condense dataframe by summing according to ID

# Original dataframe df:
Fruit   Date      Name  Number
Apples  10/6/2016 Bob    7
Apples  10/6/2016 Bob    8
Apples  10/6/2016 Mike   9
Apples  10/7/2016 Steve 10
Apples  10/7/2016 Bob    1
Oranges 10/7/2016 Bob    2
Oranges 10/6/2016 Tom   15
Oranges 10/6/2016 Mike  57
Oranges 10/6/2016 Bob   65
Oranges 10/7/2016 Tony   1
Grapes  10/7/2016 Bob    1
Grapes  10/7/2016 Tom   87
Grapes  10/7/2016 Bob   22
Grapes  10/7/2016 Bob   12
Grapes  10/7/2016 Tony  15

df.groupby(['Fruit','Name']).sum() # Use .groupby().sum()

#Output:                
Fruit   Name    Number     
Apples  Bob        16
        Mike        9
        Steve      10
Grapes  Bob        35
        Tom        87
        Tony       15
Oranges Bob        67
        Mike       57
        Tom        15
        Tony        1

Source: stackoverflow.com

Similar codes

46 votes308 views6 answers
Install requests python
Python
1 vote289 views1 answer
Count words python
Python
1 vote313 views1 answer
How to save inputs python
Python
0 vote289 views1 answer
Selenium ways of finding
Python
26 votes274 views6 answers
Flask run
Python
26 votes286 views2 answers
Dictionary from two list
Python
0 vote280 views1 answer
‘A’, ‘Q’, ‘BM’, ‘BA’, ‘BQ’ meaning in resample
Python
0 vote303 views1 answer
At=error code=h10 desc= app crashed python flask
Python
1 vote290 views2 answers
How to convert integer to binary string python
Python
0 vote307 views1 answer
How to capitalize every item in a list python
Python