Matlab Data-series conversion
2 views (last 30 days)
Show older comments
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
0 Comments
Answers (1)
Image Analyst
on 8 May 2013
Have you looked at using interp1()?
2 Comments
Image Analyst
on 8 May 2013
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.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!