Matching Values from one Table to Another

Question

Jana Sarran 2023-3-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1936104-matching-values-from-one-table-to-another

评论： Joe Vinciguerra 2023-3-28

采纳的回答： Walter Roberson

Hi everyone,

Is there a way from me to match the numbers in two dataset and extract the values in the row?

For instance,

This is my first table:

This is my second table:

What is would like to do---> I would like to search for my second table values in the first table, specifically under "FirstVID" and "SecondVID". Once I have a match of these values, I would like the numbers on "FirstVID" or "SecondVID" to be replaced by the string "AV".

Is this posssible?

Thank you.

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2023-3-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1936104-matching-values-from-one-table-to-another#answer_1202209

在 MATLAB Online 中打开

Change

FirstVID = NewTab (:,["FirstVID"])

to

FirstVID = NewTab {:,["FirstVID"]};

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

Jana Sarran 2023-3-27

Thank you!. It worked.

请先登录，再进行评论。

Answer 2

Joe Vinciguerra 2023-3-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1936104-matching-values-from-one-table-to-another#answer_1202149

在 MATLAB Online 中打开

Veh = [2007; 1265; 1266; 1269];
FirstVID = [1881; 1269; 2007];
SecondVID = [1892; 2188; 1266];
T = table(FirstVID, SecondVID);
% find data common to each table
[~, ~, ib1] = intersect(Veh, T.FirstVID);
[~, ~, ib2] = intersect(Veh, T.SecondVID);
% Convert to cell since you want mixed data types
T.FirstVID = num2cell(T.FirstVID);
T.SecondVID = num2cell(T.SecondVID);
% using the indexing found above, replace with "AV"
T.FirstVID(ib1) = {'AV'};
T.SecondVID(ib2) = {'AV'};
disp(T)
    FirstVID    SecondVID
    ________    _________

    {[1881]}    {[1892]} 
    {'AV'  }    {[2188]} 
    {'AV'  }    {'AV'  } 