Numerical Computing with Python

How to do it...

1. Read in the college dataset, group by state, and display the total number of groups. This should equal the number of unique states retrieved from the nunique Series method:

>>> college = pd.read_csv('data/college.csv', index_col='INSTNM')>>> grouped = college.groupby('STABBR')>>> grouped.ngroups59>>> college['STABBR'].nunique() # verifying the same number59

2. The grouped variable has a filter method, which accepts a custom function that determines whether a group is kept or not. The custom function gets implicitly passed a DataFrame of the current group and is required to return a boolean. Let's define a function that calculates the total percentage of minority students and returns True if this percentage is greater than ...