Is there a good place/way to ask a question that basically amounts to "How do I check the contents of my data are what I want them to be?" I'm sure this is a solved problem, I just don't know the solution.
Background: I work for a (smallish) organisation that does data analysis for hospitals; we tell them to send their data to us in whatever form they have, then we standardise it and send them reports with benchmarking results back. The problem is, human error inevitably occurs, generally at the 'standardisation' stage, and is not caught until much later, so we wind up sending data with e…