擅长:python、mysql、java
<p>尝试以下操作:</p>
<p><strong>数据</strong>:</p>
<pre><code>dic = {'Name':['John','Peter'],'SalaryPaid':['$204,546,289.35','$500,231,289.35'],'Year':['2008','2009']}
df1 = pd.DataFrame(dic)
df1
Name SalaryPaid Year
0 John $204,546,289.35 2008
1 Peter $500,231,289.35 2009
</code></pre>
<p><strong>代码</strong>:</p>
<pre><code>df1['SalaryPaid'] = df1['SalaryPaid'].str.replace(',', '')
# If you want the result as a string :
df1['2016 Salary ($)']= df1['SalaryPaid'].str.strip('$')
# if you want the result as float :
#df1['2016 Salary ($)']= df1['SalaryPaid'].str.strip('$').astype(float)
df1
</code></pre>
<p><strong>结果</strong>:</p>
<pre><code> Name SalaryPaid Year 2016 Salary ($)
0 John $204546289.35 2008 204546289.35
1 Peter $500231289.35 2009 500231289.35
</code></pre>