Create new table variable filled with values from another table

Question

Haris K. 2020-10-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/617063-create-new-table-variable-filled-with-values-from-another-table

评论： Ameer Hamza 2020-10-17

Hi. I have the following tabels, T1 and T2:

Name1=["A","B","C","D"]'
Des1=["Shoubidou","Abra","Ca","Dabra"]'
T1=table(Name1, Des1) 
Name2 =["C","B","B","A","B","B","A"]'
T2 = table(Name2)

I would like to create a new variable Des2 (in table T2), which for each T2 element contains the description taken from T1. The final result should be:

Des2=["Ca","Abra","Abra","Shoubidou","Abra","Abra","Shoubidou"]'
T2final = table(Name2, Des2)

One way to do this is to iterate over the elements of T2. Is there any other way without a for-loop?

Notice that some elements in T1 it is possible that they are not contained in T2 (just in case this changes your solution).

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

请先登录，再进行评论。

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

Answer 1

Ameer Hamza 2020-10-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/617063-create-new-table-variable-filled-with-values-from-another-table#answer_516563

在 MATLAB Online 中打开

Try this

Name1=["A","B","C","D"]'
Des1=["Shoubidou","Abra","Ca","Dabra"]'
T1=table(Name1, Des1) 
Name2 =["C","B","B","A","B","B","A"]'
T2 = table(Name2)
[~, idx] = ismember(Name2, Name1);
T2.Des2 = Des1(idx);