Hello Qurat,
I am assuming that all the CSV files have the same number of columns and share the same column names.
To merge these CSV files into a single file and add an extra column to represent the data category, follow these steps:
- Read the contents of each CSV file into a cell array, and extract the file name to use as the category label.
files = dir('*.csv');
allTables = cell(length(files),1);
for i = 1:length(files)
tbl = readtable(files(i).name);
[~, fileName, ~] = fileparts(files(i).name);
tbl.Category = repmat({fileName}, height(tbl), 1);
allTables{i} = tbl;
end
- Merge the data from all the CSV files into one comprehensive file.
mergedTable = vertcat(allTables{:});
writetable(mergedTable, 'merged_data.csv');
For better understanding of the solution, refer to the following documentations:
