Create a table with timedate and values

Question

Tiago Dias 2018-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/392881-create-a-table-with-timedate-and-values

评论： Tiago Dias 2018-4-6

采纳的回答： Peter Perkins

Hello,

I got 2 mat files:

old.mat that is 432x2 with time date 01/01/2016 05:00:00 with an interval of 1 minute in each row and a variable X in the 2nd column;
new that is a 423x3, with time in the 1st column and values for variables Y1 and Y2, in the 2nd and 3rd column

Objective newtable(:,1) = old(:,1); newtable(:,2) = old(:,2); newtable(:,3:4) = new (:,2:3)

I tried newtable = [old(:,1:2) new(:,2:3)] but i got an error:

All inputs must be datetimes or date/time character vectors or date/time strings.

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

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2018-4-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/392881-create-a-table-with-timedate-and-values#answer_313695

It's pretty much impossible to say for sure what you're doing wrong without knowing what's in those mat files, but based on the error you show, it seems like you have a datetime variable and are trying to horzcat it with either a table or a numeric matrix. If variables is a numeric matrix, use array2timetable on your matrix with t_ref as the row times. If it's a table, use table2timetable.