how to arrange data into array
显示 更早的评论
Hi,
i have imported some matrix data into matlab and upon parsing the data i have it in 3 vectors (columns):
column 1 are the row indices (i.e.):
[1;2;3;4]
column 2 are the column indices (i.e.):
[10;11;13;15]
and column 3 are the values in the matrix associated with those indices (i.e.):
[1e-5;5e-5;10e-5;15e-5]
I'd like to arrange this into a single 2-D array of column 3 data in the row locations of column1, and column locations of column2
I could do this with a loop, but im hoping to find a more elegant / less time intensive solution. I have about a million datapoints.
Thanks alot!
3 个评论
James Tursa
2021-1-7
Do you know the desired size of the result up front? Or do you want to just use the max row and column indexes to determine the size of the result?
Tyler
2021-1-10
Tyler
2021-1-10
回答（1 个）
Without an intermediate sparse array:
R = [1;2;3;4];
C = [10;11;13;15];
V = [1e-5;5e-5;10e-5;15e-5];
%
S = max([R,C],[],1);
M = zeros(S); % or NAN
M(sub2ind(S,R,C)) = V % only the first 10 columns are shown below
类别
在 帮助中心 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
