Data Cleaning Nashville, Tennessee Housing (sample-size)

 

 

GitHub Repository: HERE 

Handled with: Microsoft SQL Server Management Studio 18, Microsoft Excel 

Programming Language: SQL 

Why I Selected this Project

For this project, I wanted to showcase some SQL coding techniques and also so I can refer back to for future reference. Here I practiced managing and cleaning Nashville housing data from a sample dataset found on Kaggle. Kaggle is a website/database that allows users to share their data with the public and also allows them to use it for their own research purposes. This dataset comes from the author TMTHYJAMES on Kaggle. 

What I did for this Project

1. Display Data
2. Change Data Types
3. Create a New Column
4. Update Table
5. Handle NULL Values
6. Join Table
7. Removed Duplicate Data
8. Split "Address" into Individual Columns (Address, City, State)
9. Change "Y" and "N" to Yes and No
10. Managed CTE (Common Table Expression)