Finding specific values on one table based on values in another table
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Shah
el 9 de Mzo. de 2020
Comentada: Shah
el 10 de Mzo. de 2020
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?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/275999/image.png)
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 comentarios
Respuesta aceptada
Ameer Hamza
el 9 de Mzo. de 2020
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.
Más respuestas (0)
Ver también
Categorías
Más información sobre Tables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!