Skip to content

Files

Latest commit

 

History

History
20 lines (10 loc) · 1.16 KB

README.md

File metadata and controls

20 lines (10 loc) · 1.16 KB

SQL Nashville Housing

This section involves various data cleaning tasks for the Nashvillahousing table.

  • Standardize Date Format: Converts the SaleDate column to a standardized date format using CAST.

  • Populate Property Address Data: Fills in missing PropertyAddress values by joining the table with itself based on ParcelID and copying non-null addresses.

  • Breaking out PropertyAddress: Splits the PropertyAddress column into Address and City using SUBSTRING and CHARINDEX, and stores them in new columns.

  • Breaking out OwnerAddress: Similar to above, splits OwnerAddress into individual components (OwnerAddress, OwnerCity, OwnerState) using PARSENAME and REPLACE, and stores them in new columns.

  • Change Y and N to Yes and No: Converts values in the SoldAsVacant column from 'Y' to 'Yes' and 'N' to 'No'.

  • Remove Duplicates: Utilizes a Common Table Expression (CTE) with ROW_NUMBER() to identify and remove duplicate rows based on certain columns.

  • Delete Unused Columns: Drops specified columns (OwnerAddress, TaxDistrict, PropertyAddress, SaleDate) from the table.

Repository created by [Diyan].