The Same Number Can Describe a Different Quantity

Conceptual desk scene with a notebook, a pressed leaf and blank cards beside a laptop.
Conceptual illustration created with AI; not a research result or laboratory photograph.

Two files both contain a column called length. One records centimetres and the other millimetres. Combining their numbers without checking units creates a tidy table with an untidy meaning.

Read the measurement definition

Find the unit in the data dictionary, instrument output or accompanying notes. Do not infer it solely from the size of the numbers. A value of 12 could be plausible under several measurement systems.

For a hypothetical example, 12 centimetres equals 120 millimetres. A second measurement of 125 millimetres is therefore 12.5 centimetres. Their mean is 12.25 centimetres, not the mean of the unconverted numbers 12 and 125.

Keep the original and converted fields distinct

Preserve a clear record of the input value and the conversion used. Name the new field with its unit so that a later reader does not convert it a second time.

Check whether the quantity itself matches too. Height and total length remain different measurements even when both use centimetres.

Test a few rows by hand

Choose simple examples and confirm the result before processing a larger file. Record any missing or ambiguous units as unresolved data issues.

Combine this practice with careful handling of missing values. Meaningful analysis begins with consistent quantities, not merely columns that happen to share a convenient name.