How To Use Groupby Objects To Get Sums Of Other Columns?

I'm playing with an mlb data set from the web to help learn. The dataframe looks like Player Position Salary Year 0 Mike Witt Pitcher

Solution 1:

Just do:

pitcher_groups['Salary'].sum()

This sums the salary column on the groupby object.

In [57]:

df[df['Position']=='Pitcher'].groupby('Player')['Salary'].sum()
Out[57]:
Player
Mike Witt    1400000
Name: Salary, dtype: int64

Solution 2:

Make use of the following:

pitcher_groups = pitchers[['Player','Salary']].groupby('Player', sort=True).sum()