Nov-11-2021, 10:17 PM
import pandas as pd data1=[('id1','desc1'),('id2','desc2'),('id3','desc3')] data2=[('id1','wrong description'),('id2','desc2')] df1=pd.DataFrame(data1,columns=['ID','DESCRIPTION']) df2=pd.DataFrame(data2,columns=['ID','DESCRIPTION']) print(pd.merge(df1,df2, indicator=True, how='outer') .query('_merge=="left_only"') .drop('_merge', axis=1))
Output: ID DESCRIPTION
0 id1 desc1
2 id3 desc3
Does this work?