☰

Cleaning Data

## Cleaning Data ### Why messy data breaks analysis --- ## Common problems * Inconsistent spelling ("NY", "N.Y.", "New York") * Missing values * Duplicate rows * Numbers stored as text ___ ## Example Note: Ask participants to spot the problem in this row before revealing the fix. | Name | City | |------|------| | J. Smith | ny | ___ ## Fixed | Name | City | |------|------| | J. Smith | New York | --- ## Takeaway Clean data first, analyze second. A beautiful chart built on messy data is still wrong.
  • See it fullscreen