Chess Club Ladder Standings

Problem

You are given two DataFrames. `clubs` (from `clubs.csv`) has columns `club_id` and `club_name`. `bouts` (from `bouts.csv`) has columns `bout_id`, `white_club`, `black_club`, `white_wins`, and `black_wins`; each row is a team match where the two clubs played White and Black and won the listed number of boards.

Score each club across all bouts: a club earns **3 points** for winning a bout (more boards won than the opponent), **1 point** for a tie, and **0 points** for a loss. A club that played no bouts has 0 points. Return `club_id`, `club_name`, and `standing_points`, sorted by `standing_points` descending, then `club_id` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 5 rows with the columns club_id, club_name, standing_points.

Starter code (Pandas (Python))

import pandas as pd

def ladder_standings(clubs, bouts) -> pd.DataFrame:
    # Your code here
    return clubs

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