Using rows of different files to create a matrix

Question

C Smyth 2018-2-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/385204-using-rows-of-different-files-to-create-a-matrix

回答： Jos (10584) 2018-2-27

I have 6 separate files all within the workspace each with 3 columns of data with an unknown number of rows but equal for all files. I am trying to use the first row of each file as a line in a new matrix i.e end up with a 6*3 matrix. I want to repeat this for every row until it ends.

So the matrix looks like: row 1 of file 1 row 1 of file 2 row 1 of file 3 row 1 of file 4 row 1 of file 5 row 1 of file 6

Does this make sense? Does anyone know how to do this?

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

Bob Thompson 2018-2-27

What type of files?

请先登录，再进行评论。

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

Answer 1

Jos (10584) 2018-2-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/385204-using-rows-of-different-files-to-create-a-matrix#answer_307454

在 MATLAB Online 中打开

% Load in the data and store in cells
for k=1:6,
   filename = ...
   C{k} = MyLoadFile(filename) ; % C{k} is a N-by-3 matrix
end
D = cat(2,C{:}) % D is a N-by-18 matrix, holding all values
% D(k,:) is the data for all first rows of the 6 files
E = arrayfun(@(k) reshape(D(k,:),3,6).', 1:size(D,1),'un',0)
% E{k} holds the requested 6-by-3 matrix for the k-th row