Correctly cleaning historical data is about using the correct process. If you use the correct process, you will be successful and even determine what success is in the first place. Here is the correct process:
Clean in short, specific stages
Have easily accessible data characterization...