Overworked Hospital Staff

Problem

Two CSV files describe a hospital. `staff.csv` holds each staff member (`staff_id`, `staff_name`, `ward`) and `shifts.csv` holds every shift worked (`shift_id`, `staff_id`, `shift_date`, `shift_kind`, `hours`). A standard work week runs Monday through Sunday and totals 50 scheduled hours, so a week is 'overworked' when a staff member's total shift hours for that week exceed 50. Find every staff member with at least two overworked weeks. Return their `staff_name` and the count of overworked weeks as `heavy_weeks`, sorted by the count descending, then by `staff_name` alphabetically.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns staff_name, heavy_weeks.

Starter code (Pandas (Python))

import pandas as pd

def find_overworked_staff(staff, shifts) -> 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