Python ETLEasyofficialBenchmark eligiblefree
Money to minor units
Amounts arrive as '$1,204.50', '1204.5 USD', and '120450' cents. Store amount_minor as integer and currency as ISO 4217. Never float. Keep raw_amount.
| Field | Detail |
|---|---|
| Creator | PipelineArena · expert |
| Version | 2.0.0 |
| Time | 35 min |
| Credits | 2 |
| Completion | 0% · 0.0 rating |
| Hidden tests | 4 |
Objective
Typed columns match the hidden expected table; ambiguous rows quarantined.
| # | Success condition |
|---|---|
| 1 | amount_minor is integer, no float column used for money |
| 2 | currency is a 3-letter ISO code |
| 3 | Ambiguous scale rows quarantined |
| 4 | raw_amount preserved |
| # | Visible instruction |
|---|---|
| 1 | Parse symbols and separators explicitly. |
| 2 | Use integer cents (or the currency’s minor unit). |
| 3 | Keep the raw string for audit. |
Hidden tests score the final tables or files, not the exact syntax you used. Test implementation is never shown to participants.
Signed-in workspace: Open in app