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

Each of these operations, and more, are handled as individual steps in Dataiku’s Prepare recipe. The Prepare recipe’s script provides a history of the cleaning and enrichment actions taken, and allows you to quickly re-apply the data preparation when new data arrives.

See also

Prepare recipe lessons in the Visual Recipes Overview course

Data preparation in the reference documentation