How to match the table

2 次查看（过去 30 天）

显示更早的评论

Mekala balaji 2016-11-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/311236-how-to-match-the-table

评论： Mekala balaji 2016-11-11

采纳的回答： Guillaume

在 MATLAB Online 中打开

Hi,

I have input table and reference table:

Input Table:

Mek  S
Lahi  S
Raju  F
Ram  S
Krish  F
Mek  F
Ram  S
Balu  S
Raju  S

Reference:

Mek  VAL
Lahi  HAT
Raju  KJI
Ram  GAT
Krish  HTY
Balu  KTY

1. I want to match names of first column of input table, and extract the corresponding name in column2 of Reference table. I want the below output:

Mek  S  VAL
Lahi  S  HAT
Raju  F  KJI
Ram  S  GAT
Krish  F  HTY
Mek  F  VAL
Ram  S  GAT
Balu  S  KTY
Raju  S  KJI

Many thanks in advance

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

请先登录，再进行评论。

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

采纳的回答

Guillaume 2016-11-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/311236-how-to-match-the-table#answer_242482

在 MATLAB Online 中打开

Have you tried join?

%in the future make it easy to use your example in code by using valid matlab syntax
t1 = table({'Mek', 'Lahi', 'Raju', 'Ram', 'Krish', 'Mek', 'Ram', 'Balu', 'Raju'}.', num2cell('SSFSFFSSS').', 'VariableNames', {'Key', 'Value'}) 
t2 = table({'Mek' 'Lahi' 'Raju' 'Ram' 'Krish' 'Balu'}.', {'VAL' 'HAT' 'KJI' 'GAT' 'HTY' 'KTY'}.', 'VariableNames', {'Key', 'OtherValue'})
join(t1, t2)

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

Guillaume 2016-11-11

在 MATLAB Online 中打开

[isfound, matchrow] = ismember(c1(:, 1), c2(:, 1));
c3 = [c1, cell(size(c1, 1), 1)];
c3(isfound, 2) = c2(matchrow(isfound), 2);
c3(~isfound, 2) = {'Undefined'};

Mekala balaji 2016-11-11

在 MATLAB Online 中打开

Sir,

Thanks But third row is empty as shown below the simulated output (Actual 2nd row missing): c3 =

    'Mek'      'VAL'          []
    'Lahi'     'HAT'          []
    'Raju'     'KJI'          []
    'Ram'      'GAT'          []
    'Krish'    'HTY'          []
    'Mek'      'VAL'          []
    'Ram'      'GAT'          []
    'Balu'     'KTY'          []
    'Raju'     'KJI'          []
    'Venk'     'Undefined'    []
    'Raju'     'KJI'          []
    'Chai'     'Undefined'    []