擅长:python、mysql、java
<p>不直接回答问题,但可能会帮助别人。</p>
<p>我有一个名为<code>Volume</code>的列,它同时具有<code>-</code>(无效/NaN)和用<code>,</code>格式化的数字</p>
<pre><code>df['Volume'] = df['Volume'].astype('str')
df['Volume'] = df['Volume'].str.replace(',', '')
df['Volume'] = pd.to_numeric(df['Volume'], errors='coerce')
</code></pre>
<p><strong>强制转换为字符串是应用于<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.replace.html" rel="noreferrer">str.replace</a>所必需的</strong></p>
<p><a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.replace.html" rel="noreferrer">pandas.Series.str.replace</a><br/>
<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.to_numeric.html" rel="noreferrer">pandas.to_numeric</a></p>