How to select specified data from a spreadsheet using MATLAB?

Hi, I'm currently working on a prediction model on MATLAB and got stuck on the data processing part.

I input a spreadsheet with multiple variables, and I am only interested in the integrated load of the CENTL area. I would like to create a number array of the Integrated load from CAPITL area, but I'm not sure how. Is there a function in MATLAB similar to the "filter" function in Excel?

I'm a beginner here, I'd really appreciate your help!

Thanks in advance!

Answer 1

[Image Analyst]

Read in the data with readtable(), or with xlsread() if you have an old version of MATLAB. Then use ismember() to select only those rows with CENTRL in the name column. It's something like

t = readtable(filename);
rowsToExtract = ismember(t.Name, 'CENTRL');
centrl = t(rowsToExtract, :); % sub-table.
integratedLoad = centrl{:, 5};

or something like that. I'd maybe have done it for you but you didn't attach your workbook with the paperclip icon. But no problem, you'll probably learn more by doing it yourself anyway. Good luck.

[Janice Sanderson]

Great this really helped! This is much more easier than what I was doing! The ismember() is a great function! Thank you so much!!