Calculate duration from labeled timestamped data.

Question

Khandakar Rashid 2020-6-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/546870-calculate-duration-from-labeled-timestamped-data

评论： Khandakar Rashid 2020-6-20

采纳的回答： Akira Agata

data.mat

Hi,

I have a timetable with timestamps and labels of different activities. The stacked plot looks like this.

I would like to calculate the durations of each cycle of the activity. For example, the top plot has 11 "Dump" sequences, so the outcome should be,

Dump = [t1, t2, ........t11], t = duration of each dump instance.

Is there any smarter way to accomplish this without using FOR loop and tracking changes in each row?

I am also attaching the .mat file of the timetable.

Thank you!

2 个评论
显示无隐藏无

Akira Agata 2020-6-11

If possible, could you upload your timetable data so that people here can try their idea?

Khandakar Rashid 2020-6-11

Thank you Akira. I have uploaded the timetable data in the original question as "data.mat".

请先登录，再进行评论。

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

Answer 1

Akira Agata 2020-6-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/546870-calculate-duration-from-labeled-timestamped-data#answer_452841

在 MATLAB Online 中打开

Thank you for providing your data.

I believe the following is an possible solution. I hope this will be somehow helpful for you!

load('data.mat');
% Find start/end time for each 'Dump' period
idx = data.Truck1 == 'Dump';
locStart = find(diff(idx) == 1)+1;
locEnd = find(diff(idx) == -1);
timeStart = data.Time(locStart);
timeEnd = data.Time(locEnd);
% Calculate duration for each 'Dump' period
timeDuration = timeEnd - timeStart;
% Arrange to table
tblTruck1 = table(timeStart,timeEnd,timeDuration);