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

2 visualizaciones (últimos 30 días)
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.

Respuesta aceptada

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

Más respuestas (1)

Cris LaPierre
Cris LaPierre el 23 de Mzo. de 2021
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.

Categorías

Más información sobre Shifting and Sorting Matrices en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by