Merging data from multiple CSV files

I have multiple CSV files with a common date column and one other uncommon column. However, all files do not start with the same date. I want to merge these files such that the combined file has all dates with correct data in different columns from the multiple files in front of each date

Answer 1

[Rohit Kumar]

You can follow the following steps:

Case-1) if uncommon columns are in the same order then you can read .csv files one by one using "xlsread" & concatenate everything together and save in a different xls file using "xlswrite".

This could be quick to do.

filenames={'F1','F2','F3'};
[~,~,RAW1]=xlsread(filenames{1});
for i=2:numel(filenames)
    [num,~,~]=xlsread(filenames{i});
    RAW1=[RAW1;num2cell(num)];
end
% Write COncatenated file to new xls file
xlswrite('ConcatenatedFile',RAW1)

Case-2) If the uncommon columns are not in the same order, then you will have to read each column individually & conacatenate them with the correct column in the other file & then write to a new xls file.

Use "xlsread" to read csv files & xlswrite to write it back to xls file after concatenating.