Creatin a matrix within values from a biger matrix

Question

Camilo Jurado Paez 2021-3-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/764071-creatin-a-matrix-within-values-from-a-biger-matrix

回答： Prudhvi Peddagoni 2021-3-8

I have a matrix 500000x117. I need to populate a matrix 7x116 with values from the bigger matrix (1:7,2:117)

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

Camilo Jurado Paez 2021-3-5

编辑：dpb 2021-3-5

在 MATLAB Online 中打开

I'm having problems when I read a spreadsheet from excel. It's a cell array and I dont know wy Im having an error whenever I try to convert it to a matrix

opts = spreadsheetImportOptions("NumVariables", 117);
m_test = readmatrix("C:\Users\Camilo\Desktop\data_raw_sample.xlsx",...
                                                         opts, "UseExcel", false);
m1 = zeros(length(m_test(:,2:117)));
mtom1 = m_test(1:7,2:117);
mf = cell2mat(mtom1);

Thank you so much

dpb 2021-3-5

在 MATLAB Online 中打开

Well, we'd have to see the form of the data in the spreadsheet and the error message but readmatrix doesn't return a cell arry; it returns a double array already -- any data in the spreadsheet that can't be interpreted as a valid floating point number will be returned as NaN.

m=readmatrix("C:\Users\Camilo\Desktop\data_raw_sample.xlsx");
m1=m(1:7,2:117);

will return the content of whatever is in the spreadsheet that is numberic in that region of the overall array; as noted, if some of the content of the file is non-numeric, those will be returned as NaN--but still in a double array.

请先登录，再进行评论。

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