Employee Bonus
staff has columns emp_id and name. bonuses has columns emp_id and bonus (at most one row per employee). Return the names of employees whose bonus is below 1000 or who have no bonus row, in the order of staff.
Example 1
staff {"emp_id":[1,2,3],"name":["Ann","Bo","Cy"]}
bonuses {"emp_id":[1,3],"bonus":[2000,500]}
returns ["Bo","Cy"]
Ann has 2000. Bo has none; Cy has 500.
Constraints
- The result may be an empty list
Write it in your browser, against the clock. The model solution, stepped through line by line, comes after.
More pandas problems
- Employee DepartmentsMedium
- Find Valid EmailsMedium
- First Time Below ZeroMedium
- Last Person on the BusMedium
- Manager NamesMedium
- Most Orders CustomerMedium
- Most Recent OrderMedium
- Person CitiesMedium