read multiple csv files and extract first 10 rows only

17 visualizaciones (últimos 30 días)
MatLab Code N
MatLab Code N el 13 de Mayo de 2019
Comentada: dpb el 13 de Mayo de 2019
I have multiple (more than 100) csv files. I want a loop to read the csv files and extract only first ten rows from each csv files.
Thanks!

Respuesta aceptada

dpb
dpb el 13 de Mayo de 2019
Just read each file in turn and save the first N lines...
NLines=10; % how many wanted to save...make variable so can change at will...
d=dir('Appropriate*WildCardPattern*.csv');
for i=1:numel(d)
data=csvread(d(i).name);
data=data(1:NLines,:);
...
% do whatever with this file's data here...
end
  2 comentarios
MatLab Code N
MatLab Code N el 13 de Mayo de 2019
Your code gave me an error. So, i've attached two of my sample files. I hope this might help you to debug the problem.
Thank you so much!
dpb
dpb el 13 de Mayo de 2019
You said were .csv files...those are Excel files--use an appropriate way to read Excell file.

Iniciar sesión para comentar.

Más respuestas (0)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by