Members Active in Two Quarters

PandasEasyJunior level~10 min

Problem

A gym tracks every class booking. Each booking links a member to a class, and each class has a credit cost.

`members` columns: `member_id`, `member_name`, `home_city`.
`classes` columns: `class_id`, `class_title`, `cost`.
`bookings` columns: `booking_id`, `member_id`, `class_id`, `booked_on`, `seats`.

Find the members who spent **at least 50 credits in Q1 2023 (Jan-Mar) AND at least 50 credits in Q2 2023 (Apr-Jun)**. The credits for a booking are `seats * cost`.

Return `member_id` and `member_name`. Order does not matter.

Input data

Example rows — the live problem includes the full dataset.

members

member_id	member_name	home_city
1	Priya	Austin
2	Diego	Lima
3	Hana	Osaka

classes

class_id	class_title	cost
10	Spin	150
20	Yoga	5
30	Boxing	22
40	Sauna	1

bookings

booking_id	member_id	class_id	booked_on	seats
1	1	10	2023-02-10	1
2	1	20	2023-04-01	1
3	1	30	2023-04-08	3
4	2	10	2023-02-15	2
5	2	40	2023-04-01	10

Expected output

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

Starter code (Pandas (Python))

import pandas as pd

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

Solve this Pandas question free

Write Pandas (Python) and run it instantly in your browser — even on your phone. No signup needed to try.

Solve it now → Create free account

Solution & explanation

Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.