MATLAB Answers

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

조회 수: 2(최근 30일)
Aladdin
Aladdin 6 Apr 2021
댓글: Aladdin 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
Aladdin
Aladdin 6 Apr 2021
I tried that and readmarix doesn't really work with this particular case!

댓글을 달려면 로그인하십시오.

채택된 답변

dpb
dpb 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' }
>>

추가 답변(0개)

태그

제품


릴리스

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by