Creating a new table with the same time value from 2 different tables

2 次查看（过去 30 天）

uzzi ，2023-1-18

0
链接

Direct link to this question

https://ww2.mathworks.cn/matlabcentral/answers/1896630-creating-a-new-table-with-the-same-time-value-from-2-different-tables

评论： uzzi ，2023-1-19

Hello,

I have table t1 and t2 (attached) with the different sizes which has two columns (time,number). I want to create a new table if the time of table t1 and t2 are the same, and for the number, I want to have t2(number)+t1(number) with the coincided time.

Can someone help me?

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

请先登录，再进行评论。

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

采纳的回答

BA 2023-1-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1896630-creating-a-new-table-with-the-same-time-value-from-2-different-tables#answer_1151560

t1 = readtable('t1.xlsx'); %read table t1
t2 = readtable('t2.xlsx'); %read table t2
new_table = innerjoin(t1, t2, 'Keys', 'Var1'); %conduct an innerjoin with key var1
new_table.sum = new_table.Var2_t1 + new_table.Var2_t2; %add the two variables together