Tynoee / nashville-housing-data-cleaning Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

This repository contains SQL scripts used to clean and prepare the Nashville Housing dataset for analysis.

0 stars 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
LICENSE		LICENSE
Nashville Housing Data.xlsx		Nashville Housing Data.xlsx
README.md		README.md
data_cleaning.sql		data_cleaning.sql

Repository files navigation

nashville-housing-data-cleaning

This repository contains SQL scripts used to clean and prepare the Nashville Housing dataset for analysis.

Cleaning Concepts Covered

Standardize SaleDate format
Populate missing PropertyAddress values
Split PropertyAddress into Address and City
Split OwnerAddress into Address, City, and State
Convert SoldAsVacant values from Y/N to Yes/No
Remove duplicate records using ROW_NUMBER() and CTE
Drop unused columns

About

This repository contains SQL scripts used to clean and prepare the Nashville Housing dataset for analysis.

sql sql-server database etl data-engineering data-analytics cte data-processing data-preparation data-cleaning real-estate-data

Report repository

Releases

No releases published

Packages

No packages published

Languages

TSQL 100.0%