Data Cleaning Exercises

Glossary

Boolean parsing

Turning answers like Y, yes, TRUE or 1 into true/false with a declared list, rejecting anything else.

Flags arrive in many spellings. Map an explicit, reviewed list of accepted values to true and false, keep unknown spellings as exceptions, and never treat a missing answer as false.

Related: Controlled vocabulary, Missing value (null)