擅长:python、mysql、java
<p>万岁!更多选择!</p>
<h3><code>np.where</code></h3>
<pre><code>df[np.where(df.C | df.D, True, False)]
A B C D
0 John Doe 45 True False
2 Alan Holmes 55 False True
3 Eric Lamar 29 True True
</code></pre>
<hr/>
<h3><code>pd.Series.where</code>在<code>df.index</code></h3>
<pre><code>df.loc[df.index.where(df.C | df.D).dropna()]
A B C D
0.0 John Doe 45 True False
2.0 Alan Holmes 55 False True
3.0 Eric Lamar 29 True True
</code></pre>
<hr/>
<h3><code>df.select_dtypes</code></h3>
<pre><code>df[df.select_dtypes([bool]).any(1)]
A B C D
0 John Doe 45 True False
2 Alan Holmes 55 False True
3 Eric Lamar 29 True True
</code></pre>
<hr/>
<h3>滥用<code>np.select</code></h3>
<pre><code>df.iloc[np.select([df.C | df.D], [df.index])].drop_duplicates()
A B C D
0 John Doe 45 True False
2 Alan Holmes 55 False True
3 Eric Lamar 29 True True
</code></pre>