Data cleaning in SQL
Wissale Chadli
Database Engineer
Data Analyst
Microsoft SQL Server
SQL
In this project, we clean a dataset related to housing in SQL Server.
Project description
This is a dataset related to housing on Nashville. Here we are cleaning it using SQL in SQL Server Management Studio.
The operations that I performed go as following:
- Putting the date data in standard form.
- Populating proper address data.- Breaking out Address into individual columns (Address, City, State).
- Change Y and N to Yes and No in "Sold as Vacant" field.
- Removing Duplicates.- Deleting Unused Columns.
The code for the project can be found on my github, here: https://github.com/ReDK121/PortfolioProjects/blob/main/DataCleaningProject.sql
