擅长:python、mysql、java
<p>对“ID”列执行<code>groupby</code>,然后使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.core.groupby.DataFrameGroupBy.filter.html" rel="noreferrer">^{<cd2>}</a>:</p>
<pre><code>df = df.groupby('ID').filter(lambda grp: grp['Yurt'].eq('-').sum() == 2)
</code></pre>
<p>输出:</p>
<pre><code> ID % Yurt
4 lmn789 0.837 Mickey's
5 lmn789 0.856 Chopped Cheese
6 lmn789 0.813 -
7 lmn789 0.812 -
</code></pre>