Replacing value by the mean of the two nearest neighbors

19 次查看（过去 30 天）
Ludovica Maria Campagna
评论： Alexis 2024-1-24
Ran in:
I have a column vector:
B = [20; 18; NaN; 25; 100; 15; -50; 23]
B = 8×1
20 18 NaN 25 100 15 -50 23
I need to pre-process data, so I want to:
  1. replace numbers greater than a certain value (e.g. numbers greater than 40) with the average of the two adjacent numbers.
  2. replace numbers smaller than a certain value (e.g. numbers smaller than -10) with the average of the two adjacent numbers.
  3. replace missing value with the average of the two adjacent numbers.
Thank you!

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

采纳的回答

David Hill
David Hill 2022-9-26
Ran in:
B = [20; 18; NaN; 25; 100; 15; -50; 23; NaN; 15; -15; 30];
idx=find(isnan(B));
B(idx)=mean([B(idx-1),B(idx+1)],2);
idx=find(B<-10);
B(idx)=mean([B(idx-1),B(idx+1)],2);
idx=find(B>40);
B(idx)=mean([B(idx-1),B(idx+1)],2)
B = 12×1
20.0000 18.0000 21.5000 25.0000 20.0000 15.0000 19.0000 23.0000 19.0000 15.0000

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by