read multiple csv files and extract first 10 rows only
19 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
dpb
le 13 Mai 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 commentaires
dpb
le 13 Mai 2019
You said were .csv files...those are Excel files--use an appropriate way to read Excell file.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!