Write down what you expected
Before the first look, write the row count and the columns you expect. Comparing expectation to reality turns the description into a test. Without the expectation, everything looks normal and nothing is checked.
Uniqueness of the row key
If one row should mean one thing, the key column should have no duplicates. Count distinct values against the row count. A mismatch means duplicated observations, and duplicates double count every total you are about to report.