Replace missing time steps in dataset

2 次查看（过去 30 天）
Olav Kleppa
Olav Kleppa 2020-5-7
编辑： Toder 2020-5-7
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,

请先登录，再回答此问题。

回答（1 个）

Toder
Toder 2020-5-7
编辑：Toder 2020-5-7
If data is the vector of your measurements at times x, you can try
Y = NaN(size(t));
Y(ismember(t,x)) = data;

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by