How to extact commone elements from different columns of a cell array

1 次查看（过去 30 天）
Arsal15
Arsal15 2016-2-28
评论： Image Analyst 2016-2-28
I want to extract the common entries in different column of a cell array.
Any idea how to extract them? mat file is attached

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2016-2-28
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 个评论
Arsal15
Arsal15 2016-2-28
Image Analyst, Thanks for your reply.
But i have tried this, I have attached a mat file of [1x9] cell array which has my data. I am trying it but i am not successful so far. Can you kindly give some time for this.? I will be thankful.
Image Analyst
Image Analyst 2016-2-28
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)

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Big Data Processing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by