How can I merge tables of csv files into one file?

4 views (last 30 days)
DEYIRE UMAR on 25 Sep 2018
Commented: Peter Perkins on 1 Oct 2018
I obtained data which are stored in 2000 csv files and I need to make(append) them one file. They have same headers for their columns. I attached two of the files. So, data from "log_table_1.csv" is to become the continuation of "log_table_0.csv" and so on until the 2000th one.

Answers (1)

Jake Gonzalez
Jake Gonzalez on 25 Sep 2018
Try something like this;
d = table();
fileNames = dir('*.csv');
for ii = 1:numel(fileNames)
d0 = readtable(fileNames(ii).name);
d = [d; d0];
See if that works.
Peter Perkins
Peter Perkins on 1 Oct 2018
Another (faster) possibility is to read each table into a cell of a 2000x1 cell array
cellContainingTables{i} = readtable(...);
and then do this:
t = vertcat(cellContainingTables{:});

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!