Match strings from 2 tables

Question

SChow 2020-2-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506162-match-strings-from-2-tables

评论： SChow 2020-2-18

采纳的回答： Stephen23

Hi, I have 2 tables example:

TA=

'Name' 'Code'

'AFG' 120

'CAN' 210

'BER' 121

'FIJ' 910

'KOS' 991

'HAW' 101

'CHN' 211

TB=

'Name' 'Value'

'AFG' 0.5

'CAN' 1.2

'BER' 2.1

'FIJ' 9.1

'CHN' 0.2

'HAW' 1.6

I need a table TC in order of TA but containg the corresponding value from TB

'Name' 'Code' 'Value'

'AFG' 120 0.5

'CAN' 210 1.2

'BER' 121 2.1

'FIJ' 910 9.1

'KOS' 991 NaN

'HAW' 101 1.6

'CHN' 211 0.2

I know I need to use the ismember function for this, but not sure how to implement it here

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2020-2-18

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506162-match-strings-from-2-tables#answer_416134

编辑：Stephen23 2020-2-18

在 MATLAB Online 中打开

Method one: outerjoin (TC rows may be in a different order to TA):

>> TC = outerjoin(TA,TB,'MergeKeys',true)
TC = 
    Name     Code    Value
    _____    ____    _____
    'AFG'    120     0.5  
    'BER'    121     2.1  
    'CAN'    210     1.2  
    'CHN'    211     0.2  
    'FIJ'    910     9.1  
    'HAW'    101     1.6  
    'KOS'    991     NaN  

Method two: outerjoin (TC rows are in the same order as TA):

>> [TC,idx] = outerjoin(TA,TB,'MergeKeys',true);
>> [~,idy] = sort(idx);
>> TC = TC(idy,:)
TC = 
    Name     Code    Value
    _____    ____    _____
    'AFG'    120     0.5  
    'CAN'    210     1.2  
    'BER'    121     2.1  
    'FIJ'    910     9.1  
    'KOS'    991     NaN  
    'HAW'    101     1.6  
    'CHN'    211     0.2 

Method three: ismember (TC rows are in the same order as TA):

>> TC = TA;
>> TC{:,'Value'} = NaN;
>> [X,Y] = ismember(TA.Name,TB.Name);
>> TC.Value(X) = TB.Value(Y(X))
TC = 
    Name     Code    Value
    _____    ____    _____
    'AFG'    120     0.5  
    'CAN'    210     1.2  
    'BER'    121     2.1  
    'FIJ'    910     9.1  
    'KOS'    991     NaN  
    'HAW'    101     1.6  
    'CHN'    211     0.2