Committed Gym Members

Problem

One CSV file, `member_visits.csv`, logs every gym member visit (`visit_id`, `member_id`, `visit_date`, `visit_kind`), where `visit_kind` is either 'checkin' (they showed up) or 'noshow' (a booked slot they missed). A member counts as committed when they meet all of: at least 3 check-ins, an active span of at least 30 days between their first and last logged visit, and a no-show rate below 20% (no-shows divided by all logged visits). Return the `member_id` of every committed member, ordered by `member_id` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns member_id.

Starter code (Pandas (Python))

import pandas as pd

def find_committed_members(member_visits) -> pd.DataFrame:
    # Your code here
    return member_visits

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