# how to compare the elements of 2 cell arrays and get their rows from cell2?

1 vue (au cours des 30 derniers jours)
chocho le 15 Mai 2017
Commenté : chocho le 15 Mai 2017
Hi Friends, I have 2 cell arrays cell1(1*1) and cell2(1*2) I want to compare the elements of cell1 with cell2 and when all the elements of cell 1 exist in both members of cell2 then get its corresponding row from cell2.
Input:
cell1={gene1;gene2;gene3;gene4;gene5}
cell2={gene1,gene3;gene10,gene100;gene2,gene5}
output
out={gene1,gene3;gene2,gene5}
I have tried isequal and find(ismember) and get empty array.
##### 5 commentairesAfficher 3 commentaires plus anciensMasquer 3 commentaires plus anciens
chocho le 15 Mai 2017
@Stephen Cobeldick bro , i already tried intersect but i'm not getting what i want. Actually i want to get the full row from cell 2 and this row should havein its both coulmns elements existed in cell1.
clear all
c1 =intersect( PPI_data{:, 1},Stage1Exp10_data{:, 1},'rows');
c2 =intersect(PPI_data{:, 2},Stage1Exp10_data{:, 1},'rows');
D=intersect(c1, c2,'rows');
chocho le 15 Mai 2017
@Stephen Cobeldick bro, I also tried this code but i want the full row
S= [PPI_data{:, 1} , PPI_data{:, 2}];
[C,ia,ib] = intersect( S, Stage1Exp10_data{:,1},'rows');

Connectez-vous pour commenter.

### Réponses (1)

KSSV le 15 Mai 2017
cell1={'gene1';'gene2';'gene3';'gene4';'gene5'} ;
cell2={'gene1','gene3';'gene10','gene100';'gene2','gene5'} ;
out={'gene1','gene3';'gene2','gene5'} ;
[ia,ib] = ismember(cell2,cell1) ;
cell2(ia)
##### 3 commentairesAfficher 1 commentaire plus ancienMasquer 1 commentaire plus ancien
KSSV le 15 Mai 2017
cell1 = PPI_data ;
cell2 = Stage1Exp10_data{1} ;
cell1 = [cell1{1} cell1{2}] ;
[ia,ib] = ismember(cell2,cell1) ;
cell2(ia)
chocho le 15 Mai 2017
@KSSV hi bro, Thanks for you reply but I want to get a row.

Connectez-vous pour commenter.

### Catégories

En savoir plus sur 矩阵和数组 dans Help Center et File Exchange

### Community Treasure Hunt

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

Start Hunting!