擅长:python、mysql、java
<p>gp-您的gropby数据帧</p>
<p>或者-您的原始数据帧</p>
<pre><code>```python
or_drop = or.drop_duplicates(subset=['CITY', 'TEC', 'SET', 'AZIM'], keep='first')
expected = gp.merge(or['COD', 'STATE'], how=inner, on=['COD'])
expected = expected.merge(or_drop['TEC', 'SET', 'AZIM','CITY'], how=inner, on=['TEC', 'SET', 'AZIM])
</code></pre>
<p>对不起,我没有检查过</p>