/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 vote86 views2 answers
Video to text python
Python
0 vote139 views1 answer
Numpy timedelta object has no attribute days
Python
2 votes124 views2 answers
AttributeError: module 'tensorflow._api.v2.train' has no attribute 'RMSPropOptimizer' site:stackoverflow.com
Python
1 vote145 views1 answer
How to use enumerate instead of range and len
Python
0 vote122 views1 answer
Counting combinations python
Python
0 vote144 views1 answer
Preventing players from changing existing entries in tic tac toe game
Python
0 vote132 views1 answer
Google-api-python-client python 3
Python
0 vote148 views1 answer
F = open("yourfile.txt", "r") TypeError: an integer is required (got type str)
Python
0 vote139 views1 answer
Pandas define how you want to aggregate each column
Python
9 votes123 views3 answers
Check if tensorflow gpu is installed
Python