A bank-style risk team reviews large ATM withdrawals.
Return txn_id, account_id, amount for withdrawals above 10,000. Sort by txn_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
withdrawals7 rows| txn_id (int) | account_id (int) | amount (double) |
|---|---|---|
| 1 | 101 | 5000 |
| 2 | 102 | 12000 |
| 3 | 101 | 10000 |
| 4 | 103 | 25000 |
| 5 | 104 | 8000 |
| 6 | 102 | 15000 |
| 7 | 105 | 10001 |
Column names and order must match. Sort order is specified in the question.