Matlab Data-series conversion
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Image Analyst
le 8 Mai 2013
Have you looked at using interp1()?
2 commentaires
Image Analyst
le 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.
Voir également
Catégories
En savoir plus sur Preprocessing Data dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!