如何处理数字中的逗号？

ilsoviet1917

筛选数据，但是超过1000的数据中，如果有逗号分隔符就会报错，如何处理？

用E:\数据分析\2>python pandas_value_meets_condition.py supplier_data.csv pandas_output_loc.csv运行后出现错误提示：

Traceback (most recent call last):
  File "pandas_value_meets_condition.py", line 12, in <module>
    data_frame['Cost'] = data_frame['Cost'].str.strip('$').astype(float)
  File "C:\Users\ilsov\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\core\generic.py", line 5882, in astype
    dtype=dtype, copy=copy, errors=errors, **kwargs
  File "C:\Users\ilsov\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\core\internals\managers.py", line 581, in astype
    return self.apply("astype", dtype=dtype, **kwargs)
  File "C:\Users\ilsov\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\core\internals\managers.py", line 438, in apply
    applied = getattr(b, f)(**kwargs)
  File "C:\Users\ilsov\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\core\internals\blocks.py", line 559, in astype
    return self._astype(dtype, copy=copy, errors=errors, values=values, **kwargs)
  File "C:\Users\ilsov\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\core\internals\blocks.py", line 643, in _astype
    values = astype_nansafe(vals1d, dtype, copy=True, **kwargs)
  File "C:\Users\ilsov\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\core\dtypes\cast.py", line 729, in astype_nansafe
    return arr.astype(dtype, copy=True)
ValueError: could not convert string to float: '6,015.00 '
这个CSV文件里有两个大于1000的值，并且有逗号分隔符，报错因该是这个原因。怎么解决呢？

1. import pandas as pd
   
2. import sys
   
3. 
   
4. input_file = sys.argv[1]
   
5. output_file = sys.argv[2]
   
6. 
   
7. data_frame = pd.read_csv(input_file)
   
8. data_frame['Cost'] = data_frame['Cost'].str.strip('
   
9. 
   
10. 
    
11. 
    
12. 
    
13. ).astype(float)
    
14. 
    
15. data_frame_value_meets_condition = data_frame.loc[(data_frame['Supplier Name']\
    
16. .str.contains('Z')) | (data_frame['Cost'] > 600.0), :]
    
17. 
    
18. data_frame_value_meets_condition.to_csv(output_file, index = False)

复制代码

ilsoviet1917

08-13行是
data_frame['Cost'] = data_frame['Cost'].str.strip('$').astype(float)
我也不知道为什么会变成那样

dlnb526

~没有下载你的数据文件，所以只提供思路：
1.利用数据特征，使用正则表达式找出相关数据并改造，应该是这样的格式

1. "\d,\d"

复制代码

2.如果逗号只出现在数字中，利用repalce替换

希望对你有所帮助

wp231957

把逗号替换成虚无

ilsoviet1917

wp231957 发表于 2020-2-12 20:04
把逗号替换成虚无

没有办法在筛选和输出的时候保留这些逗号吗?
用astype强制转换类型的时候居然没把逗号去掉？