merge two csv files with a key

6 次查看（过去 30 天）

alpedhuez 2020-6-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/546089-merge-two-csv-files-with-a-key

评论： alpedhuez 2020-6-11

I have two csv files. One file has date and temperature. Anothe file has date and rainfall. I want to combine two files using date as a key. Please advise.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

Anish Walia 2020-6-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/546089-merge-two-csv-files-with-a-key#answer_449495

在 MATLAB Online 中打开

Assuming files are names file1 and file 2

table1 = readtable('file1.csv');
table2 = readtable('file2.csv');
%variable name of the column to use as key to join should be same in both tables (data in your case) 
mergedTable = join(table1,table2);
% mergedTable contains the combined table
writetable(mergedTable,'MergedTables.csv');