## 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.