blocks|key|495168|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|495169|from+re+import+sub
from+decimal+import+Decimal

money+=+'$6,150,593.22'
value+=+Decimal(sub(r'[%5E\d.]',+'',+money))|code-block|syntax|javascript|495170|这有一些好处，因为它使用Decimal而不是float+(更适合表示货币)，而且它还避免了任何区域设置问题，因为它不会硬编码特定的货币符号。|offset|length|style|CODE|495171|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.python.org/library/decimal.html^0|0|0|C|7|M|5|C|7|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]|$I|Z|J|10|K|L]]|9|@$I|11|J|12|1|13]]|A|$]]|$1|M|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

Try this:

<pre><code>from re import sub
from decimal import Decimal

money = '$6,150,593.22'
value = Decimal(sub(r'[^\d.]', '', money))
</code></pre>

This has some advantages since it uses <a href="http://docs.python.org/library/decimal.html"><code>Decimal</code></a> instead of <code>float</code> (which is better for representing currency) and it also avoids any locale issues by not hard-coding a specific currency symbol.

blocks|key|495125|text|如果您的语言环境设置正确，您可以使用locale.atof，但您仍然需要手动删除'$‘：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|495126|>>>+import+locale
>>>+locale.setlocale(locale.LC_ALL,+'en_US.UTF8')
'en_US.UTF8'
>>>+money+=+"$6,150,593.22"
>>>+locale.atof(money.strip("$"))
6150593.2199999997|code-block|syntax|javascript|495127|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.python.org/library/locale.html#locale.atof^0|I|B|I|B|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

If your locale is set properly you can use <a href="http://docs.python.org/library/locale.html#locale.atof" rel="noreferrer"><code>locale.atof</code></a>, but you will still need to strip off the '$' manually:

<pre><code>&gt;&gt;&gt; import locale
&gt;&gt;&gt; locale.setlocale(locale.LC_ALL, 'en_US.UTF8')
'en_US.UTF8'
&gt;&gt;&gt; money = "$6,150,593.22"
&gt;&gt;&gt; locale.atof(money.strip("$"))
6150593.2199999997
</code></pre>

blocks|key|495647|text|对于不对货币位置或符号进行硬编码的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|495648|raw_price+=+"17,30+€"
import+locale
locale.setlocale(locale.LC_ALL,+'fr_FR.UTF8')
conv+=+locale.localeconv()
raw_numbers+=+raw_price.strip(conv['currency_symbol'])
amount+=+locale.atof(raw_numbers)|code-block|syntax|javascript|495649|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For a solution without hardcoding the currency position or symbol:
<pre><code>raw_price = &quot;17,30 €&quot;
import locale
locale.setlocale(locale.LC_ALL, 'fr_FR.UTF8')
conv = locale.localeconv()
raw_numbers = raw_price.strip(conv['currency_symbol'])
amount = locale.atof(raw_numbers)
</code></pre>

blocks|key|495221|text|扩展以在括号中包含负数：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|495222|In+[1]:+import+locale,+string

In+[2]:+from+decimal+import+Decimal

In+[3]:+n+=+['$1,234.56','-$1,234.56','($1,234.56)',+'$+-1,234.56']

In+[4]:+tbl+=+string.maketrans('(','-')

In+[5]:+%25timeit+-n10000+[locale.atof(+x.translate(tbl,+'$)'))+for+x+in+n]
10000+loops,+best+of+3:+31.9+æs+per+loop

In+[6]:+%25timeit+-n10000+[Decimal(+x.translate(tbl,+'$,)'))+for+x+in+n]
10000+loops,+best+of+3:+21+æs+per+loop

In+[7]:+%25timeit+-n10000+[float(+x.replace('(','-').translate(None,+'$,)'))+for+x+in+n]
10000+loops,+best+of+3:+3.49+æs+per+loop

In+[8]:+%25timeit+-n10000+[float(+x.translate(tbl,+'$,)'))+for+x+in+n]
10000+loops,+best+of+3:+2.19+æs+per+loop|code-block|syntax|javascript|495223|注意，必须从float()/Decimal()去掉逗号。replace()或translate()+w/+a转换表都可以用来转换开头(到-，translate稍微快一点。float()是最快的10-15倍，但缺乏精确度，可能会出现区域设置问题。Decimal()具有精确度，比locale.atof()快50%25，但也存在区域设置问题。locale.atof()是最慢的，但也是最通用的。|495224|编辑:新的str.translate接口(映射到None的字符从str.translate函数移到转换表)|offset|length|style|CODE|495225|In+[1]:+import+locale,+string
++++++++from+decimal+import+Decimal

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

++++++++n+=+['$1,234.56','-$1,234.56','($1,234.56)',+'$+-1,234.56']

In+[2]:+tbl+=+str.maketrans('(',+'-',+'$)')
++++++++%25timeit+-n10000+[locale.atof(+x.translate(tbl))+for+x+in+n]
18+µs+±+296+ns+per+loop+(mean+±+std.+dev.+of+7+runs,+10000+loops+each)

In+[3]:+tbl2+=+str.maketrans('(',+'-',+'$,)')
++++++++%25timeit+-n10000+[Decimal(+x.translate(tbl2))+for+x+in+n]
3.77+µs+±+50.8+ns+per+loop+(mean+±+std.+dev.+of+7+runs,+10000+loops+each)

In+[4]:+%25timeit+-n10000+[float(+x.translate(tbl2))+for+x+in+n]
3.13+µs+±+66.3+ns+per+loop+(mean+±+std.+dev.+of+7+runs,+10000+loops+each)

In+[5]:+tbl3+=+str.maketrans('',+'',+'$,)')
++++++++%25timeit+-n10000+[float(+x.replace('(','-').translate(tbl3))+for+x+in+n]
3.51+µs+±+84.8+ns+per+loop+(mean+±+std.+dev.+of+7+runs,+10000+loops+each)|495226|entityMap^0|0|0|0|5|D|O|4|W|D|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|V|8|@$K|W|L|X|M|N]|$K|Y|L|Z|M|N]|$K|10|L|11|M|N]]|9|@]|A|$]]|$1|O|3|P|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|R|$]]

Expanding to include negative numbers in parentheses:

<pre><code>In [1]: import locale, string

In [2]: from decimal import Decimal

In [3]: n = ['$1,234.56','-$1,234.56','($1,234.56)', '$ -1,234.56']

In [4]: tbl = string.maketrans('(','-')

In [5]: %timeit -n10000 [locale.atof( x.translate(tbl, '$)')) for x in n]
10000 loops, best of 3: 31.9 æs per loop

In [6]: %timeit -n10000 [Decimal( x.translate(tbl, '$,)')) for x in n]
10000 loops, best of 3: 21 æs per loop

In [7]: %timeit -n10000 [float( x.replace('(','-').translate(None, '$,)')) for x in n]
10000 loops, best of 3: 3.49 æs per loop

In [8]: %timeit -n10000 [float( x.translate(tbl, '$,)')) for x in n]
10000 loops, best of 3: 2.19 æs per loop
</code></pre>

Note that commas must be stripped from float()/Decimal(). Either replace() or translate() w/ a translation table can be used to convert the opening ( to -, translate is slightly faster. float() is fastest by 10-15x, but lacks precision and could present locale issues. Decimal() has precision and is 50% faster than locale.atof(), but also has locale issues. locale.atof() is the slowest, but most general.

Edit: new <code>str.translate</code> API (characters mapped to <code>None</code> moved from <code>str.translate</code> function to the translation table)

<pre><code>In [1]: import locale, string
 from decimal import Decimal

 locale.setlocale(locale.LC_ALL, '')

 n = ['$1,234.56','-$1,234.56','($1,234.56)', '$ -1,234.56']

In [2]: tbl = str.maketrans('(', '-', '$)')
 %timeit -n10000 [locale.atof( x.translate(tbl)) for x in n]
18 µs ± 296 ns per loop (mean ± std. dev. of 7 runs, 10000 loops each)

In [3]: tbl2 = str.maketrans('(', '-', '$,)')
 %timeit -n10000 [Decimal( x.translate(tbl2)) for x in n]
3.77 µs ± 50.8 ns per loop (mean ± std. dev. of 7 runs, 10000 loops each)

In [4]: %timeit -n10000 [float( x.translate(tbl2)) for x in n]
3.13 µs ± 66.3 ns per loop (mean ± std. dev. of 7 runs, 10000 loops each)

In [5]: tbl3 = str.maketrans('', '', '$,)')
 %timeit -n10000 [float( x.replace('(','-').translate(tbl3)) for x in n]
3.51 µs ± 84.8 ns per loop (mean ± std. dev. of 7 runs, 10000 loops each)
</code></pre>

blocks|key|495272|text|几年前我做了这个函数来解决同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|495273|def+money(number):
++++number+=+number.strip('$')
++++try:
++++++++[num,dec]=number.rsplit('.')
++++++++dec+=+int(dec)
++++++++aside+=+str(dec)
++++++++x+=+int('1'%2B'0'*len(aside))
++++++++price+=+float(dec)/x
++++++++num+=+num.replace(',','')
++++++++num+=+int(num)
++++++++price+=+num+%2B+price
++++except:
++++++++price+=+int(number)
++++return+price|code-block|syntax|javascript|495274|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I made this function a few years ago to solve the same problem.

<pre><code>def money(number):
 number = number.strip('$')
 try:
 [num,dec]=number.rsplit('.')
 dec = int(dec)
 aside = str(dec)
 x = int('1'+'0'*len(aside))
 price = float(dec)/x
 num = num.replace(',','')
 num = int(num)
 price = num + price
 except:
 price = int(number)
 return price
</code></pre>

blocks|key|711067|text|此函数已将土耳其价格格式转换为十进制数字。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|711068|money+=+'1.234,75'
def+make_decimal(string):
++++result+=+0
++++if+string:
++++++++[num,+dec]+=+string.rsplit(',')
++++++++result+%2B=+int(num.replace('.',+''))
++++++++result+%2B=+(int(dec)+/+100)
++++return+result
print(make_decimal(money))
1234.75|code-block|syntax|javascript|711069|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

this function has convert turkish price format to decimal number.

<pre><code>money = '1.234,75'
def make_decimal(string):
 result = 0
 if string:
 [num, dec] = string.rsplit(',')
 result += int(num.replace('.', ''))
 result += (int(dec) / 100)
 return result
print(make_decimal(money))
1234.75
</code></pre>

blocks|key|711125|text|我发现的最简单的方法，没有硬编码干扰货币检测，也使用了Decimal类型，避免了float类型的问题：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|711126|>>>+from+decimal+import+Decimal
>>>+money="$6,150,593.22"
>>>+amount+=+Decimal("".join(d+for+d+in+money+if+d.isdigit()+or+d+==+'.'))
>>>+amount
Decimal('6150593.22')

credit:+https://www.reddit.com/r/learnpython/comments/2248mp/how_to_format_currency_without_currency_sign/cgjd1o4?utm_source=share&utm_medium=web2x|code-block|syntax|javascript|711127|entityMap^0|R|7|14|5|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

Simplest way I found, without hard-coding on messing with currency detection, also uses the <code>Decimal</code> type which avoids issues with the <code>float</code> type:
<pre><code>&gt;&gt;&gt; from decimal import Decimal
&gt;&gt;&gt; money=&quot;$6,150,593.22&quot;
&gt;&gt;&gt; amount = Decimal(&quot;&quot;.join(d for d in money if d.isdigit() or d == '.'))
&gt;&gt;&gt; amount
Decimal('6150593.22')

credit: https://www.reddit.com/r/learnpython/comments/2248mp/how_to_format_currency_without_currency_sign/cgjd1o4?utm_source=share&amp;utm_medium=web2x
</code></pre>

I have some strings representing numbers with specific currency format, for example:

<pre><code>money="$6,150,593.22"
</code></pre>

I want to convert this string into the number

<pre><code>6150593.22
</code></pre>

What is the best way to achieve this?

How do I convert a currency string to a floating point number in Python?

我有一些表示特定货币格式的数字的字符串，例如：money="$6,150,593.22"我想把这个字符串转换成数字6150593.22实现这一目标的最佳方法是什么？

问如何在Python中将货币字符串转换为浮点数？
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Python中将货币字符串转换为浮点数？EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Python中将货币字符串转换为浮点数？
EN