logical operation with categorical data

7 views (last 30 days)
I have 6 csv files with one of the variables in the csv file containing names of players. I want to perform operations only if the name in the particular file is the name of a certain player. When I perform the logical operation in the 'if' line, I get an error. Am I performing the logical operation incorrectly? Is there a different way to do logical operations with categorical data?
for i = 1:6
csv = readtable(file(i).name);
K=categorical(csv.Var2(2)); %% reads the player name as categorical data.
if K=='Ronaldo'||'Messi'||'Neymar' % Only enter the loop if K is one of these players names
m=0;
m=m+1;
end
end
  2 Comments
Stephen23
Stephen23 on 1 Dec 2021
Edited: Stephen23 on 1 Dec 2021
This will not work because you are attempting logical operations on character arrays of different sizes:
'Ronaldo'||'Messi'||'Neymar'
Use ISMEMBER or CONTAINS instead.
Doron Joffe
Doron Joffe on 1 Dec 2021
Thank you very much for all the help.

Sign in to comment.

Accepted Answer

Rik
Rik on 1 Dec 2021
This depends a bit on your source data, but you should look at the ismember function. Especially when combined with any, it really helps in these situations. Alternatively you could look at switch, which also allows multiple case definitions.

More Answers (0)

Categories

Find more on Categorical Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!