如何将一个字符串转换为一个数字，如果它有逗号作为数千个分隔符？

我有一个字符串，它表示一个用逗号分隔数千的数字。如何在 python 中将其转换为数字？

>>> int("1,000,000")

生成 ValueError。

在尝试转换之前，我可以用空字符串替换逗号，但是这样感觉不太对。还有更好的办法吗？

对于 float值，请参见 如何在 Python 中将带有点和逗号的字符串转换为 float，尽管技术基本上是相同的。

60454 次浏览
小开
最佳答案 
import locale
locale.setlocale( locale.LC_ALL, 'en_US.UTF-8' )
locale.atoi('1,000,000')
# 1000000
locale.atof('1,000,000.53')
# 1000000.53
小开

There are several ways to parse numbers with thousands separators. And I doubt that the way described by @unutbu is the best in all cases. That's why I list other ways too.

  1. The proper place to call setlocale() is in __main__ module. It's global setting and will affect the whole program and even C extensions (although note that LC_NUMERIC setting is not set at system level, but is emulated by Python). Read caveats in documentation and think twice before going this way. It's probably OK in single application, but never use it in libraries for wide audience. Probably you shoud avoid requesting locale with some particular charset encoding, since it might not be available on some systems.

  2. Use one of third party libraries for internationalization. For example PyICU allows using any available locale wihtout affecting the whole process (and even parsing numbers with particular thousands separators without using locales):

    NumberFormat.createInstance(Locale('en_US')).parse("1,000,000").getLong()

  3. Write your own parsing function, if you don't what to install third party libraries to do it "right way". It can be as simple as int(data.replace(',', '')) when strict validation is not needed.

小开

I got locale error from accepted answer, but the following change works here in Finland (Windows XP):

import locale
locale.setlocale( locale.LC_ALL, 'english_USA' )
print locale.atoi('1,000,000')
# 1000000
print locale.atof('1,000,000.53')
# 1000000.53
小开

This works:

(A dirty but quick way)

>>> a='-1,234,567,89.0123'
>>> "".join(a.split(","))
'-123456789.0123'
小开

Replace the commas with empty strings, and turn the resulting string into an int or a float.

>>> a = '1,000,000'
>>> int(a.replace(',' , ''))
1000000
>>> float(a.replace(',' , ''))
1000000.0
小开 
>>> import locale
>>> locale.setlocale(locale.LC_ALL, "")
'en_US.UTF-8'
>>> print locale.atoi('1,000,000')
1000000
>>> print locale.atof('1,000,000.53')
1000000.53

this is done on Linux in US.

小开

Try this:

def changenum(data):
foo = ""
for i in list(data):
if i == ",":
continue
else:
foo += i
return  float(int(foo))
小开

I tried this. It goes a bit beyond the question: You get an input. It will be converted to string first (if it is a list, for example from Beautiful soup); then to int, then to float.

It goes as far as it can get. In worst case, it returns everything unconverted as string.

def to_normal(soupCell):
''' converts a html cell from beautiful soup to text, then to int, then to float: as far as it gets.
US thousands separators are taken into account.
needs import locale'''
    

locale.setlocale( locale.LC_ALL, 'english_USA' )


output = unicode(soupCell.findAll(text=True)[0].string)
try:
return locale.atoi(output)
except ValueError:
try: return locale.atof(output)
except ValueError:
return output
小开

A little late, but the babel library has parse_decimal and parse_number which do exactly what you want:

from babel.numbers import parse_decimal, parse_number
parse_decimal('10,3453', locale='es_ES')
>>> Decimal('10.3453')
parse_number('20.457', locale='es_ES')
>>> 20457
parse_decimal('10,3453', locale='es_MX')
>>> Decimal('103453')

You can also pass a Locale class instead of a string:

from babel import Locale
parse_decimal('10,3453', locale=Locale('es_MX'))
>>> Decimal('103453')
小开

If you're using pandas and you're trying to parse a CSV that includes numbers with a comma for thousands separators, you can just pass the keyword argument thousands=',' like so:

df = pd.read_csv('your_file.csv', thousands=',')

提交答案