The Purpose of Data Cleaning and Preparation

The value of R lies not only in speed, but also in reproducibility. If a weekly missing-data report is created by code, the same rules can be applied each week. If a query listing is produced from a documented script, another data manager can review how records were selected. If an analysis-ready dataset is regenerated after database corrections, the team can trace the dataset back to the raw export and preparation scripts.