Fill missing observations for a sensor reading.

2023 7 13
1 个回答
回答已采纳
更新时间：2023 7 14
7 次查看（30 天）

0 个投票

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!

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

 采纳的回答

Walter Roberson
Walter Roberson 2023-7-13

0 个投票

I suggest you use table2timetable and then retime

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

Sanley Guerrier
Sanley Guerrier 2023-7-14
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);

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by