MATLAB Answers

0

read multiple csv files and extract first 10 rows only

Asked by MatLab Code N on 13 May 2019
Latest activity Commented on by dpb
on 13 May 2019
Accepted Answer by dpb
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!

  0 Comments

Sign in to comment.

Tags

1 Answer

Answer by dpb
on 13 May 2019
 Accepted Answer

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 Comments

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!
You said were .csv files...those are Excel files--use an appropriate way to read Excell file.

Sign in to comment.