DATA CLEANING - ACAPS

← Back to document page

+ data CLEANING April 2016 Dealing with messy data Table of Contents Introduction ........................................ .................................. 0 A. The data CLEANING Process ........................................ .. 0 B. Sources of Error ........................................ ...................... 1 C. First Things First ........................................ .................... 2 D. Screening data ........................................ ....................... 2 E. Diagnosing data ........................................ ..................... 4 F. Treatment of data ........................................ .................. 4 G. Missing Values ........................................ ....................... 5 H. Documenting Changes.

The following sections of this document offer a step by step approach to data cleaning. C. First Things First . The first thing to do is to make a copy of the original data in a separate workbook and name the sheets appropriately, or save in a new file. ALWAYS keep the source files in a separate folder and

  Data, Step, Cleaning, Data cleaning