Member Count per Club

Problem

You are given two DataFrames.

`club`
```text
+-----------+-----------+
| Column | Type |
+-----------+-----------+
| club_id | int |
| club_name | object |
+-----------+-----------+
club_id is the unique key.
```

`member`
```text
+-------------+-----------+
| Column | Type |
+-------------+-----------+
| member_id | int |
| member_name | object |
| year_level | object |
| club_id | int |
+-------------+-----------+
```

Count how many members belong to each club, including clubs with **zero** members. Return columns `club_name`, `member_count`, ordered by `member_count` descending, breaking ties by `club_name` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns club_name, member_count.

Starter code (Pandas (Python))

import pandas as pd

def members_per_club(member: pd.DataFrame, club: pd.DataFrame) -> pd.DataFrame:
    # Your code here
    return member

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