Members Who Booked Yoga and Spin but Not Boxing

Problem

A fitness studio records every class a member books.

`members` (`members.csv`): `member_id`, `member_name` — one member per row.

`bookings` (`bookings.csv`): `booking_id`, `member_id`, `class_name` — each row is one class booking by a member.

Return the `member_id` and `member_name` of every member who has booked both the `Yoga` class and the `Spin` class but has **never** booked the `Boxing` class. Return the rows ordered by `member_id`.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns member_id, member_name.

Starter code (Pandas (Python))

import pandas as pd

def yoga_and_spin_not_boxing(members: pd.DataFrame, bookings: pd.DataFrame) -> pd.DataFrame:
    # Your code here
    return members

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