CAPSTONE Project 3SQL Data Cleaning |
portfolio_page-template-default,single,single-portfolio_page,postid-51009,theme-vigor,edgt-core-1.3.2,woocommerce-no-js,ajax_fade,page_not_loaded,,vigor-ver-3.1, vertical_menu_with_scroll,smooth_scroll,fade_text_scaledown,wpb-js-composer js-comp-ver-6.7.0,vc_responsive


Project 3
SQL Data Cleaning

Link to Data on GitHub

In this Case Study, housing data will be inspected, cleaned, and organized for use using SQL.

  • Standardizing Date Formats
  • Populate Property Address Data
  • Breaking Address out in to Individual Columns (Address, City, State)
  • Changing Y and N to “Yes” and “No” in the “Sold as Vacant” Field
  • Removing Duplicate Entries
  • Deleting Unused Columns