Eligible Trade-In Payouts

Problem

DataFrame: `tradein` (`tradein.csv`)

```text
+----------+--------+--------+-------+-------+
| Column | Type | | | |
+----------+--------+--------+-------+-------+
| trade_id | int | | | |
| base_val | float | | | |
| payout | float | | | |
| east | float | | | |
| north | float | | | |
+----------+--------+--------+-------+-------+
trade_id uniquely identifies each trade-in. base_val is the appraised base value, payout is the offered payout, and (east, north) is the grid location of the drop-off depot (never missing).
```

Report the sum of `payout` over all trade-ins that satisfy **both** conditions:

- their `base_val` equals the `base_val` of at least one other trade-in, **and**
- their depot location `(east, north)` is unique — no other trade-in shares the same `(east, north)` pair.

Round the total to **two decimal places** and return it as a single column named `payout`. If no trade-in qualifies, return one row whose `payout` is `null`.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns payout.

Starter code (Pandas (Python))

import pandas as pd

def eligible_payout(tradein: pd.DataFrame) -> pd.DataFrame:
    # Your code here
    return tradein

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