how to arrange data into array

2 次查看（过去 30 天）
Tyler
Tyler 2021-1-7
编辑： Stephen23 2021-1-10
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 个评论
显示 1更早的评论
Tyler
Tyler 2021-1-10
i would use the max row and column indices
Tyler
Tyler 2021-1-10
turns out i can use the sparse() command, followed by the full() command to achieve my desired outcome.

请先登录，再进行评论。

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

回答（1 个）

Stephen23
Stephen23 2021-1-10
编辑：Stephen23 2021-1-10
Ran in:
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
M = 4×15
0 0 0 0 0 0 0 0 0 0.0100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.1000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.1500
●

类别

在 Help Center 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

产品


版本

R2016b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by