combine 2 timetables with different variables into 1 timetable?

7 次查看（过去 30 天）

显示更早的评论

Angelavtc 2022-5-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1723145-combine-2-timetables-with-different-variables-into-1-timetable

评论： dpb 2022-5-21

采纳的回答： dpb

I have two timetables with different "time format"

I want to merge timetable 1 with timetable 2 to get timetable 3 as the following image:

Using join I get the following error: "The key variable for B must contain all values in the key variable for A."

which I guess it is because the timetable have different time format, but event if I change this, the error is still there.

Any Idea how to solve this?

Thank you in advance!

4 个评论
显示 2更早的评论隐藏 2更早的评论

Dyuman Joshi 2022-5-20

Can you attach your data here?

Angelavtc 2022-5-20

在 MATLAB Online 中打开

@Dyuman Joshi For example this

d = string({'2017-01-01 11:00','2017-01-01 12:00'});
Date= datetime(d,'InputFormat','yyyy-MM-dd HH:mm')';
Price= [40 35]';
T1= table(Date, Price)
TT1= table2timetable(T1)
d1 = string({'2017-01-01','2017-01-02'});
Date= datetime(d1,'InputFormat','yyyy-MM-dd')';
Volume= [400 350]';
T2= table(Date, Volume)
TT2= table2timetable(T2)
TT1.Date = datetime(TT1.Date,'Format','yyyy-MM-dd');
TT3 = outerjoin(TT1,TT2,'MergeKeys',true);

So the result is not at all what I would like to have. I would like to end up with a timetable like this:

d2 = string({'2017-01-01 11:00','2017-01-01 12:00'});
Date= datetime(d,'InputFormat','yyyy-MM-dd HH:mm')';
Price= [40 35]';
Volume= [400 400]';
T3= table(Date, Price, Volume)
TT3= table2timetable(T3)

Thank you!

请先登录，再进行评论。

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

采纳的回答

dpb 2022-5-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1723145-combine-2-timetables-with-different-variables-into-1-timetable#answer_968525

在 MATLAB Online 中打开

ttC=synchronize(ttA,ttB);                   % catenate the two horizontally at matching times
ttC=ttC(isfinite(ttC.Price),:);             % remove those w/ no Price data
ttC=retime(ttC,'hourly',"previous");        % fill in missing volume data with first value of period