Substitute for join/ outerjoin in cell array?

Question

phlie 2016-9-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/302075-substitute-for-join-outerjoin-in-cell-array

回答： Guillaume 2016-9-6

采纳的回答： Guillaume

It seems join and outerjoin only work for tables. Is there a substitute for cell arrays?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Guillaume 2016-9-6

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/302075-substitute-for-join-outerjoin-in-cell-array#answer_233953

在 MATLAB Online 中打开

Well, you can always convert your cell arrays to a table with cell2table, do the join and convert back.

Otherwise, it's not particularly hard to implement using ismember:

%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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

KSSV 2016-9-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/302075-substitute-for-join-outerjoin-in-cell-array#answer_233941

在 MATLAB Online 中打开

You can join them...

   k{1} = 1 ;
   k{2} = [2 3] ;
   l{1} = [3,4];
   l{2} = [5] ;
% join them 
   kl = [k l] ;

2 个评论
显示无隐藏无

phlie 2016-9-6

Thank you. Am I missing something or is there no merging key in your answer? Join/ outerjoin allows me to join data based on a common value of data k and l, i.e., I can merge even if the data is not ordered the same way (or if the dimensions don't match).