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

Question

muhammad choudhry 2021-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/781022-extract-every-10th-value-from-the-excel-file-and-save-into-new-file

评论： muhammad choudhry 2021-3-23

Book1.csv

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

David Hill 2021-3-23

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/781022-extract-every-10th-value-from-the-excel-file-and-save-into-new-file#answer_655857

在 MATLAB Online 中打开

a=readmatrix('Book1.csv');
b=a(10:10:end,:);
writematrix(b,'Book2.csv');

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

muhammad choudhry 2021-3-23

classssssssssssssssssss!!!!!!!

请先登录，再进行评论。

Answer 2

Cris LaPierre 2021-3-23

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/781022-extract-every-10th-value-from-the-excel-file-and-save-into-new-file#answer_655852

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.