Search rows of a matrix on another

Question

Matlab User 2015-11-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/255047-search-rows-of-a-matrix-on-another

评论： Matlab User 2015-11-16

I have two matricies. The first, A, is large (1968x100 double) and the second, T, is smaller (1968x1). In matrix A, each row contains unique elements corresponding to the smaller matrix. For example, A(1,:) = 6 2 3 53..... (up until 100 columns). What I need to do is search in T for the corresponding ROWS and extract their numeric value. So for this example, I need to search in T for the 6th, 2nd, 3rd, 53rd rows and extract their values.

I hope this is clear !!! Any help is much appreciated.

2 个评论
显示无隐藏无

Jan 2015-11-16

编辑：Jan 2015-11-16

A small example with [3 x 4] matrices might explain the problem uniquely.

Do you really want to search the "corresponding rows in T", when T has one row only? Do you mean searching the rows in A instead?

Matlab User 2015-11-16

For each row in A there are 100 elements. T has 1968 rows and 1 column. So, say for example A=[2 3 5;1 2 4;7 8 10], and T=[200;500;750,204,567..... up to 1968 rows], for A(1,:) I want to report the value of the 2nd, 3rd and 5th rows in T, i.e. 500,750 and 567. I hope this is clearer.

请先登录，再进行评论。

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

Answer 1

Guillaume 2015-11-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/255047-search-rows-of-a-matrix-on-another#answer_199996

编辑：Guillaume 2015-11-16

在 MATLAB Online 中打开

There is no search involved. It's simple matrix indexing:

A = [2 3 5;
     1 2 4;
     7 8 10];
T = [200; 500; 750; 204; 567; 123; 456; 789; 987; 654; 321];
newA = A; newA(A == 0) = 1; %to cope with zeros
values = T(newA); %that's it!
values(A == 0) = 0 %assuming that you want 0 for A == 0