Matlab Data-series conversion
2 ビュー (過去 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 で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!