Using SQL to clean data about Nashville Housing, the data cleaning process included the following:
- Converting Sale Date from Datetime to only Date
- Populate Missing Values Property Address data
- Breaking out Property Address into individual columns (Address , City)
- Breaking out Owner Address into individual columns (Address , City , State)
- Changing Y and N to Yes and No in "Sold as Vacant" field
- Removing Duplicates