Standout Clinics

Problem

A health network records monthly metrics for each clinic in a DataFrame `metric` (`metric.csv`).

```text
+-------------+--------+
| Column | Type |
+-------------+--------+
| clinic_id | int |
| metric_name | object |
| tally | int |
+-------------+--------+
```

`(clinic_id, metric_name)` is unique. Each row holds one clinic's tally for one metric (such as `'visits'`, `'referrals'`, or `'screenings'`).

Write a function that finds all standout clinics. A clinic is a standout when it beats the network-wide average for more than one metric, where beating means its tally for that metric is strictly greater than the average tally of that same metric across all clinics. Return a single column `clinic_id` in any order.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns clinic_id.

Starter code (Pandas (Python))

import pandas as pd

def standout_clinics(metric: pd.DataFrame) -> pd.DataFrame:
    # Your code here
    return metric

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