Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
missing data check

Subject: missing data check

From: Kuo-Hsien

Date: 31 Mar, 2009 00:10:18

Message: 1 of 2

Hi all,

Are there any possibilities to process the missing data check based on the time series?!

Here is the data look like as below. In this case, some data points are missing from time 600 to 2300. How to list the date and time at the missing data point? Thanks.

2007 1 30 4.0033 237.58
2007 1 100 4.0282 232.89
2007 1 130 5.4415 257.04999
2007 1 200 5.0331 251.24001
2007 1 400 4.4454 244.00999
2007 1 430 4.2275 233.69
2007 1 500 3.2998 204.71001
2007 1 530 2.6559 208.42
2007 1 2330 3.7164 238.63
2007 1 2400 4.0033 237.61
2007 2 30 4.0033 237.58
2007 2 100 4.0282 232.89
:
:

Subject: missing data check

From: Image Analyst

Date: 31 Mar, 2009 01:34:01

Message: 2 of 2

"Kuo-Hsien" <mchangks@hotmail.com> wrote in message <gqrn1a$boa$1@fred.mathworks.com>...
> Hi all,
>
> Are there any possibilities to process the missing data check based on the time series?!
>
> Here is the data look like as below. In this case, some data points are missing from time 600 to 2300. How to list the date and time at the missing data point? Thanks.
>
> 2007 1 30 4.0033 237.58
> 2007 1 100 4.0282 232.89
> 2007 1 130 5.4415 257.04999
> 2007 1 200 5.0331 251.24001
> 2007 1 400 4.4454 244.00999
> 2007 1 430 4.2275 233.69
> 2007 1 500 3.2998 204.71001
> 2007 1 530 2.6559 208.42
> 2007 1 2330 3.7164 238.63
> 2007 1 2400 4.0033 237.61
> 2007 2 30 4.0033 237.58
> 2007 2 100 4.0282 232.89
> :
> :
--------------------------------------------------------------------------------------------------------------
Kuo-Hsien:
Scan the data into an array. Then use diff() on the third column looking for any differences that are greater than largest gap you are willing to accept.
-ImageAnalyst

Tags for this Thread

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us