擅长:python、mysql、java
<p>导入模块:</p>
<pre><code>import pandas as pd
import numpy as np
import random
</code></pre>
<p>创建示例数据</p>
<pre><code>df_copy = pd.DataFrame({'Lower Confidence Interval':[0,1,np.nan,8]})
minimo = np.nanmin(df_copy['Lower Confidence Interval'])
maximo = np.nanmax(df_copy['Lower Confidence Interval'])
</code></pre>
<p>计算NAN的数量</p>
<pre><code>cnt=df_copy['Lower Confidence Interval'].isnull().sum()
</code></pre>
<p>用最小值、最大值随机替换NAN:</p>
<pre><code>df_copy[df_copy['Lower Confidence Interval'].isnull()] = np.random.choice([minimo, maximo],cnt).reshape(cnt,1)
</code></pre>