How to identify the hourly/daily missing data points?
4 views (last 30 days)
My dataset consists of long time series (about 20 years, excel sheet) with years, month, day, hour, mint, second. Each row represent one event. Some time there is no occurance on an hour or a day or even a month. Manually, its very hard to check with hour has no event or which day has no event.
May someone suggest me how can i handle this problem.
output shuld be like in 7 column year, month, day, hour mint,. second, events
observation = datenum(year,month,day,hour,minute,second);
Chunru on 7 Dec 2021
% Assume you have the observation as a datenum vector
% Here we generate an example datenum vector
observation = datenum(2021, 1, 1, [0:.5:3 5:1.2:8 8.1:0.1:9]', 0, 0); % YMDHMS
observation = sort(observation); % sort it if necessary
idx = find(diff(observation) > 1/24) % difference is greater than 1h