Merging data from multiple CSV files

4 次查看（过去 30 天）
Priyanka Maheshwari
回答： Sakz 2019-4-1
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

请先登录，再回答此问题。

回答（1 个）

Sakz
Sakz 2019-4-1
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by