Numerical Computing with Python

How to do it...

1. Read in the employee dataset and find the mean salary by race:

>>> employee = pd.read_csv('data/employee.csv')>>> employee.groupby('RACE')['BASE_SALARY'].mean().astype(int)RACE
American Indian or Alaskan Native    60272
Asian/Pacific Islander               61660
Black or African American            50137
Hispanic/Latino                      52345
Others                               51278
White                                64419
Name: BASE_SALARY, dtype: int64

2. This is a very simple groupby operation that results in a Series that is easy to read and has no need to reshape. Let's now find the average salary for all races by gender:

>>> agg = employee.groupby(['RACE', 'GENDER'])['BASE_SALARY'] \                  .mean().astype(int)>>> aggRACE GENDER American Indian or Alaskan Native Female 60238 Male 60305 Asian/Pacific Islander Female 63226 Male ...