采用采用pandas中的drop_duplicates对数据去两次重,一次将重复数据全部去除(keep=False)记为data1,另一次将重复数据保留一个(keep='first)记为data2;
求data1和data2的差集即可:data2.append(data1).drop_duplicates(keep=False)
data1 = a.drop_duplicates(subset=["编号","日期"]
data2 = a.drop_duplicates(subset=["编号","日期"],keep = False)
data2.append(data1).drop_duplicates(keep=False)