Data Cleaning in SQL

Number of Rows 56,477

Initial Data

Standardize Date Format

Before

After

Populate Property Address Data

Before

After

Breaking out PropertyAddress into Individual Columns

Before

After

Breaking out OwnerAddress into Individual Columns

Before

After

Changing Y, N, Yes & No to a single format: Yes and No

"Sold as Vacant" column contained 4 types of data- Yes, Y, No & N. I kept the Yes & No as it is and looked for shortforms Y & N, then converted it into Yes & No accordingly.

Before

After