Substitute for join/ outerjoin in cell array?
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
It seems join and outerjoin only work for tables. Is there a substitute for cell arrays?
0 commentaires
Réponse acceptée
Guillaume
le 6 Sep 2016
Well, you can always convert your cell arrays to a table with cell2table, do the join and convert back.
%INPUTS:
%leftcell: first cell array
%rightcell: second cell array
%leftkeys: column indices for left key
%rightkeys: column indices for right key
%JOIN:
[common, rows] = ismember(leftcell(:, leftkeys), righcell(:, rightkeys), 'rows');
joinedcell = [leftcell(common, :), rightcell(rows, :)];
%OUTERJOIN:
[commonleft, rows] = ismember(leftcell(:, leftkeys), righcell(:, rightkeys), 'rows');
commonright = ismember(rightcell(:, leftkeys), leftcell(:, rightkeys), 'rows');
joinedcell = [leftcell(commonleft, :), rightcell(rows, :)];
joinedcell = [joinedcell; ... normal join
[cell(sum(~commonright), size(leftcell, 2)), rightcell(~commonright, :)]; ... add non matching rows from rightcell
[leftcell(~commonleft, :), cell(sum(~commonleft), size(righcell, 2))]]; ...add non matching rows from leftcell
I've not merged the left and right keys. It's not particularlty hard to do, and you could also select which columns to include in the join, but you should get the idea from the above.
0 commentaires
Plus de réponses (1)
KSSV
le 6 Sep 2016
You can join them...
k{1} = 1 ;
k{2} = [2 3] ;
l{1} = [3,4];
l{2} = [5] ;
% join them
kl = [k l] ;
2 commentaires
Voir également
Catégories
En savoir plus sur Cell Arrays 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!