擅长:python、mysql、java
<p>与<code>any</code>一起使用<code>filter</code></p>
<pre><code>df.groupby('ID').filter(lambda x : ((x['col_3']=='Steak').any())&((x['col_3']=='Chicken').any()))
Out[14]:
ID col_2 col_3
0 1001 3 Steak
1 4003 8 Chicken
2 1001 2 Chicken
3 4003 1 Steak
</code></pre>
<p>过滤掉ID 7000</p>
<pre><code>df.groupby('ID').filter(lambda x : ~((x['col_3']=='Steak').any())&((x['col_3']=='Chicken').any()))
Out[16]:
ID col_2 col_3
4 7000 7 Chicken
5 7000 9 Chicken
</code></pre>