
When Two Identical Rows Are Not Necessarily a Mistake
Investigate apparently duplicated rows by checking identifiers, timestamps and the collection process before deleting records from a dataset.

Investigate apparently duplicated rows by checking identifiers, timestamps and the collection process before deleting records from a dataset.

Check units and conversion rules before combining measurements, using a small length example to show why matching column names are not enough.

Distinguish the number of recorded observations from the number of subjects in a dataset before interpreting repeated measurements as separate participants.

Make field notes more useful by recording what you noticed separately from the explanation you want to test.

Read a sample by asking who could be included, who responded and which population the conclusions are meant to describe.

Treat a shared pattern as a starting question by checking timing, alternative explanations and the design of the study.

See how a single large value affects the mean and median, then choose a summary based on the question rather than habit.

Before filling empty cells, distinguish an observed zero from an unrecorded, unavailable or inapplicable value.