擅长:python、mysql、java
<p>问题是带有逗号和引号的数字</p>
<p>使用<a href="https://docs.python.org/2/library/locale.html" rel="nofollow noreferrer">locale</a>将欧洲语转换为英语</p>
<p><strong>代码</strong></p>
<pre><code>from io import StringIO
import pandas as pd
import locale
s = '''Contract Name,Last Trade Date,Strike,Last Price,Bid,Ask,Change
AMZN200605P03320000,2020-05-28 3:24PM EDT,3320.0,900.65,876.0,893.5,+900.65
AMZN200605P03500000,2020-05-28 3:51PM EDT,3500.0,1099.55,1055.5,1073.5,"+1,099.55"'''
df = pd.read_csv(StringIO(s))
# set local to English
locale.setlocale( locale.LC_ALL, 'en_US.UTF-8' )
# Convert column to float
df['Change'] = df['Change'].apply(lambda x: locale.atof(x))
print(df['Change'])
</code></pre>
<p><strong>输出</strong></p>
<pre><code>Name: Change, dtype: object
0 900.65
1 1099.55
Name: Change, dtype: float64
</code></pre>