擅长:python、mysql、java
<p>您可以将<a href="http://pandas.pydata.org/pandas-docs/stable/groupby.html#filtration" rel="nofollow noreferrer">filtration</a>与修改过的<a href="https://stackoverflow.com/a/46275034/2901002">original solution</a>和{a3}一起使用,以返回至少一个<code>True</code>:</p>
<pre><code>def f(x):
a = any([(x['name'].isin(y)).all() & pd.Series(y).isin(x['name']).all() for y in names])
return (a)
df1 = (df.groupby('id').filter(f))
print (df1)
id name [A LOT OF OTHER COLUMNS]
1 2 bla2 [A LOT OF OTHER COLUMNS]
2 2 bla3 [A LOT OF OTHER COLUMNS]
3 2 bla4 [A LOT OF OTHER COLUMNS]
6 5 bla6 [A LOT OF OTHER COLUMNS]
7 5 bla7 [A LOT OF OTHER COLUMNS]
</code></pre>