How to input corresponding data from separate matrices

Question

Noah 2023-1-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1889067-how-to-input-corresponding-data-from-separate-matrices

编辑： Voss 2023-1-6

采纳的回答： Voss

I have a matrix

A = [1 2 3 4 5 6 7 8 9 10] '

and

B = [ 2 3 1 7 9 10 4 6 5 8; 12 43 64 94 27 58 64 13 90 74]'

I am trying to make a script that reads the i-th value of matrix A and matches it to the same value in matrix B. Then take the corresponding value in matrix B from the same row (so for A(1,1) it will read B(3,1)) and take the value 64 from B(3,2) and put it in a separate column matrix.

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

请先登录，再进行评论。

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

Answer 1

Voss 2023-1-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1889067-how-to-input-corresponding-data-from-separate-matrices#answer_1142567

编辑：Voss 2023-1-6

在 MATLAB Online 中打开

A = [1 2 3 4 5 6 7 8 9 10].';
B = [ 2 3 1 7 9 10 4 6 5 8; 12 43 64 94 27 58 64 13 90 74].';
[ism,idx] = ismember(A,B(:,1));
C = B(idx(ism),2)
C = 10×1
    64
    12
    43
    64
    90
    13
    94
    74
    27
    58

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

请先登录，再进行评论。

Answer 2

Bora Eryilmaz 2023-1-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1889067-how-to-input-corresponding-data-from-separate-matrices#answer_1142292

编辑：Bora Eryilmaz 2023-1-5

在 MATLAB Online 中打开

A = [1 2 3 4 5 6 7 8 9 10]';
B = [ 2 3 1 7 9 10 4 6 5 8; 12 43 64 94 27 58 64 13 90 74]';
% Iterate over every element of A
N = numel(A(:));
C = zeros(N, 1); % Output column matrix
for i = 1:N
    rowA = A(i);
    rowB = find(B(:,1) == rowA) % Find row of B corresponding to the element of A
    
    C(rowA) = B(rowB,2); % Rows of C match rows of A
    %C(rowB) = B(rowB,2); % Rows of C match rows of B
end
rowB = 3
rowB = 1
rowB = 2
rowB = 7
rowB = 9
rowB = 8
rowB = 4
rowB = 10
rowB = 5
rowB = 6
C
C = 10×1
    64
    12
    43
    64
    90
    13
    94
    74
    27
    58