Skip to content

rzn-git/SQL_Portfolio_DataCleaning

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

17 Commits
 
 
 
 

Repository files navigation

Data Cleaning in SQL

Number of Rows 56,477

Initial Data

1

Standardize Date Format

Before

2

After

3

Populate Property Address Data

Before

4

After

5

Breaking out PropertyAddress into Individual Columns

Before

6

After

7

Breaking out OwnerAddress into Individual Columns

Before

8

After

9

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

10

11

After

15

12

Releases

No releases published

Packages

No packages published