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

2 次查看（过去 30 天）
uzzi
uzzi 2023-1-18
评论： 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?

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

采纳的回答

BA
BA 2023-1-19
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
This is going to create a fourth variable in the table called sum. That is the var1+var2

更多回答（0 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by