如何在大数中间去掉逗号？

Question

我希望将str数字转换为浮点数或int数字类型。然而，它抛出了一个错误，它不能，所以我要删除逗号。逗号不会被移除，所以我需要找到一种方法来指定数字空间中的位置，比如第四个。

power4 = power[power.get('Number of Customers Affected') != 'Unknown']
power5 = power4[pd.notnull(power4['Number of Customers Affected'])]
power6 = power5[power5.get('NERC Region') == 'RFC']
power7 = power6.get('Number of Customers Affected').loc[1]
power8 = power7.strip(",")
power9 = float(power8)


ValueError                                Traceback (most recent call last) <ipython-input-70- 32ca4deb9734> in <module>
      6 power7 = power6.get('Number of Customers Affected').loc[1]
      7 power8 = power7.strip(",")
----> 8 power9 = float(power8)
      9 
     10 

ValueError: could not convert string to float: '127,000'

Answer 1

使用替换()

float('127,000'.replace(',',''))

Answer 2

你试过数字吗？

import pandas as pd

a = '1234'
type(a)

a = pd.to_numeric(a)
type(a)

Answer 3

在

power8 = power7.strip(",")

线，做

power8 = power7.replace(',', '')

脱衣舞()在这里行不通。需要的是替换字符串的()方法。你也可以试试

''.join(e for e in s if e.isdigit())

或,

s = ''.join(s.split(','))

RegeEx也可以是解决这个问题的一种方法，或者您可以看看这个答案：https://stackoverflow.com/a/266162/9851541