I’m trying to compare two columns and their corresponding values from two different excel files. I want to know what values from column one in spreadsheet one matches column one in spreadsheet two but their corresponding values are not the same. And I want to print those different values.
Below I have a list of countries and their corresponding cities, I mismatched some of them for example ALGERIA and it’s corresponding is ALGIERS but in the second document it has TIRANA as corresponding city. I want to show that difference. I used ismember function but I don’t think this is an accurate approach.
Data = readtable("Data.xlsx")
Data2 = readtable("Data2.xlsx")
Matches = ismember(Data.country,Data2.country) & ~ismember(Data.city,Data2.city)