FunctionRacerProblemsRace

Employee Bonus

MediumpandasPython

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

Race itor take your time

Write it in your browser, against the clock. The model solution, stepped through line by line, comes after.

More pandas problems