Retime function creates new rowtimes going back to 1899

Question

Poison Idea fan 2023-5-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1976274-retime-function-creates-new-rowtimes-going-back-to-1899

编辑： the cyclist 2023-5-31

采纳的回答： the cyclist

CO2_TT.mat

在 MATLAB Online 中打开

I have a timetable of data that I am trying to average to two minutes. When I use:

CO2_TT = retime(CO2_TT,'regular','mean','TimeStep',minutes(2));

It creates new row times going back to the year 1899. I've not seen this happen before and I use retime everyday. I have another timetable in the workspace that does not have this error. What would trigger this?

load CO2_TT.mat
CO2_TT = retime(CO2_TT,'regular','mean','TimeStep',minutes(2));

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

请先登录，再进行评论。

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

Answer 1

the cyclist 2023-5-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1976274-retime-function-creates-new-rowtimes-going-back-to-1899#answer_1247779

编辑：the cyclist 2023-5-31

在 MATLAB Online 中打开

CO2_TT.mat

You have a few dates from 1899 in your input data

load CO2_TT.mat
[minDateTime,indexToMinDatetime] = min(CO2_TT.DateTime)
minDateTime = datetime
   31-Dec-1899
indexToMinDatetime = 649
CO2_TT(CO2_TT.DateTime==min(CO2_TT.DateTime),:)
ans = 3×11 timetable
     DateTime      Time    Date    co2_ppb    hico2    intt    cht    pres    smplfl    speed    biasv    intensity
    ___________    ____    ____    _______    _____    ____    ___    ____    ______    _____    _____    _________

    31-Dec-1899    NaN     NaT       NaN       NaN     NaN     NaN    NaN      NaN       NaN      NaN        NaN   
    31-Dec-1899    NaN     NaT       NaN       NaN     NaN     NaN    NaN      NaN       NaN      NaN        NaN   
    31-Dec-1899    NaN     NaT       NaN       NaN     NaN     NaN    NaN      NaN       NaN      NaN        NaN   