/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 vote128 views1 answer
Function that return a lenght of list
Python
2 votes195 views1 answer
Jupyter notebook pass python variable to shell
Python
14 votes207 views3 answers
How to get id of user discord.py
Python
28 votes177 views6 answers
Docker compose command not found
Python
0 vote193 views2 answers
Feature selection python
Python
0 vote181 views1 answer
Heroku run python manage.py migrate
Python
0 vote233 views1 answer
Como filtrar los vacios, NaN, null en python
Python
0 vote163 views2 answers
Concatenate the squares of numbers in python
Python
4 votes216 views3 answers
Python list add element to front
Python
0 vote182 views1 answer
|safe django
Python