擅长:python、mysql、java
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.to_numeric.html" rel="nofollow noreferrer">^{<cd1>}</a>转换为数值,它支持通过<code>errors='coerce'</code>将不可转换值转换为float<code>NaN</code>:</p>
<pre><code>df['col1'] = pd.to_numeric(df['col1'], errors='coerce')
</code></pre>
<p>然后直接使用<code>groupby</code>+<code>transform</code>:</p>
<pre><code>df['col1'] = df['col1'].fillna(df.groupby('col2')['col1'].transform('mean'))
</code></pre>