Volunteers Who Fell Short of Their Pledge

Problem

You are given two DataFrames. `volunteer` (from `volunteer.csv`) has columns `volunteer_id` and `pledged_hours` (the hours each volunteer promised). `shift` (from `shift.csv`) has columns `volunteer_id`, `clock_in`, and `clock_out` (datetime strings) recording each shift worked.

For every shift, round its duration up to the nearest whole minute. A volunteer falls short if their total worked minutes (0 if they never showed up) is strictly less than `pledged_hours * 60`. Return the `volunteer_id` of every volunteer who fell short. Order does not matter.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns volunteer_id.

Starter code (Pandas (Python))

import pandas as pd

def volunteers_who_fell_short_of_their_pledge(volunteer, shift) -> pd.DataFrame:
    # Your code here
    return volunteer

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