Matlab Data-series conversion
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Image Analyst
2013-5-8
Have you looked at using interp1()?
2 个评论
Image Analyst
2013-5-8
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Preprocessing Data 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!