#Using python panda for comparing two excel files via same col #samecolname means same column name in two files for comparing via that... #here is the code:
import pandas as pd import numpy as np
file1 = pd.read_excel("file1.xlsx", na_values=['NA']) file2 = pd.read_excel("file2.xlsx", na_values=['NA'])
df2 = file1 df1 = file2
res = df1[df1['samecolname'].isin(df2['samecolname'].unique())]
res2 = df2[df2['samecolname'].isin(df1['samecolname'].unique())]
res.to_excel('diff1-insecond-but-not-in-first.xlsx',index=False) res2.to_excel('diff2-in-first-not-in-second.xlsx',index=False)