convert_amounts(rows) that converts a list of strings to floats, returning a tuple (converted, failed) where converted holds the successful floats in order and failed holds the original strings that raised ValueError. Batch jobs must not die on the first bad record.convert_amounts(['10.5', 'oops', '3'])
([10.5, 3.0], ['oops'])
Two rows convert; the bad one is reported, not fatal.
One try/except inside the loop.
Append to the right list in each branch.