Data can be messy, incomplete, and inconsistent. Cleaning it up is a real pain.

If you do not find this to be true, then you need to reevaluate your data.