Creatin a matrix within values from a biger matrix

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

[dpb]

So, what have you tried and where did you have problems?

[Camilo Jurado Paez]

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]

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.

Answer 1

[Prudhvi Peddagoni]

Hi,

you can use import tool to import data from the spreadsheets. You can check if there are any NaN values too.

Hope this helps.