Error using time date table

8 次查看（过去 30 天）
Sam17
Sam17 2019-2-26
回答： Peter Perkins 2019-3-11
I have a table with time date hour values as:
g.PNG
I am trying to find the difference between the consecutive time and put in the same table as a new column. I want to keep column name as 'time diff'. I am trying this. Got this error.
time= table2array(Data(:,1));
diff=diff(time);
Data=outerjoin(Data,diff,'MergeKeys',true);
error:
Function 'subsindex' is not defined for values of class 'datetime'.
Any suggestions?

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

回答（1 个）

Peter Perkins
Peter Perkins 2019-3-11
>> tt = timetable(rand(5,1),'RowTimes',datetime('now')+sort(hours(rand(5,1))))
tt =
5×1 timetable
Time Var1
____________________ _______
11-Mar-2019 11:11:25 0.81472
11-Mar-2019 11:22:16 0.90579
11-Mar-2019 11:38:23 0.12699
11-Mar-2019 12:03:01 0.91338
11-Mar-2019 12:03:28 0.63236
>> tt.TimeDiff = [NaN; diff(tt.Time)]
tt =
5×2 timetable
Time Var1 TimeDiff
____________________ _______ ________
11-Mar-2019 11:11:25 0.81472 NaN
11-Mar-2019 11:22:16 0.90579 00:10:51
11-Mar-2019 11:38:23 0.12699 00:16:06
11-Mar-2019 12:03:01 0.91338 00:24:38
11-Mar-2019 12:03:28 0.63236 00:00:26

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by