read multiple csv files and extract first 10 rows only
16 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
dpb
il 13 Mag 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 Commenti
dpb
il 13 Mag 2019
You said were .csv files...those are Excel files--use an appropriate way to read Excell file.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets 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!