count the # of rows of CSV files in a folder

13 views (last 30 days)
I have a bunch of CSV files in a folder. I understand that I can use
to count a number of rows of each file. Then how can one write a loop to read all csv files in a folder to calculate the sum of rows of CSV fiels in a folder?

Accepted Answer

Voss
Voss on 25 Jun 2022
your_folder = 'C:\path\to\folder';
files = dir(fullfile(your_folder,'*.csv'));
fullFileNames = fullfile(your_folder,{files.name});
numRowsTotal = 0;
for ii = 1:numel(files)
datatable = readtable(fullFileNames{ii}, 'ReadVariableNames', false); %or true if there is a header
numRowsTotal = numRowsTotal + height(datatable);
end

More Answers (0)

Categories

Find more on Environment and Settings in Help Center and File Exchange

Tags

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by