Data Cleaning with SQL

View All NashvilleHousing table records

Convert SaleDate column from DateTime to Date data type as time does not serve any purpose in this dataset. Update current NashvilleHousing table SaleDate column records with new data type value.

Alternative method to convert SaleDate column data type as SQL Server sometimes refuse to change data type. Add new column with converted values instead of updating existing column.

Self-Join to NashvilleHousing table to extract property address and replace NULL values in PropertyAddress column. After closer table data analysis, ParcelID can be referenced to extract missing address.

UniqueID column distinguish Property Address where address is ame fot two or more identical ParcelID's.

Update NashvilleHousing table PropertyAddress NULL values with extracted address via self-join

Use of SUBSTRING, CHARINDEX and LEN functions to divide PropertyAddress value into automic values

Add new Property Address split values to NashvilleHousing table

Alternative method to split string values using PARSENAME and REPLACE functions. Somewhat creative but simpler than above method.

Change single character values "Y" and "N" to "Yes" and "No" based on condition using CASE clause

Remove dublicate records from Nashville table. Use Common Table Expression (CTE) to pre-render table records.

DELETE dublicate records and unused columns from NashvilleHousing table