Before you begin cleaning and processing your data creating a plan will help to keep you organized and to determine the process you'll go through to clean and prepare your data.
Your plan will also serve as documentation for those who wish to use your data in the future. The plan can also help you track down and fix mistakes.
In general, the process for creating a plan is:
The goal state will describe how you want your data files to look like after you have finished your cleaning and processing tasks. This describes the result of all of your data cleaning and processing work. The goal state should document:
The goal state will be determined by a number of factors:
Once you've determined your goal state, create your plan by documenting the steps that you'll have to perform to get from your current state to the goal state.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.