The Purpose of Data Cleaning and Preparation

The distinction between cleaning and preparation matters because not every transformation is a correction. Correcting a typographical error in a date is different from deriving age at enrollment. Recoding numeric values into labels is different from changing an invalid value after source document review. Creating a site-level missingness summary is different from editing participant-level data. A high-quality workflow records these differences.