擅长:python、mysql、java
<p>这对你的情况应该有用。我刚从你找到的重复的MKT中删除了唯一的MKT。你知道吗</p>
<pre><code>duplicate = {k:set(v) for k, v in newdf[newdf.duplicated(['PERIOD_ID','STORE_ID'],
keep=False)].groupby('PERIOD_ID')['MKT']}
unique = {k:set(v) for k, v in newdf[newdf.duplicated(['PERIOD_ID','STORE_ID'],
keep=False) == False].groupby('PERIOD_ID')['MKT']}
final = dict()
for k in duplicate:
if k in unique:
final[k] = tuple(duplicate[k] - unique[k])
else:
final[k] = tuple(duplicate[k])
print(final)
</code></pre>