Fully Certified Staff

Problem

A company tracks training in three DataFrames:
- `staff` with columns `staff_id`, `full_name`, `team`.
- `modules` with columns `module_id`, `title`, `hours`, `team`.
- `attempts` with columns `staff_id`, `module_id`, `term`, `result`.

Every team has a set of required modules (the modules whose `team` matches the staff member's `team`). Find every staff member who has a passing attempt (`result` == 'Pass') in every required module for their team. A person counts only if they passed all of their team's modules, with no module left unattempted or failed.

Return a single column `staff_id`, ordered ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns staff_id.

Starter code (Pandas (Python))

import pandas as pd

def fully_certified_staff(staff, modules, attempts) -> pd.DataFrame:
    # Your code here
    return staff

Related Pandas questions

• 7-Day Rolling Signup AverageMedium
• Accounts Streaming From Two Devices at OnceMedium
• Agent Resolution RateMedium
• Agents With a Dominant Contact ChannelMedium
• Airbnb Popularity Bucket PricingMedium
• Amazon Unique Shipments per MonthMedium