how can I make a matrix from each row of an excel sheet data and save each matrix in to a folder

Question

sruthy shankar 2018-1-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/379954-how-can-i-make-a-matrix-from-each-row-of-an-excel-sheet-data-and-save-each-matrix-in-to-a-folder

评论： sruthy shankar 2018-2-1

Iam working with a spreadsheet data that is being imported to matlab using xlsread function. Is there any way to access each row from that excelsheet and make each row a seperate matrix and store them in a seperate structure or an array to use it later? And after storing each matrix in to that structure ,how can I access some of the matrices later

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

请先登录，再进行评论。

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

Answer 1

Jan 2018-1-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/379954-how-can-i-make-a-matrix-from-each-row-of-an-excel-sheet-data-and-save-each-matrix-in-to-a-folder#answer_302684

在 MATLAB Online 中打开

data = xlsread(FileName);

Now data contains the numerical values of all columns. Now you want to save them as matrices in different folders. It is not clear, what this exactly means, but perhaps this helps:

for k = 1:size(data, 2)
  folder = fullfile('D:\Data\', sprintf('Folder%03d', k));
  Column = data(:, k);
  save(fullfile(folder, 'column.mat'), 'Column');
end

Now each folder contains the file Column.mat, in which one column of the Excel file is saved. This does not sound efficient, because it duplicates the data. But maybe there is a good reason to do so.

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

Jan 2018-2-1

@sruthy: Okay. How can we help you? Do you know how to pad the vectors to be square matrices? In which format do you want to save these matrices? Which rows do you want to store in which kind of array?

sruthy shankar 2018-2-1

sir,I have used the following code to make each row a square matrix. data_M = xlsread('Book1' ); M_matrix=[]; for k = 1:size(data_M, 1 ) row_M = data_M(k, : ); padding = zeros(1,6); vec_M=[row_M,padding]; rowMatrix_M = vec2mat(vec_M,6); M_matrix=[M_matrix rowMatrix_M]; end here M_matrix is that array,but I have to split that array in to two,each containing equal number of matrices so that i can give it for training as well as testing, how can it be done ? or instead of this array is there exist some other method to store that matrices and later access them

请先登录，再进行评论。