Add variables from one timetable to another

Question

Eric Escoto 2021-11-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1594324-add-variables-from-one-timetable-to-another

评论： Peter Perkins 2021-11-26

Having a bit of trouble with this...

I've got two timetables. Let's call them TT1 and TT2.

One table (TT1) has 11 variables. Another table (TT2) has 1035 variables. They are the same length.

I would like to take variables 12:1035 and move them to the right of the last variable in TT1.

What is the best approach?

3 个评论
显示 1更早的评论隐藏 1更早的评论

Eric Escoto 2021-11-24

在 MATLAB Online 中打开

I can't see how the synchronize function would work for me.

If I try a code like such:

TT_test = timetable(tmin, TT2{:, [12:1035]});    % Pull columns of interest from TT2 and use tmin as the datetime vector.

Then I wind up with only one variable and not the 1024 variables I want.

Eric Escoto 2021-11-24

编辑：Eric Escoto 2021-11-24

What I'm trying to show is my indexing isnt correct and I'm not pulling each variable seperately. The result of this syntax is that there is only a single 'var1' with 1024 collumns instead of 1024 vars.

请先登录，再进行评论。

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

Answer 1

LeoAiE 2021-11-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1594324-add-variables-from-one-timetable-to-another#answer_838869

编辑：LeoAiE 2021-11-24

Hi,

I think you could easily achieve that using outerjoin function. First, extract your data from TT2 and give it a name such as NewTable = TT2(12:1035). Then, use outerjoin function to merge them

FinalTable = outerjoin(TT1,NewTable).

Please see the documentation of this function and how to use it examples https://www.mathworks.com/help/matlab/ref/outerjoin.html

And if you find this helpful, make sure to accept the solution!

Thanks

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

请先登录，再进行评论。

Answer 2

Peter Perkins 2021-11-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1594324-add-variables-from-one-timetable-to-another#answer_839514

在 MATLAB Online 中打开

Eric, I think all you need is

>> T1 = array2table(rand(5,3),"VariableNames",["A" "B" "C"]);
>> T2 = array2table(rand(5,3),"VariableNames",["X" "Y" "Z"]);
>> T12 = [T1 T2(:,["Y" "Z"])]
T12 =
5×5 table
A          B          C          Y          Z   
_______    _______    _______    _______    _______
0.48976    0.27603    0.49836    0.95929    0.84072
0.44559     0.6797    0.95974    0.54722    0.25428
0.64631     0.6551    0.34039    0.13862    0.81428
0.70936    0.16261    0.58527    0.14929    0.24352
0.75469      0.119    0.22381    0.25751    0.92926

You will need to make sure you don't have variable name conflicts.

The join functions are sort of a horz cat when you want to match up rows based on their values, not their positions. synchronize is sort of a horz cat whn you want to match up rows (of timetables) based on their times.