/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

0 vote130 views1 answer
Equivalenci EN PYTHON DE INPUT EN C#
Python
0 vote145 views1 answer
Python String to array using list() method
Python
54 votes257 views2 answers
How to run django requirement.txt
Python Django
0 vote68 views1 answer
"_tkinter.TclError: bad entry index "1.0""
Python
0 vote126 views2 answers
Python C-like structs
Python
0 vote157 views1 answer
Python class tostring
Python
0 vote128 views1 answer
Line plotly with shaded area
Python
8 votes168 views1 answer
How to do collision detection in pygame
Python
15 votes127 views2 answers
Read excel into dataframe python
Python
0 vote151 views1 answer
Load py file converted from .ui file
Python