MATLAB: How to extract multiple rows from large data table in matlab that meet a certain condition to then be saved as new data table ? Note: the condition is extract an one row from each ten rows till end.

Question

I have table of data is consist of 1000 row and 10 columns. I need to extract a part of these data to be move to a new table. As well as, I need to extract the full data of one row from each 10 rows where extracting steps continues till last row in original table, in order to construct a new table.

Answer 1

Try readtable(). Untested code:

fullTable = readtable(xlsFileName);  % Make "table" variable.
% Construct vector of rows to extract
rowsToExtract = 1:10:size(fullTable, 1);
% Extract only those rows.
briefTable = fullTable(rowsToExtract, :);