Regarding removal of low values within time series

2 次查看（过去 30 天）
BenL
BenL 2017-6-7
编辑： BenL 2017-6-7
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

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

回答（1 个）

KSSV
KSSV 2017-6-7
编辑：KSSV 2017-6-7
data = xlsread('data_qn.xls') ;
data(data<4) = [] ; % remove values less then 4
  1 个评论
BenL
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.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by