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.

13 次查看(过去 30 天)
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.
  5 个评论

请先登录,再进行评论。

采纳的回答

Image Analyst
Image Analyst 2016-12-6
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, :);

更多回答(1 个)

KSSV
KSSV 2016-12-5
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.

标签

Community Treasure Hunt

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

Start Hunting!

Translated by