Each Athlete's Best Event

Problem

A decathlon league records the points an athlete scored in each event they competed in, in a DataFrame `result` (`result.csv`).

```text
+------------+------+
| Column | Type |
+------------+------+
| athlete_id | int |
| event_id | int |
| points | int |
+------------+------+
```

`(athlete_id, event_id)` is unique. Each row is the points an athlete earned in one event.

Write a function that finds, for each athlete, the event in which they scored their highest points, along with that points value. If an athlete's top points are tied across multiple events, pick the event with the smallest `event_id`. Return columns `athlete_id`, `event_id`, and `points`, ordered by `athlete_id` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns athlete_id, event_id, points.

Starter code (Pandas (Python))

import pandas as pd

def best_event(result: pd.DataFrame) -> pd.DataFrame:
    # Your code here
    return result

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