How to input corresponding data from separate matrices
显示 更早的评论
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.
采纳的回答
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)
更多回答（1 个）
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
C
类别
在 帮助中心 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息
Translated by 
