replace an outlier value with average of previous record & next record

Best Answer

• Options

  MartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,509 RM Data Scientist

  July 2020 Solution Accepted

  Hi,

  you can use Generate Attributes first to assign missing values by a rule, like

  if(Utilization>90, MISSING_NUMERIC, Utilization)

  Then you can use Replace Missing Values (Series) to interpolate.

  
  

  Best,

  Martin
  

  - Sr. Director Data Solutions, Altair RapidMiner -
  Dortmund, Germany

  6