How to compare the rows of small file with rows of large cell?

Hello guys, I want to compare the rows of 2 cells [cell1(627*1) and cell2 (126300*6)], and if they are equal get the columns of that overlapped row from cell2. Inputs:

Expected outputs:

Could anyone plz help me in this issue as i tried with is equal command but no results??

I appreciate any help!

[chocho]

PLz, any one can help me ?

[chocho]

Plz, Can anyone else help me out???

Answer 1

[KSSV]

 Check the below demo code.

% Generate random cells 
cell1 = cell(10,1) ;
cell2 =  cell(100,2) ;
for i = 1:size(cell1,1)
    cell1{1} = rand(3,1) ;
end
for i = 1:size(cell2,1)
    for j = 1:size(cell2,2) 
        cell2{i,j} = rand(10,1) ;
    end
end

% GEt common 
iwant = cell(size(cell2)) ;
for i = 1:size(cell2,1)
    for j = 1:size(cell2,2)
        for k = 1:size(cell1,1)
            c = ismember(cell1{k},cell2{i,j}) ;
        end
    end
end

[chocho]

what's the meaning of rand(3,1) and rand(10,1)

[Stephan]

It creates different sizes random numbers to have some numbers for the example.

[chocho]

But i don't have different sizes in my case!

so i will make rand(627,1) and rand(126300,1)?

[chocho]

@KSSVI try your code but no results! I got c with 0 element values however, this is not my expected results.

[KSSV]

It shall work....attach your data.

[chocho]

This is my data you can have a try!

[KSSV]

S1 = load('ud1.mat') ;
c1 = S1.UD1 ;

S2 = load('cna1.mat') ;
c2 = S2.CNA ;

[m,n] = size(c2) ;

C = cellfun(@(x) x(1:12),c2(:,1),'un',0) ;
idx = ismember(C,c1) ;
iwant = C(idx) ;

[chocho]

@KSSV Is it work!

[chocho]

i got this error ?

Subscript indices must either be real positive integers or logicals.

Error in Untitle (line 12) C = cellfun(@(x) x(1:12),c2(:,i),'un',0 ) ;

[chocho]

@KSSV see the error i got plz fix it!

[KSSV]

It should not show any error..show me the whole code,,you tried.

[chocho]

    S1 = load('ud1.mat') ;
    c1 = S1.UD1 ;
    S2 = load('cna1.mat') ;
    c2 = S2.CNA ;
    [m,n] = size(c2) ;
    C = cellfun(@(x) x(1:12),c2(:,1),'un',0) ;
    idx = ismember(C,c1) ;
    iwant = C(idx) ;

I try the above code (your code).

I got this error

>> Untitle Subscript indices must either be real positive integers or logicals.

Error in Untitle (line 8) C = cellfun(@(x) x(1:12),c2(:,i),'un',0) ;

[KSSV]

Sorry there is a typo error. i = 1. Edited the code.

[chocho]

@KSSV now work but plz see my expected output

I want the common rows with their columns too( as i mentioned in my post)

However, iwant output has only one column!

[KSSV]

idx gives you the indices of common elements..you can extract what you want from there.

[chocho]

@KSSV idx have also one logical column but i want 6 columns.

How i can update your code?

You are putting in c2(:,1) only 1 column and all the rows. I use a loop but doesn't work.

[KSSV]

c2(idx,:)

gives the entire cell.

[chocho]

@KSSV This command L=c2(idx,:) after iwant line right?

Could you plz update your initial code then i can accept your answer may the other people use it

Thanks a lot for your cooperation!

[chocho]

@KSSV Last thing...

 Now, i get my expected outputs but the first column i still want it with 12 characters, not the full one.  
In iwant = C(idx); it was ok but with the new line c2(idx,:) i got the full name?

[KSSV]

iwant = [C(idx) c2(idx,2:end)] ;

[chocho]

@KSSV Thanks a lot!

Answer 2

[Guillaume]

I am certain we've answered similar questions from you in the past. By now, you should also know that pictures are useless for us and that actually attaching an example of your data is a lot more useful.

With cell arrays, you can use intersect to find which elements overlap between your two columns arrays. It's then trivia to construct your output from the 2nd and 3rd output argument of intersect.

Even easier, would be to convert your cell arrays to tables. The whole operation is then simply a call to innerjoin:

innerjoin(cell2table(UD1), cell2table(whateverthatothercellarrayisnamed), 'Keys', 1)

[chocho]

@Guillaume Ok, next time i will directly attach the data.

[Guillaume]

In case you haven't noticed, I also gave you a very simple way to achieve what you want. Just one line of code needed:

innerjoin(cell2table(UD1), cell2table(whateverthatothercellarrayisnamed), 'Keys', 1)

[chocho]

@Guillaume Thanks, This is also a good solution