Data Cleaning Exercises

Glossary

Timestamp offset

The +01:00 or Z at the end of a timestamp that ties the clock time to a real instant.

Without an offset, 2026-11-01 01:30 could be several instants. Compare timestamps only after parsing them with their offsets, and quarantine timestamps without one unless a time zone is declared.

Related: UTC, Locale