擅长:python、mysql、java
<p>另一种选择是将<code>DataFrame.interpolate</code>与<code>round</code>一起使用:</p>
<pre><code>nans = df.notna().all(axis=1).cumsum().drop_duplicates()
low, high = nans.idxmin(), nans.idxmax()
df.loc[low+1: high].interpolate().round()
Col1 Col2 Col3
1 1.0 1.0 1.0
2 1.0 2.0 3.0
3 2.0 2.0 5.0
4 3.0 3.0 1.0
</code></pre>