在插值matlab时间序列对象时,质量向量更新错误



运行以下matlab代码:

% define new timeseries object, set Quality vector to zero
a=timeseries( ...
  [1:6]', ...
  [datenum('2010-1-1 0:00'):1/24:datenum('2010-1-1 05:59')]', ...
  zeros(6,1) ...
);
% set meta data for new timeseries object
a.QualityInfo.Code = 0:1;
a.TimeInfo.Units = 'days';
a.TimeInfo.Increment = 1/24; 
a.TimeInfo.Format = 'dd-mmm-yyyy HH:MM:SS';
a.TimeInfo.StartDate = datestr(0);
% extrapolate timevector and interpolate for half hours. 
b=resample(a, ...
  datenum('2009-12-31 21:00'):1/48:datenum('2010-1-1 05:59'), ...
  'linear', ...
  1 ...
)

输出:

    Time vector characteristics
          Length                18
          Start date            31-Dec-2009 21:00:00
          End date              01-Jan-2010 05:30:00
    Data characteristics
          Interpolation method  linear
          Size                  [18   1]
          Data type             double
    Time                              Data                              Quality
    ---------------------------------------------------------------------------
    31-Dec-2009 21:00:00              NaN                                 1
    31-Dec-2009 21:30:00              NaN                                 1
    31-Dec-2009 22:00:00              NaN                                 1
    31-Dec-2009 22:30:00              NaN                                 1
    31-Dec-2009 23:00:00              NaN                                 1
    31-Dec-2009 23:30:00              NaN                                 1
    01-Jan-2010 00:00:00              1                                   0
    01-Jan-2010 00:30:00              1.5                                 1
    01-Jan-2010 01:00:00              2                                   1
    01-Jan-2010 01:30:00              2.5                                 1
    01-Jan-2010 02:00:00              3                                   1
    01-Jan-2010 02:30:00              3.5                                 1
    01-Jan-2010 03:00:00              4                                   1
    01-Jan-2010 03:30:00              4.5                                 1
    01-Jan-2010 04:00:00              5                                   1
    01-Jan-2010 04:30:00              5.5                                 1
    01-Jan-2010 05:00:00              6                                   1
    01-Jan-2010 05:30:00              NaN                                 1

而我期望输出:

    Time vector characteristics
          Length                18
          Start date            31-Dec-2009 21:00:00
          End date              01-Jan-2010 05:30:00
    Data characteristics
          Interpolation method  linear
          Size                  [18   1]
          Data type             double
    Time                              Data                              Quality
    ---------------------------------------------------------------------------
    31-Dec-2009 21:00:00              NaN                                 1
    31-Dec-2009 21:30:00              NaN                                 1
    31-Dec-2009 22:00:00              NaN                                 1
    31-Dec-2009 22:30:00              NaN                                 1
    31-Dec-2009 23:00:00              NaN                                 1
    31-Dec-2009 23:30:00              NaN                                 1
    01-Jan-2010 00:00:00              1                                   0
    01-Jan-2010 00:30:00              1.5                                 1
    01-Jan-2010 01:00:00              2                                   0
    01-Jan-2010 01:30:00              2.5                                 1
    01-Jan-2010 02:00:00              3                                   0
    01-Jan-2010 02:30:00              3.5                                 1
    01-Jan-2010 03:00:00              4                                   0
    01-Jan-2010 03:30:00              4.5                                 1
    01-Jan-2010 04:00:00              5                                   0
    01-Jan-2010 04:30:00              5.5                                 1
    01-Jan-2010 05:00:00              6                                   0
    01-Jan-2010 05:30:00              NaN                                 1

给定输出和预期输出之间的差异在于,对于插值和外推值,质量矢量应仅设置为1,而不是未更改的值。

在Matlab文档中,只应通过插值函数更改已更改的观测值的质量代码。如本例所示,情况并非如此。

有变通办法吗?

我的matlab版本是:matlab版本7.9.1.705(R2009b)Service Pack 1

我自己找到了一个解决方法:

当你查看内置的Matlab函数\toobox\Matlab\timeseries\@timeseries\resample.m在第192行被写为:

I = isnan(yin) | abs(yout-yin)>eps;

在这一行上,确定哪个标记(存储在I中)将得到Quality代码1。

通常yout和yin之间的差异要大得多,在这种情况下,差异是:

yout-yin

退货:

    ans =
      1.0e-008 *
             0
       -0.1118
       -0.1118
       -0.1118

而eps为:2.2204e-016

通过降低a.数据,我们能够解决Matlab内置函数中的错误::

% extrapolate timevector and interpolate for half hours. 
CorrectionFactor = 1/max(max(a.Data))/1e7;
a.Data = a.Data * CorrectionFactor ;
b=resample(a, ...
  datenum('2009-12-31 21:00'):1/48:datenum('2010-1-1 05:59'), ...
  'linear', ...
  1 ...
);
b.Data = b.Data / CorrectionFactor;
b

将输出:

          Length                18
          Start date            31-Dec-2009 21:00:00
          End date              01-Jan-2010 05:30:00
    Data characteristics
          Interpolation method  linear
          Size                  [18   1]
          Data type             double
    Time                              Data                              Quality
    ---------------------------------------------------------------------------
    31-Dec-2009 21:00:00              NaN                                 1
    31-Dec-2009 21:30:00              NaN                                 1
    31-Dec-2009 22:00:00              NaN                                 1
    31-Dec-2009 22:30:00              NaN                                 1
    31-Dec-2009 23:00:00              NaN                                 1
    31-Dec-2009 23:30:00              NaN                                 1
    01-Jan-2010 00:00:00              1                                   0
    01-Jan-2010 00:30:00              1.5                                 1
    01-Jan-2010 01:00:00              2                                   0
    01-Jan-2010 01:30:00              2.5                                 1
    01-Jan-2010 02:00:00              3                                   1
    01-Jan-2010 02:30:00              3.5                                 1
    01-Jan-2010 03:00:00              4                                   0
    01-Jan-2010 03:30:00              4.5                                 1
    01-Jan-2010 04:00:00              5                                   0
    01-Jan-2010 04:30:00              5.5                                 1
    01-Jan-2010 05:00:00              6                                   1
    01-Jan-2010 05:30:00              NaN                                 1

正如您所看到的,2010年1月1日02:00:002-2010年1月01日05:00:00仍然存在问题,可以通过调整时间矢量的定义方式来解决。我们需要更换:

datenum('2010-1-1 0:00'):1/24:datenum('2010-1-1 05:59')

带有

(datenum('2010-1-1 0:00')*24:datenum('2010-1-1 05:59')*24)/24

完整的解决方案是:

% define new timeseries object, set Quality vector to zero
a=timeseries( ...
  [1:6]', ...
  [(datenum('2010-1-1 0:00')*24:datenum('2010-1-1 05:59')*24)/24]', ...
  zeros(6,1) ...
);
% set meta data for new timeseries object
a.QualityInfo.Code = 0:1;
a.TimeInfo.Units = 'days';
a.TimeInfo.Increment = 1/24; 
a.TimeInfo.Format = 'dd-mmm-yyyy HH:MM:SS';
a.TimeInfo.StartDate = datestr(0);
% extrapolate timevector and interpolate for half hours. 
CorrectionFactor = 1/max(max(a.Data))/1e7;
a.Data = a.Data * CorrectionFactor ;
b=resample(a, ...
  (datenum('2009-12-31 21:00')*48:datenum('2010-1-1 05:59')*48)/48, ...
  'linear', ...
  1 ...
);
b.Data = b.Data / CorrectionFactor;
b

这给出了我们所期望的输出:

    Time vector characteristics
          Length                18
          Start date            31-Dec-2009 21:00:00
          End date              01-Jan-2010 05:30:00
    Data characteristics
          Interpolation method  linear
          Size                  [18   1]
          Data type             double
    Time                              Data                              Quality
    ---------------------------------------------------------------------------
    31-Dec-2009 21:00:00              NaN                                 1
    31-Dec-2009 21:30:00              NaN                                 1
    31-Dec-2009 22:00:00              NaN                                 1
    31-Dec-2009 22:30:00              NaN                                 1
    31-Dec-2009 23:00:00              NaN                                 1
    31-Dec-2009 23:30:00              NaN                                 1
    01-Jan-2010 00:00:00              1                                   0
    01-Jan-2010 00:30:00              1.5                                 1
    01-Jan-2010 01:00:00              2                                   0
    01-Jan-2010 01:30:00              2.5                                 1
    01-Jan-2010 02:00:00              3                                   0
    01-Jan-2010 02:30:00              3.5                                 1
    01-Jan-2010 03:00:00              4                                   0
    01-Jan-2010 03:30:00              4.5                                 1
    01-Jan-2010 04:00:00              5                                   0
    01-Jan-2010 04:30:00              5.5                                 1
    01-Jan-2010 05:00:00              6                                   0
    01-Jan-2010 05:30:00              NaN                                 1

最新更新