Numerical Computing with Python

How to do it...

1. Read in the employee dataset as a DataFrame:

>>> employee = pd.read_csv('data/employee.csv')

2. Before filtering out the data, it is helpful to do some manual inspection of each of the filtered columns to know the exact values that will be used in the filter:

>>> employee.DEPARTMENT.value_counts().head()Houston Police Department-HPD     638
Houston Fire Department (HFD)     384
Public Works & Engineering-PWE    343
Health & Human Services           110
Houston Airport System (HAS)      106
Name: DEPARTMENT, dtype: int64>>> employee.GENDER.value_counts() Male 1397 Female 603>>> employee.BASE_SALARY.describe().astype(int)count      1886
mean      55767
std       21693
min       24960
25%       40170
50%       54461
75%       66614
max      275000
Name: BASE_SALARY, dtype: int64

3. Write a single ...