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

2 vues (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!