/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 vote238 views1 answer
Open anarchy ip
Python
4 votes237 views1 answer
Np array to wav file
Python
1 vote238 views1 answer
To_csv drop index
Python
1 vote235 views1 answer
Pandas timedelta to seconds
Python
74 votes229 views6 answers
Append dictionary python
Python
16 votes220 views1 answer
Save model keras
Python
10 votes246 views3 answers
Python dataframe find no of true
Python
2 votes239 views1 answer
Np.select with multiple conditions
Python
4 votes246 views1 answer
Remove multiple space python
Python
0 vote240 views1 answer
For i in range without i
Python