MATLAB 中元胞数组的左连接

I've 2 cellMATLAB 中的数组，例如：

A= {jim,4,paul,5 ,sean ,5,rose, 1}

第二个：

B= {jim, paul, george, bill, sean ,rose}

我想做一个 SQL 左连接，这样我就可以得到 B 中的所有值以及 A 中的匹配项。如果它们没有出现在 A 中，那么它将是“0”。方法：

C= {jim, 4, paul, 5, george, 0, bill, 0, sean, 5, rose, 1}

没有找到任何相关功能寻求帮助。 谢谢。

方法#1

%// Inputs
A= {'paul',5 ,'sean' ,5,'rose', 1,'jim',4}
B= {'jim', 'paul', 'george', 'bill', 'sean' ,'rose'}

%// Reshape A to extract the names and the numerals separately later on
Ar = reshape(A,2,[]);

%// Account for unsorted A with respect to B
[sAr,idx] = sort(Ar(1,:))
Ar = [sAr ; Ar(2,idx)]

%// Detect the presence of A's in B's  and find the corresponding indices 
[detect,pos] = ismember(B,Ar(1,:))

%// Setup the numerals for the output as row2
row2 = num2cell(zeros(1,numel(B)));
row2(detect) = Ar(2,pos(detect)); %//extracting names and numerals here

%// Append numerals as a new row into B and reshape as 1D cell array
out = reshape([B;row2],1,[])

代码运行-

A = 
    'paul'    [5]    'sean'    [5]    'rose'    [1]    'jim'    [4]
B = 
    'jim'    'paul'    'george'    'bill'    'sean'    'rose'
out = 
    'jim'    [4]    'paul'    [5]    'george'    [0]    'bill'    [0]    'sean'    [5]    'rose'    [1]

方法#2

如果您想将元胞数组中的数字作为字符串使用，您可以使用此修改版本 -

%// Inputs [Please edit these to your actual inputs]
A= {'paul',5 ,'sean' ,5,'rose', 1,'jim',4};
B= {'jim', 'paul', 'george', 'bill', 'sean' ,'rose'}

%// Convert the numerals into string format for A
A = cellfun(@(x) num2str(x),A,'Uni',0)

%// Reshape A to extract the names and the numerals separately later on
Ar = reshape(A,2,[]);

%// Account for unsorted A with respect to B
[sAr,idx] = sort(Ar(1,:));
Ar = [sAr ; Ar(2,idx)];

%// Detect the presence of A's in B's  and find the corresponding indices 
[detect,pos] = ismember(B,Ar(1,:));

%// Setup the numerals for the output as row2
row2 = num2cell(zeros(1,numel(B)));
row2 = cellfun(@(x) num2str(x),row2,'Uni',0); %// Convert to string formats
row2(detect) = Ar(2,pos(detect)); %//extracting names and numerals here

%// Append numerals as a new row into B and reshape as 1D cell array
out = reshape([B;row2],1,[])

代码运行-

B = 
    'jim'    'paul'    'george'    'bill'    'sean'    'rose'
A = 
    'paul'    '5'    'sean'    '5'    'rose'    '1'    'jim'    '4'
out = 
    'jim'    '4'    'paul'    '5'    'george'    '0'    'bill'    '0'    'sean'    '5'    'rose'    '1'