Finding specific values on one table based on values in another table

Question

Shah 2020-3-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509806-finding-specific-values-on-one-table-based-on-values-in-another-table

评论： Shah 2020-3-10

I have two (3x100) tables. The first table (T1) consists of ID codes (1-10) and the second consists of scores related to that id code. I am interested in extracting values from T2 at specific values of T1, say 4, for example. I have tried join() and vertcat() but all those do is combine the two tables which makes it tedious for me to look at the values one by one. Is there a way for me to find all the values in T2 connected to a specific value in T1?

Above is after new_table=[t1; t2]. Rows 1-3 are from T1 and 4-6 are from T2 originally. In the above examle, I am interested in extracting all the values in T2 when T1=6.

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

请先登录，再进行评论。

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

Answer 1

Ameer Hamza 2020-3-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509806-finding-specific-values-on-one-table-based-on-values-in-another-table#answer_419182

在 MATLAB Online 中打开

Following code shows an example of what you are trying to do

% geenrating random tables
table1 = array2table(randi(5, 5, 10));
table2 = array2table(rand(5, 10));
b_ = table2array(table2);
result_1 = b_(table1.Variables==1);
result_2 = b_(table1.Variables==2);

It extracts all values from table2, at locations where elements of table1 have specific values.