How to extact commone elements from different columns of a cell array
1 view (last 30 days)
Show older comments
I want to extract the common entries in different column of a cell array.
Any idea how to extract them? mat file is attached
0 Comments
Accepted Answer
Image Analyst
on 28 Feb 2016
Use intersect(). See the first example in the help:
Intersection of Two Vectors
Define two vectors with values in common.
A = [7 1 7 7 4]; B = [7 0 4 4 0];
% Find the values common to both A and B.
C = intersect(A,B)
C =
4 7
2 Comments
Image Analyst
on 28 Feb 2016
That is a 1 row by 9 column cell array. Each cell has a column vector in it of different lengths.
What two columns do you want to compare? Like column (cell) 3 with column (cell) 7? Or what? Why can't you just get the contents and do what I said
s = load('cell_data_rx_ids.mat') % Load into structure.
cell_data_rx_node = s.cell_data_rx_node; % Extract from structure.
column3 = cell_data_rx_node{3} % Extract column 3
column7 = cell_data_rx_node{7} % Extract column 7.
% Now find intersection, the common values.
commonValues = intersect(column3, column7)
More Answers (0)
See Also
Categories
Find more on Big Data Processing 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!