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

1 visualizzazione (ultimi 30 giorni)
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.

Risposta accettata

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

Più risposte (1)

Cris LaPierre
Cris LaPierre il 23 Mar 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.

Categorie

Scopri di più su Shifting and Sorting Matrices in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by