This project used data wrangling techniques to explore and clean OpenStreetMap data for West Springfield, MA. I used Python for most of the cleaning and SQL to create a relational database. A summary of the process is below:
Process Overview
- Created a smaller test file to reduce system load
- Cleaned the data in Python
- Checked for problem characters in each tag
- Cleaned up overabbreviated street names
- Fixed incorrect zip codes
- Standardize phone numbers
- Converted from xml to csv
- Imported the cleaned .csv into a SQL database
- Explored the database through queries