Creatin a matrix within values from a biger matrix

3 vues (au cours des 30 derniers jours)
Camilo Jurado Paez
Camilo Jurado Paez le 5 Mar 2021
I have a matrix 500000x117. I need to populate a matrix 7x116 with values from the bigger matrix (1:7,2:117)
  3 commentaires
Camilo Jurado Paez
Camilo Jurado Paez le 5 Mar 2021
Modifié(e) : dpb le 5 Mar 2021
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
dpb le 5 Mar 2021
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.

Connectez-vous pour commenter.

Réponses (1)

Prudhvi Peddagoni
Prudhvi Peddagoni le 8 Mar 2021
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.

Community Treasure Hunt

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

Start Hunting!

Translated by