Extract every 10th value from the excel file and save into new file

6 次查看（过去 30 天）
muhammad choudhry
muhammad choudhry 2021-3-23
评论： muhammad choudhry 2021-3-23
Hi,
Attached file have 2 columns and 7177 rows. I want every 10th rows from both column extracted and in the end save into different csv file for example: 10th 20th 30th 40th so on, can anyone help. I am not sure how to do it.

请先登录，再回答此问题。

采纳的回答

David Hill
David Hill 2021-3-23
a=readmatrix('Book1.csv');
b=a(10:10:end,:);
writematrix(b,'Book2.csv');

更多回答（1 个）

Cris LaPierre
Cris LaPierre 2021-3-23
Use indexing (Ch 5 MATLAB Onramp).
You'll probably need to load the file into MATLAB (use readtable or readmatrix), copy every 10th row to a new table, then write that table to a new file using writetable or writematrix.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by