Fill missing observations for a sensor reading.

Question

Sanley Guerrier 2023-7-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1995803-fill-missing-observations-for-a-sensor-reading

评论： Sanley Guerrier 2023-7-14

QHR.JPG

Hello, the data was supposed to record sensor reading for calendar year 2005. The frequency is quarter hour "QHR" (0 to 3) every 15 minute. How can I fill the missing values in the frequencies for the length of the data is equal to the calendar year 2005. I attached a picture of the data bellow. Appriciate your help!

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2023-7-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1995803-fill-missing-observations-for-a-sensor-reading#answer_1272883

I suggest you use table2timetable and then retime

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sanley Guerrier 2023-7-14

QHR1.JPG

I tried to convert to this format below and used table2timetable, the part "hh:mm:ss" is constant everywhere. how do I fix this issue to move on to the next step (retime)? Thank you!

>> dfy = convertvars(dfy, @isdatetime, @(t) datetime(t, 'Format', 'yyyy-MM-dd hh:mm:ss'));

>> T = table2timetable(dfy);

请先登录，再进行评论。