merge two csv files with a key

alpedhuez

2020 6 10

1 个回答

5 次查看（30 天）

显示更早的评论

0 个投票

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

在 MATLAB Online 中打开

0 个投票

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');