Comparing cell with criteria

Hello! I have cell matrix "Spfcfef" (120x2) as attached and would like to produce 3 outputs.
1) numbers 1-9, that did not appear in either columns, by rows. The result should be a 120 x 1 cell.
2) numbers that appeared in column 1, but not in column 2
Is there a function in matlab that I may use to compare between columns/code with? Many thanks! :)

2 Comments

Stephen23
Stephen23 on 25 Feb 2020
Edited: Stephen23 on 25 Feb 2020
Earlier very similar questions, with answers that use ismember:
"Is there a function in matlab that I may use to compare between columns/code with?"
Have you considered using ismember ? At the bottom of every function's documentation page is a section entitled "See Also", which contains a list of related functions, you can find several functions that would help do what you want.
I did, but I'm not certain how to include Q1 into the code. still learning, am a beginner~

Sign in to comment.

 Accepted Answer

Stephen23
Stephen23 on 25 Feb 2020
Edited: Stephen23 on 25 Feb 2020
out1 = cellfun(@(l,r) setdiff(1:9,[l,r]), Spfcfef(:,1), Spfcfef(:,2), 'Uni',0);
out2 = cellfun(@(l,r) setdiff(l,r), Spfcfef(:,1), Spfcfef(:,2), 'Uni',0);

More Answers (0)

Categories

Find more on MATLAB in Help Center and File Exchange

Asked:

on 25 Feb 2020

Commented:

on 25 Feb 2020

Community Treasure Hunt

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

Start Hunting!