Prime-Time Gym Regulars

Problem

You are given one DataFrame `gym_visits` (loaded from `gym_visits.csv`). Each row is a single gym visit, with columns `visit_id`, `member_id`, `checkin_time` (the timestamp the member started), `calories_burned`, and an optional `session_score` from 1 to 5 the member may leave afterwards (NaN when skipped). Find the prime-time regulars, defined by ALL of: the member logged at least 3 visits; at least 60% of their visits started during prime time (morning hours 6, 7, 8 or evening hours 17, 18, 19); the average score over the visits they DID rate is at least 4.0; and they rated at least half of their visits. Return a DataFrame with each qualifying member's `member_id` and their average rated score as `mean_score`, rounded to 2 decimals. Order by `mean_score` descending, then by `member_id` descending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns member_id, mean_score.

Starter code (Pandas (Python))

import pandas as pd

def find_prime_time_regulars(gym_visits) -> pd.DataFrame:
    # Your code here
    return gym_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