How to combine hundreds of CSV files in Matlab?
57 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi all,
I have LOTS of data in CSV files and I'd like to create one massive master CSV file. How can I combine all of the CSV files into one? Each CSV file has a header with time, type of data, etc. They all have the same number of columns but differet numbers of rows.
0 commentaires
Réponse acceptée
Voss
le 21 Mar 2022
Here's an example of how to do it (with 2 files):
input_path = '.'; % location of .csv files
output_file = 'result.csv'; % name of file containing combined data
% read each .csv file into a table stored in a cell array of tables
% called 'all_data':
file_info = dir(fullfile(input_path,'*.csv'));
full_file_names = fullfile(input_path,{file_info.name});
n_files = numel(file_info);
all_data = cell(1,n_files);
for ii = 1:n_files
all_data{ii} = readtable(full_file_names{ii});
end
% check the tables:
all_data{:}
% concatenate all the tables into one big table, and write it to
% output_file:
writetable(cat(1,all_data{:}),output_file);
% check that the resulting output file exists:
dir('*.csv')
% check the contents of the resulting output file:
readtable(output_file)
0 commentaires
Plus de réponses (0)
Voir également
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!