> ## Documentation Index
> Fetch the complete documentation index at: https://docs.coreweave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Find and Replace

> Replace cells in a dataset within a specified filter, such as filling missing data with a fixed value

## 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

<img src="https://mintcdn.com/coreweave-dbfa0e8d/QRLrBgwZtalbZXz3/monolith-ai/_media/Find-and-Replace-1.png?fit=max&auto=format&n=QRLrBgwZtalbZXz3&q=85&s=5f66505df7a5a5bdd07e2a0def2c90f9" alt="Find and Replace step settings with Columns selected and Missing/Empty values chosen for Find and Replace" width="1902" height="527" data-path="monolith-ai/_media/Find-and-Replace-1.png" />
