Matlab Data-series conversion
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Image Analyst
am 8 Mai 2013
Have you looked at using interp1()?
2 Kommentare
Image Analyst
am 8 Mai 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.
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!