1. Read in the employee data, assign the chosen departments, and import columns to variables:

>>> employee = pd.read_csv('data/employee.csv')
>>> depts = ['Houston Police Department-HPD',
             'Houston Fire Department (HFD)']
>>> select_columns = ['UNIQUE_ID', 'DEPARTMENT',
                      'GENDER', 'BASE_SALARY']

2. Build the query string and execute the method:

>>> qs = "DEPARTMENT in @depts " 
         "and GENDER == 'Female' " 
         "and 80000 <= BASE_SALARY <= 120000"
        
>>> emp_filtered = employee.query(qs)
>>> emp_filtered[select_columns].head()