Numerical Computing with Python

There's more...

Instead of manually typing in a list of department names, we could have programmatically created it. For instance, if we wanted to find all the female employees that were not a member of the top 10 departments by frequency, we can run the following code:

>>> top10_depts = employee.DEPARTMENT.value_counts() \                                     .index[:10].tolist()>>> qs = "DEPARTMENT not in @top10_depts and GENDER == 'Female'">>> employee_filtered2 = employee.query(qs)>>> employee_filtered2.head()