Matlab Data-series conversion

Hello,

I Have been trying for the past couple of days to convert a time-series data-set but, unfortunately, with no results.

I have attached an extract from the excel file. The first row is date and time (together) and their respective temperatures taken every 10 minutes. The problems with this are three: the first it that the dataset is not contiguous (ie sometime there are holes where the data were not recorded for a certain amount of time) the second is that I would need a contiguous series where if a day was not recorded the time would still be 'flowing' and the temperature would be indicated as missing. The third is that I would need an hourly series instead of a one every 10minutes.

Would any of you have any ideas?

Thanks John

if true
01/11/2009 00:03  11.35
01/11/2009 00:13  11.25
01/11/2009 00:23  11.25
01/11/2009 00:33  11.35
01/11/2009 00:43  11.35
01/11/2009 00:53  11.35
01/11/2009 01:03  11.35
01/11/2009 01:13  11.35
01/11/2009 02:03  11.44
01/11/2009 02:13  11.44
01/11/2009 02:23  11.44
01/11/2009 02:33  11.44
01/11/2009 02:43  11.44
01/11/2009 02:53  11.44

end

Answer 1

[Image Analyst]

Have you looked at using interp1()?

[J]

hi, yes I have but I think that the problem is with the 'missing ' non contiguous data. Thanks

[Image Analyst]

Why is that a problem? Interpolation will estimate them for you. Pass in what you have, and ask for what you want and you'll get it.