Effacer les filtres
Effacer les filtres

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

2 vues (au cours des 30 derniers jours)
chocho
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 commentaires
chocho
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
load('cell1')
load('cell2')
c1 =intersect( PPI_data{:, 1},Stage1Exp10_data{:, 1},'rows');
c2 =intersect(PPI_data{:, 2},Stage1Exp10_data{:, 1},'rows');
D=intersect(c1, c2,'rows');
chocho
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
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 commentaires
KSSV
KSSV le 15 Mai 2017
load cell1.mat ;
load cell2.mat ;
cell1 = PPI_data ;
cell2 = Stage1Exp10_data{1} ;
cell1 = [cell1{1} cell1{2}] ;
[ia,ib] = ismember(cell2,cell1) ;
cell2(ia)
chocho
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

Tags

Community Treasure Hunt

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

Start Hunting!