Extract data from Timetable on specified whole integer minutes . i.e. extract data every 6 minutes. Trying to use retime function.

4 次查看（过去 30 天）
PADMAKAR
PADMAKAR 2023-6-19
评论： Peter Perkins 2023-7-17
dt = minutes(6);
TT2 = retime(TT1,'regular','linear','TimeStep',dt)
%TT1 is a time table which also contains NaT and NaN values.
  2 个评论
Steven Lord
Steven Lord 2023-6-19
That looks like a line of code that will do what you described in the question. From the fact that you're asking about it on MATLAB Answers I presume it didn't behave as you expected. What did you expect it to do and what did it actually do?
PADMAKAR
PADMAKAR 2023-6-19
移动：Stephen23 2023-6-19
I keep getting this error. Dont understand why. The row times are shown in attached jpg file.
Error using timetable/retime
Input timetables must contain unique row times when synchronizing using 'linear'.
Error in RTKFiles_May (line 83)
TT2 = retime(tempFile,'regular','linear','TimeStep',dt);

请先登录，再进行评论。

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

回答（1 个）

dpb
dpb 2023-6-19
移动：dpb 2023-6-19
Your time variable is only dates and, as the error message says, to use retime this way the time vector has to be unique for each observation.
You either
  1. Didn't record the actual time of the observation, or
  2. Didn't read the time information when creating the table if was recorded, or
  3. The appropriate time would be that associated with the start of the record plus the duration data in the second colum.
We've no way to know which of those choices is the correct one, but on the assumption it's the third, then first read the data into a regular table and add the duration to the date to get the actual start time (if the data go over one day, you'll have to adjust for that, howeve).
Without further amplification, won't try specific code; if you need further help attach the actual data with the paperclip icon instead of posting images; not anything can do with them.
  1 个评论
Peter Perkins
Peter Perkins 2023-7-17
Right, as dpb hints, you have daily data and are trying to retime it to 6min steps. You'd need to interpolate to do that, and you can, but if your data have multiple values on each date, interpolation is not allowed. I think dpb's 3'rd guess and suggestion is correct.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by