擅长:python、mysql、java
<p>您可以使用pandas的replace方法;还可以保留千位分隔符“,”和小数点分隔符“</p>
<pre><code>import pandas as pd
df = pd.DataFrame(['$40,000.32*','$40000 conditions attached'], columns=['pricing'])
df['pricing'].replace(to_replace="\$([0-9,\.]+).*", value=r"\1", regex=True, inplace=True)
print(df)
pricing
0 40,000.32
1 40000
</code></pre>