Replace missing time steps in dataset

1 view (last 30 days)
Olav Kleppa
Olav Kleppa on 7 May 2020
Edited: Toder on 7 May 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,

Answers (1)

Toder
Toder on 7 May 2020
Edited: Toder on 7 May 2020
If data is the vector of your measurements at times x, you can try
Y = NaN(size(t));
Y(ismember(t,x)) = data;

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!