Effacer les filtres
Effacer les filtres

Replace missing time steps in dataset

3 vues (au cours des 30 derniers jours)
Olav Kleppa
Olav Kleppa le 7 Mai 2020
Modifié(e) : Toder le 7 Mai 2020
I have a dataset with hourly measured data from 2013 to 2019. Some values are missing but not appearing in my dataset, and I want to include these values as NaN.
I have created a "true" time series:
%%
t1 = datenum(2013,10,1,0,0,0);
t2 = datenum(2019,10,1,0,0,0);
t = t1:(1/1440):t2;
And I also have the date number matrix,x, of my measurements, containing fewer elements. How can I fill in measured data in my new time series, and NaN where I dont have measurements?
I now have
t=52585x1 double
x=44719x1 double
Best regards,

Réponses (1)

Toder
Toder le 7 Mai 2020
Modifié(e) : Toder le 7 Mai 2020
If data is the vector of your measurements at times x, you can try
Y = NaN(size(t));
Y(ismember(t,x)) = data;

Catégories

En savoir plus sur Dates and Time 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!

Translated by