Is it possible to detect and replace abnormal/wrong numbers in an array?

5 次查看（过去 30 天）

Rikke 2019-3-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/451211-is-it-possible-to-detect-and-replace-abnormal-wrong-numbers-in-an-array

评论： Chris Turnes 2019-3-21

I have a dataset which is an array containing values, and which are plotted in the figure below. A section of the array for the figure is: A = [.... 25.9, 25.9, 26.2, 27, 28, 29, 29.3, 29.6, 3, 30.4, 30.5, 30.4, 30.3, 30.3, ....]; Here is number 3 an abnormality in the array. Is it possible to detect these abnormal numbers and replace them with the average value of the number before and after? So for the number 3 in A I want it to be (29.6+30.4)/2.

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

请先登录，再进行评论。

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

采纳的回答

Kevin Phung 2019-3-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/451211-is-it-possible-to-detect-and-replace-abnormal-wrong-numbers-in-an-array#answer_366424

在 MATLAB Online 中打开

A = [25.9, 25.9, 26.2, 27, 28, 29, 29.3, 29.6, 3, 30.4, 30.5, 30.4, 30.3, 30.3]
abnorm =mean(A) -  3*std(A); % you can set however many standard deviations to constitute 'abnormal'
n = find(A<abnorm); %locations of abnormals
for i = 1:numel(n)
    if or(n(i) == 1, n(i)==numel(A)) %if first or last index, replace with NaN;
        A(n(i)) = nan;
    else
            A(n(i)) = (A(n(i) - 1) + A(n(i) + 1)) / 2;
    end
end
A(isnan(A)) = []; %remove the endpoints that are NaN

let me know if this works for you

7 个评论
显示 5更早的评论隐藏 5更早的评论

Kevin Phung 2019-3-20

编辑：Kevin Phung 2019-3-20

在 MATLAB Online 中打开

happy to help!

edit: if number of lines of code is important to you at all, you can actually condense the first 3 lines to one

n = find(isoutlier(A,'movmedian',5)); %locations of abnormals
for i = 1:numel(n)
    if or(n(i) == 1, n(i)==numel(A)) %if first or last index, replace with NaN;
        A(n(i)) = nan;
    else
            A(n(i)) = (A(n(i) - 1) + A(n(i) + 1)) / 2;
    end
end
A(isnan(A)) = []; %remove the endpoints that are NaN