This project will show you some basic methods to clean housing data with SQL, which include 6 blocks:
- Change and save the datatype of SaleDate
- Check the NULL values of PropertyAddress and populate them
- Seperate the PropertyAddress into 2 columns: address, city and save them as new coloumns
- Seperate the OwnerAddress into 3 columns: address, city, STATE and save them as well
- Clean the SoldAsVacant, unify the Yes and Y as Yes (No and N as No)
- Check the duplicated rows using CTE, and remove them.