MATLAB Answers

If statement or strcmp to compare names.

2 views (last 30 days)
Aladdin on 21 Jul 2021
Commented: Aladdin on 21 Jul 2021
Hi everyone,
I have two excel sheets, the first one has three columns names, score and extra activities. The second column has only one column with names.
I want to compare the two sheets and if the names matches then I want to add 10 points to the score. I would really appreciate any help. I uploaded the data and below is my code so far.
Data = readtable("Data.xlsx")
Data2 = readtable("Data2.xlsx")
Volunteer_Names = ismember(Data.Extra_activities,'Volunteer Work and Community Service');
Volunteer_Names = Data(Volunteer_Names,:)
Add_Points = strcmp(Data.Names,Data2.Names,:)

Accepted Answer

Walter Roberson
Walter Roberson on 21 Jul 2021
ismember(). If you only want to know if at least one matches then any() the results; if you want to know how many matched then nnz() the ismember() result

More Answers (0)




Community Treasure Hunt

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

Start Hunting!

Translated by