Saturday Donation Totals

Problem

You are given a DataFrame `donations` with columns `donor_id`, `gift_date`, and `amount`. Each row is one gift to a community food bank.

Report the total amount donated on each **Saturday in March 2024**. For each such Saturday that had at least one donation, output `week_of_month`, `gift_date`, and `total_gift`, where `week_of_month` is which Saturday of the month it is (1 for the first week, 2 for the second, and so on). Order the output by `week_of_month` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns week_of_month, gift_date, total_gift.

Starter code (Pandas (Python))

import pandas as pd

def saturday_donation_totals(donations) -> pd.DataFrame:
    # Your code here
    return donations

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