擅长:python、mysql、java
<p>试试这个:</p>
<p>样品测向:</p>
<pre><code>df12= pd.DataFrame({'Product Code':['A','A','A','A','B','B','C','C','D','E'],
'Unit of Measurement':['x','x','y','z','w','w','q','r','a','c']})
</code></pre>
<p>分组方式并查看所有非唯一对的计数:</p>
<pre><code>new = df12.groupby(['Product Code','Unit of Measurement']).size().reset_index().rename(columns={0:'count'})
</code></pre>
<p>删除重复产品代码的所有行</p>
<pre><code>new.drop_duplicates(subset=['Product Code'], keep=False)
</code></pre>