Skip to main content

DataCleansing

Spark Gem

Use the DataCleansing Gem to standardize data formats and address missing or null values in the data.

Parameters

ParameterDescription
Select columns you want to cleanThe set of columns on which to perform cleaning transformations
Remove null dataThe method used to remove null data
Replace null values in columnThe method used to replace null values
Clean dataDifferent ways to standardize the format of data in columns

Example

Assume you have a table that includes customer feedback on individual orders. In this scenario, some customers may not provide feedback, resulting in null values in the data. You can use the DataCleansing Gem to replace null values with the string NA.

Replace null with string