How can I 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.

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.

[KSSV]

YOu have the 1000*10 data in text file?

[Hassanean]

I have the 1000*10 data in the excel file.

[Hassanean]

thanks for your answer, I now this step, but I need to create a new small table from original table within matlab environment work where a new table meet this condition ( extract an one row from each ten rows in orginal table and continue this procedure till last row in orginal table).

[KSSV]

Which row you want out of 10 rows?

[Hassanean]

Tenth row of each ten rows and continue until last row in table.

Answer 1

[Image Analyst]

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, :);

[Hassanean]

Thanks for your efforts.

Answer 2

[KSSV]

Use xlsread to read the data into matlab.

[num,txt,raw] = xlsread('your excel.xlsx');

num will be your 1000*10 data. You can pick any column and row from that.