Reference | Data cleaning#

Excel supports a number of data cleaning operations, including:

  • Renaming columns.

  • Removing columns.

  • Assessing data quality.

  • Finding and replacing invalid values.

../../_images/excel-find-replace.png

Dataiku’s Prepare recipe handles each of these operations and more as individuals steps. The Prepare recipe’s script provides a history of the cleaning and enrichment actions taken, and allows you to re-apply the data preparation when new data arrives.

See also

More information can be found in Prepare Recipe.