Data Cleaning Exercises

Glossary

Locale

The conventions a value was written in: 1,234.50 (en-US) versus 1.234,50 (de-DE), 03/04 as month/day or day/month.

Parsing numbers and dates needs the locale the writer used. Without a declared locale, ambiguous values must be quarantined, not guessed.

Related: Exact decimal, Timestamp offset