MATLAB Answers

compare two columns and their corresponding values from two different excel files

28 views (last 30 days)
Aladdin
Aladdin on 6 Apr 2021
Commented: Aladdin on 7 Apr 2021
Hi,
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)
  2 Comments

Sign in to comment.

Accepted Answer

dpb
dpb on 7 Apr 2021
>> data1=readtable('data.xlsx');data2=readtable('Data2.xlsx');
>> setdiff(data1,data2,'rows')
ans =
3×2 table
country city
_____________ ____________
{'ALGERIA' } {'TIRANA' }
{'ARGENTINA'} {'CANBERRA'}
{'AUSTRALIA'} {'ALGIERS' }
>>

More Answers (0)

Tags

Products


Release

R2020b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by