Python parse comma-separated number into int

Question

How would I parse the string 1,000,000 (one million) into it's integer value in Python?

See http://stackoverflow.com/questions/1779288/how-do-i-use-python-to-convert-a-string-to-a-number-if-it-has-commas-in-it-as-tho/1779324 — unutbu, Jun 01 '10 at 22:15

joaquin · Accepted Answer · 2011-09-28T21:01:09.703

157

>>> a = '1,000,000'
>>> int(a.replace(',', ''))
1000000
>>>

edited Sep 28 '11 at 21:01

answered Jun 01 '10 at 22:13

joaquin

82,968
29
138
152

score 60 · Answer 2 · edited Nov 29 '21 at 13:55

60

There's also a simple way to do this that should handle internationalization issues as well:

>>> import locale
>>> locale.setlocale(locale.LC_ALL, 'en_US.UTF-8')
'en_US.UTF-8'
>>> locale.atoi("1,000,000")
1000000
>>>

I found that I have to explicitly set the locale first as above, otherwise it doesn't work for me and I end up with an ugly traceback instead:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/python2.6/locale.py", line 296, in atoi
    return atof(str, int)
  File "/usr/lib/python2.6/locale.py", line 292, in atof
    return func(string)
ValueError: invalid literal for int() with base 10: '1,000,000'

edited Nov 29 '21 at 13:55

c0d3rman

665
6
15

answered Jun 02 '10 at 00:21

Khorkrak

3,911
2
27
37

4

Do you mean: `locale.setlocale(locale.LC_ALL, 'en_US.UTF-8')` I.e. "UTF-8", not "UTF8". On my OSX machine that seems to be the correct value. – Alasdair Mackintosh Jan 14 '18 at 23:35
1

This should be the accepted answer. The comma-replacement hack is brittle and i18n-breaking. – Reinderien Sep 13 '18 at 02:52
1

This still converts wrong values like 1,0,0,10 to 10010 – Seperman Oct 23 '21 at 17:47
@Seperman Under the hood, `locale.atoi` and friends just do `val.replace(sep, '')`, where `sep` is the thousands separator defined in the locale convention. – snakecharmerb Feb 16 '22 at 08:29
Exactly. I don't think that is the right approach. – Seperman Feb 17 '22 at 17:11

score 13 · Answer 3 · answered Jun 01 '10 at 22:14

13

Replace the ',' with '' and then cast the whole thing to an integer.

>>> int('1,000,000'.replace(',',''))
1000000

answered Jun 01 '10 at 22:14

jathanism

33,067
9
68
86

Python parse comma-separated number into int

3 Answers3

Linked