Matching unequal cell arrays

Question

Ronald 2020-6-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/541559-matching-unequal-cell-arrays

评论： Ronald 2020-6-5

I have two unequal arrays and I want to match them to produce one array such that the unmatched cells are left empty i.e

A = {124,252,1252,225,598,999}
B = {598,'plant';
1252,'nil';
252,'blue'}

The result C;

C = {124,[];
252,'blue';
1252,'nil';
225,[];
598,'plant';
999,[]}

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

请先登录，再进行评论。

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

Answer 1

TADA 2020-6-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/541559-matching-unequal-cell-arrays#answer_445784

在 MATLAB Online 中打开

A = {124,252,1252,225,598,999};
B = {598,'plant';...
     1252,'nil';...
     252,'blue'};
 
 [~, Ai_member, Bi_member] = intersect([A{:}], [B{:,1}]);
 
 C = [A(:), cell(numel(A), 1)];
 [C{Ai_member, 2}] = B{Bi_member, 2}

3 个评论
显示 1更早的评论隐藏 1更早的评论

TADA 2020-6-4

编辑：TADA 2020-6-4

在 MATLAB Online 中打开

In that case, ismember should do the trick

it returns a logical index (flags) and the matching indices in B

for matching cells, the logical index is true and the B index has the index of the match

and for unmatched cells both indices have the value zero

A = {124,252,252,1252,225,225,598,598,999};
B = {598,'plant';...
     1252,'nil';...
     252,'blue'};
[flags, Bidx] = ismember([A{:}], [B{:,1}]);
C = [A(:), cell(numel(A), 1)];
[C{flags, 2}] = B{bidx(bidx > 0), 2}
C =
  9×2 cell array
    {[ 124]}    {0×0 double}
    {[ 252]}    {'blue'    }
    {[ 252]}    {'blue'    }
    {[1252]}    {'nil'     }
    {[ 225]}    {0×0 double}
    {[ 225]}    {0×0 double}
    {[ 598]}    {'plant'   }
    {[ 598]}    {'plant'   }
    {[ 999]}    {0×0 double}

Ronald 2020-6-5

This is really good. Thank you very much!

请先登录，再进行评论。

Answer 2

Stephen23 2020-6-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/541559-matching-unequal-cell-arrays#answer_446396

编辑：Stephen23 2020-6-4

在 MATLAB Online 中打开

Using tables:

>> TA = cell2table(A(:))
TA = 
    Var1
    ____
     124
     252
     252
    1252
     225
     225
     598
     598
     999
>> TB = cell2table(B'')
TB = 
    Var1     Var2  
    ____    _______
     598    'plant'
    1252    'nil'  
     252    'blue' 
>> T = outerjoin(TA,TB,'MergeKeys',true)
T = 
    Var1     Var2  
    ____    _______
     124    ''     
     225    ''     
     225    ''     
     252    'blue' 
     252    'blue' 
     598    'plant'
     598    'plant'
     999    ''     
    1252    'nil' 

Note that the output rows are sorted by the joining key. To keep the original order:

>> [T,X] = outerjoin(TA,TB,'MergeKeys',true);
>> T(X,:) = T
T = 
    Var1     Var2  
    ____    _______
     124    ''     
     252    'blue' 
     252    'blue' 
    1252    'nil'  
     225    ''     
     225    ''     
     598    'plant'
     598    'plant'
     999    '' 