The purpose of this project is to show my skills in data cleaning in SQL. For example null values are populated as property address and update the table. I am not trying to find any objective in this project, but showing my data cleaning skills. Therefore, I did not go overboard and kept it as simple as I could.
Microsoft SQL Server. NashvillHousing Excel Dataset.
Object based considerations
- Date
- SalePrice
- ParcelID
- SaleDate
- Legal Referemce
- SoldAsVacant
- OnwerName
- OwnerAddress
- Acreage
- TaxDistrict
- LandValue
- BuidlingValue
- TotalValue
- YearBuilt
- Bedrooms
- FullBath
- Replacing values
- Delimiters (Substr, character indx)
- Removing Duplicates
- Convert
- populate Address
- Case to change (N, Y) to (No, Yes)
- Delete useless columns