Recruiters Who Never Staffed Helix
Problem
Three DataFrames describe a staffing agency: `Recruiter(recruiter_id, recruiter_name, base_pay)`, `ClientFirm(firm_id, firm_name)`, and `Placement(placement_id, firm_id, recruiter_id)` where each placement row records a recruiter who staffed a hire at a client firm.
Report the name of every recruiter who has **never** made a placement at the firm named `Helix`. Return a single column `recruiter_name`.
Input data
Example rows — the live problem includes the full dataset.
| recruiter_id | recruiter_name | base_pay |
|---|---|---|
| 1 | Dana | 90000 |
| 2 | Omar | 72000 |
| 3 | Priya | 81000 |
| 4 | Tomas | 64000 |
| 5 | Lena | 58000 |
| firm_id | firm_name |
|---|---|
| 1 | Helix |
| 2 | Vertex |
| 3 | Quanta |
| 4 | Nimbus |
| placement_id | firm_id | recruiter_id |
|---|---|---|
| 1 | 3 | 4 |
| 2 | 4 | 5 |
| 3 | 1 | 1 |
| 4 | 1 | 4 |
Expected output
Your answer should return 3 rows with the columns recruiter_name.
Starter code (Pandas (Python))
import pandas as pd
def recruiters_never_at_helix(recruiter: pd.DataFrame, clientfirm: pd.DataFrame, placement: pd.DataFrame) -> pd.DataFrame:
# Your code here
return recruiterSolve this Pandas question free
Write Pandas (Python) and run it instantly in your browser — even on your phone. No signup needed to try.
Solution & explanation
Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.
Sign up free to unlock