Autocomplete the datetime series

Question

Poulomi Ganguli 2017-8-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354268-autocomplete-the-datetime-series

编辑： KL 2017-8-28

yrly_slr.mat

Hello, I have a time series as attached. The first, second, third and fourth column contains year, day, month, and hour, where the hour column runs from 0 - 23h. However, from 1st March, 23h onwards, no data are available. I want to create a datetime field from 1946, 2nd March onwards which ends at 31st December, with time frames 0-23 hrs. The value field can be filled with NaN in this case. Likewise, I have many sets of years and want to generalize the code in which the code can identify the enddate and endtime for which the data ends/missing and complete the datetime series till the end of the year, i.e.,

1946 12 31 23 NaN

Any help in this?

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

请先登录，再进行评论。

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

Answer 1

KL 2017-8-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354268-autocomplete-the-datetime-series#answer_279425

编辑：KL 2017-8-28

在 MATLAB Online 中打开

something like this? Try with a bigger dataset with occasional gaps.

ts_ref = (datetime('01/01/1946 00:00:00'):hours(1):datetime('01/02/1946 00:00:00'))'; %timestamp with no gaps
ts_act = ts_ref; 
ts_act(15:18)=[]; %create some gaps (your datetime vector)
val = rand(size(ts_act));
newVal = nan(size(ts_ref));
dummy_data = table(ts_act,val)
[~, ind_ts_ref, ind_ts_act]  = intersect(ts_ref,ts_act);
newVal(ind_ts_ref) = val;
dummy_data_new = table(ts_ref,newVal)