擅长:python、mysql、java
<p>试试这个:</p>
<pre><code>def bothInCity(df, n1, n2):
s = {n1, n2}
c = df.groupby('City').Name.apply(set)
chk = lambda x: s.issubset(x)
return c.loc[c.apply(chk)]
</code></pre>
<p>然后像这样使用:</p>
<pre><code>bothInCity(df, 'Bob', 'Alice')
City
Seattle {Bob, Alice}
Name: Name, dtype: object
</code></pre>