Skip to main content

​
Description

This function can be used to replace cells in a dataset within a specified filter

​
Application

This function can be used in multiple scenarios, with one such example being filling missing data with a fixed value to aid with model training

​
How to use

  • Select the step from the Transform>Filter and Clean tab
  • Select your dataset of choice in the ‘Data’ dropdown
  • Select which columns you want to include in your operation

​
Find

Find has 4 different options, this option selects what you are trying to replace Missing/Empty values - the manipulator will select any missing data that it finds within your columns selected Fixed value - the manipulator will select any data which match your chosen value, for instance if you select 1.8 as your fixed value, any cells that contain ‘1.8’ will be selected Values lower than - the manipulator will select any values lower than < your chosen value Values greater than - the manipulator will select any values greater than > your chosen value

​
Replace

Replace has 3 different values, this option selects what you want to replace your data with Missing/Empty values - the manipulator will replace your chosen data with null/empty values Fixed Value - the manipulator will replace your chosen data with a singular fixed value Mean of numerical values in the column - the manipulator will calculate the mean of ALL data within your column, and fill your chosen data in with that mean value

​
Example

Last modified on July 31, 2026