How can I fill a matrix column with dta coming from another matrix according to index

Question

olivier espeli 2015-1-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/172975-how-can-i-fill-a-matrix-column-with-dta-coming-from-another-matrix-according-to-index

评论： olivier espeli 2015-1-29

I need to fill a large matrix with data coming from a smaller matrix. Both matrices contains a first column with an index and a second column with the results of an experiment. I need to combine the results according to their index. For example I have a matrix A:

And a matrix B

I would like to combine them to obtain the matrix C with 3 columns (column 1 for index, column 2 results from A, column 3 results from B)

1 10
1 10
1 NaN
1 10
1 NaN
1 NaN
1 10
1 NaN
1 NaN

I have to do that on matrices with millions of rows, therefore methods limiting calculation time would be welcome. Thank you very much for any help.

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

请先登录，再进行评论。

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

Answer 1

Matz Johansson Bergström 2015-1-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/172975-how-can-i-fill-a-matrix-column-with-dta-coming-from-another-matrix-according-to-index#answer_166288

编辑：Matz Johansson Bergström 2015-1-28

在 MATLAB Online 中打开

Without knowing the size of the matrix, it might be a good idea to use a sparse matrix, instead of filling the non existant elements with NaN. Now, this is not exactly what you did, but it will give you a good hint of what you can accomplish with a sparse structure.

I did this fairly quick, because it is late where I live, but it should work fine

%create the example vectors
A = [(1:9)',ones(9,1)];
B = [1,2,4,7]';
B = [B, 10+0*B];
%putting the data into a sparse matrix 
M = sparse([]);
M(A(:,1), 1) = A(:,2);
M(B(:,1), 2) = B(:,2);

Note that I use the first column in A as an index in M and the same goes for B. When I add the elements I add them in the first column of M, then the second column, separating where the values come frome.

I hope this helps.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

olivier espeli 2015-1-29

thank you very much for your help

请先登录，再进行评论。

Answer 2

Shoaibur Rahman 2015-1-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/172975-how-can-i-fill-a-matrix-column-with-dta-coming-from-another-matrix-according-to-index#answer_166290

在 MATLAB Online 中打开

A = [(1:9)' ones(9,1)];
B = [1 10; 2 10; 4 10; 7 10];
C = NaN(size(A,1),1);
C(B(:,1)) = B(:,2);
C = [A C]

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

olivier espeli 2015-1-29

Thank you very much for you help

请先登录，再进行评论。

Answer 3

Image Analyst 2015-1-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/172975-how-can-i-fill-a-matrix-column-with-dta-coming-from-another-matrix-according-to-index#answer_166293

在 MATLAB Online 中打开

Try this:

A = [...
1 1
2 1
3 1
4 5
5 1
6 1
7 9
8 1
9 1]
B = [...
1 10
2 20
4 70
7 90]
% Find  out what the max index could possibly be.
maxRow = max([A(:,1); B(:,1)])
C = zeros(maxRow, 3); % Preallocate C.
% Assign all possible indices to column 1 of C.
C(:,1)=1:maxRow;
% Assign column 2 of A to column 2 of C.
C(A(:,1),2) = A(:, 2);
% Assign column 2 of B to column 3 of C.
C(B(:,1), 3) = B(:, 2)

In the command window:

It's vectorized so it should be pretty fast. Anyway, a million rows is not that many. Here it is with a million rows and it took 0.03 seconds:

numberOfRows = 1000000;
A = int32(randi(99, [numberOfRows, 2]));
B = int32(randi(99, [numberOfRows, 2]));
tic;
% Find  out what the max index could possibly be.
maxRow = max([A(:,1); B(:,1)]);
C = zeros(maxRow, 3); % Preallocate C.
% Assign all possible indices to column 1 of C.
C(:,1)=1:maxRow;
% Assign column 2 of A to column 2 of C.
C(A(:,1),2) = A(:, 2);
% Assign column 2 of B to column 3 of C.
C(B(:,1), 3) = B(:, 2);
toc;