Percentile Standing of Each Runner

Problem

You are given a DataFrame `runners` with columns `runner_id`, `bracket_id`, and `score`. Within each bracket, compute each runner's percentile standing using the formula `(rank - 1) * 100 / (total_runners - 1)`, where `rank` is the position by descending score (ties share the same lower rank) and `total_runners` is the number of runners in the bracket. If a bracket has only one runner, the standing is 0. Round the standing to 2 decimals. Return columns `runner_id`, `bracket_id`, and `standing`. Row order does not matter.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 5 rows with the columns runner_id, bracket_id, standing.

Starter code (Pandas (Python))

import pandas as pd

def percentile_standing(runners) -> pd.DataFrame:
    # Your code here
    return runners

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