• Separate into three tables (Location, Characteristics, and Selling).

Location

Cleaning

• Remove non residential ones based on Characteristics Table
• Make CITYL into full names
• Fix ID to patch geoID format

Transformation

Need to do

• Lat/Lon and Census Tracts

Characteristics

Cleaning

• Clean PCDesc NA coding
• Remove those that are not residential properties using PCDesc
• Remove comma separator in year built

Transformation

• Recode YrBuilt into ACS categories (YrBuiltACS)
• Recode NumBdRms into ACS categories (BedCountACS)
• Recode NumBaths into ACS categories (BathAC)
• Recode HeatDsc into ACS categories (HeatingACS)

Need to do

Selling

Cleaning

• Remove non residential ones based on Characteristics Table
• Remove commas from value amounts
• Clean selling dates NA coding
• Remove those transactions that occurred before 2009
• Remove those transactions with a $0 attached amount

Transformation

• Recode selling dates into year (SellingYear)
  • Change glitch that created some 19xx years to 20xx years
• Remove those transactions that occurred before 2009
• Put Amount in Constant 2013 dollars
• Put value into ACS categories

• Restructuring

  • Restructure per a transaction

Need to do