How to find the missing points in time series

Hi, I have a large data set with datapoints (supposed to be) on every second. Unfortunately there are no data recorded on some points. Unfortunately these points are not marked and I have to manually go through the dataset to find these points and it is taking a long time. The time points are marked as 143219, 143220, 143221, 143222 and so on. Is there any way to quickly find out these data points from the data set with a code. Regards

6 Comments

Please specify what is input data and what must be output
Is there exactly one time stamp for each second? This would be very easy I think.
Need many more details about the formatting/how the data is stored in a variable or array so we know how to use it.
Thanks Mikhail and Andrew. This is a dataset of around 10 hours data where the data should have been recorded every second. But looking at the timestamp I have realised that it has skipped a second once in every 19-21 sec. Unfortunately it hasn't happened always in a set rhythm, making it slightly more difficult and laborious to identify. I want to identify these points which have been skipped and put NaN against them. I am attaching an example timestamp in an excel sheet. Regards,
Have you tried looking at the link I posted? Because it pretty much does what you are asking.
Dear Jose-Luis, Thanks for the link, I am trying to work it out but still haven't managed very well. I have to admit that I am a novice to matlab. Regards
No worries. This is the place to come with questions if you don't understand something.
The documentation is probably the best place to start, though.

Sign in to comment.

Categories

Asked:

on 9 Oct 2014

Commented:

on 9 Oct 2014

Community Treasure Hunt

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

Start Hunting!