High-Balance Loyalty Members

Problem

You are given two DataFrames:
- `members` with `card`, `member_name`
- `pointevents` with `event_id`, `card`, `points`, `happened_on` (points may be positive for earning or negative for redeeming)

Each member's balance is the sum of all their point events. Return the members whose total balance is strictly greater than 10000.

Return columns `member_name` and `balance`. Members with no point events, or with a balance of 10000 or less, are excluded.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns member_name, balance.

Starter code (Pandas (Python))

import pandas as pd

def high_balance_loyalty_members(members, pointevents) -> pd.DataFrame:
    # Your code here
    return members

Related Pandas questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy
• Average Reviewer Tenure per GrantEasy