Esports Ladder Standings by Split

Problem

A competitive gaming league hands you a DataFrame `split_results`, one row per roster's end-of-split record. A win is worth 3 ladder points and a draw is worth 1; losses are worth 0. Rank rosters within each split by, in order: ladder points (highest first), then round_diff = rounds_won minus rounds_lost (highest first), then roster_name alphabetically. Use a ranking that gives tied rows the same standing (so the next standing skips the gap). Return a DataFrame with columns split_id, roster_id, roster_name, victories, stalemates, defeats, rounds_won, rounds_lost and standing, ordered by split_id, then standing, then roster_name.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 10 rows with the columns split_id, roster_id, roster_name, victories, stalemates, defeats, rounds_won, rounds_lost, standing.

Starter code (Pandas (Python))

import pandas as pd

def esports_ladder_standings_by_split(split_results) -> pd.DataFrame:
    # Your code here
    return split_results

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