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 23, 2026
