Regarding removal of low values within time series

Question

BenL 2017-6-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343633-regarding-removal-of-low-values-within-time-series

编辑： BenL 2017-6-7

data_qn.xls

I have a time series data (see attached data_qn.xls) that consists of values that are clearly lower than the rest of the observations. How could I remove these values in MATLAB?

I considered running a sliding window function that returns the lowest values, but it seem impractical because the window size may be different. I also tried something like the code below, but the indices are relative to its own window array and that complicates things.

for i = 1:length(data)-window_sz % window_sz = 20 arbitrarily
  window_range = data(i:i+window_sz-1,:);
  [M I] = min(window_range);
  del_rows(i,1)=I;
end

Any idea?

Thank you Ben

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2017-6-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343633-regarding-removal-of-low-values-within-time-series#answer_269822

编辑：KSSV 2017-6-7

在 MATLAB Online 中打开

data = xlsread('data_qn.xls') ;
data(data<4) = [] ;    % remove values less then 4

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

BenL 2017-6-7

I pondered over thresholding but I realised that not all of my datasets can perform thresholding at a consistent value, even though the 'line' of lowest values exist.

请先登录，再进行评论。