Find and Replace
This tool allows users to find and replace specific cell values in their dataset. This can be useful for data cleansing if you find that your data has some values that are inaccurate or incorrect. For example, this can be used to standardize uppercase or lowercase for different categories in string categorical features or replace erroneous numbers with missing values in numerical features. You have the option to require an exact match or allow matches that contain your search phrase. You can also specify whether the case must match or not.
There are two options for how to find values:
- Column: Use this option if you would only like to find or replace values in specific columns.
- Type: Use this option if you would like to find or replace values in all columns of a certain type.