Hi!
Yes it is possible to merge the CSV files into one. You can try the following steps:
- Create a cell array or a table to store the merged data from all the CSV sheets.
- Use the dir function to obtain a list of all the CSV files in the directory.
- Iterate over the list of CSV files.
- Use the readmatrix or readtable function to read each CSV file into a temporary variable.
- Append the data from the temporary variable to the cell array or table created in step 1.
- After iterating over all the CSV files, write the merged data to a new CSV file using the writetable function.
directory = 'path/to/csv/files';
% Get list of CSV files
files = dir(fullfile(directory, '*.csv'));
% Create a cell array to store the merged data
mergedData = {};
for i = 1:length(files)
filePath = fullfile(directory, files(i).name); % reading the csv file
data = readmatrix(filePath);
% Append the data to the merged data array or table
mergedData = [mergedData; data];
end
% Write the merged data to new CSV file
outputFile = 'finaltable.csv';
writematrix(mergedData, outputFile, 'Delimiter', ',');
I hope this helps!
