擅长:python、mysql、java
<p>使用函数<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.notnull.html" rel="nofollow noreferrer">^{<cd1>}</a>或反转<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.isnull.html" rel="nofollow noreferrer">^{<cd2>}</a>:</p>
<pre><code>print (df[df.prod_id.notnull()])
prod_id prod_ref
0 10.0 ef3920
1 12.0 bovjhd
4 30.0 kbknkn
print (df[~df.prod_id.isnull()])
prod_id prod_ref
0 10.0 ef3920
1 12.0 bovjhd
4 30.0 kbknkn
</code></pre>
<p>另一个解决方案是<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.dropna.html" rel="nofollow noreferrer">^{<cd3>}</a>,但需要指定要检查的列<code>NaN</code>:</p>
^{pr2}$
<p>如果其他列中没有<code>NaN</code>值,请使用<a href="https://stackoverflow.com/a/39601897/2901002">Alberto Garcia-Raboso's solution</a>。在</p>