Data Cleaning Exercises

Glossary

Exact decimal

A number type that stores base-10 digits exactly, used for money.

Floating point can't represent 0.10 exactly. DECIMAL(12,2) in SQL and decimal.Decimal in Python keep cents exact. Casting text to a decimal type may round silently, so validate the text first.

Related: Rounding (half-even), Locale