top of page

Nashville Housing Case Study

The goal of this case study was to clean and manipulate the Nashville housing dataset. I have posted the code as well as my annotations throughout.

Cleaning_Housing_Data_in_SQL_Queries.png
Cleaning_Housing_Data_in_SQL_Queries 3.png
Cleaning_Housing_Data_in_SQL_Queries 2.png
Cleaning_Housing_Data_in_SQL_Queries 4.png

Cleaned, manipulated, and visualized with Excel

How data was cleaned and manipulated:​

  • Standardized Date Format

  • Populated Property Address data

  • Broke address into Individual Columns (Address, City, State)

  • Changed Y and N to Yes and No in "Sold as Vacant" field

  • Removed Duplicates

  • Ordered by ParcelID

  • Deleted Unused Columns

Jonathan K. Brown

bjonathan066@gmail.com

(347) 207-6851

©2022 by Jonathan K. Brown. Proudly created with Wix.com

bottom of page