cope with numbers like "7,903,001"

[catherinedevlin]

No description provided.

[hsum]

Hi Catherine,

Would something like this help? It doesn't completely validate (maybe a regex would be needed to make sure commas separate 3 digits at time), but deals with the commas naively and that might be good enough.

numbers = [
    '1,234,000',
    '1,234,000.00',
    '1234000',
    '.4000',
    '1.4000',
    '1,4000',
    'wrongcolumn',
]

if __name__ == '__main__':
    for num in (n.replace(',','') for n in numbers):
        print(num, num.replace('.','').isdigit())