擅长:python、mysql、java
<p>对于单个搜索值</p>
<pre><code>df[df.values == "banana"]
</code></pre>
<p>或</p>
<pre><code> df[df.isin(['banana'])]
</code></pre>
<p>对于多个搜索词:</p>
<pre><code> df[(df.values == "banana")|(df.values == "apple" ) ]
</code></pre>
<p>或</p>
<pre><code>df[df.isin(['banana', "apple"])]
# A B C
# 1 apple banana NaN
# 2 NaN NaN apple
# 3 banana NaN NaN
# 4 apple apple NaN
</code></pre>
<p>来自Divakar:返回带有两个的行</p>
<pre><code>select_rows(df,['apple','banana'])
# A B C
# 0 apple banana pear
</code></pre>