Data-set Appending and Cleaning

Post By admin

Project Title: Data-set Appending and Cleaning

Project Description:
I have two data sets,
1. A list of suburbs with other information
2. Suburbs with corresponding postcodes.

I need to match the suburbs (suburbs sheet) with postcodes on another sheet (postcode list). Both are contained in the attached excel work book.

Some of the names will not be a perfect match as there might be a hyphen or an extra word.

Some suburbs exist in multiple states and will look something like “suburb (State)”. Thus, upon matching the data-sets you need to clean the database.

More detail is contained in the attached word document.

For similar work requirements feel free to email us on

  • Facebook
  • Twitter
  • Google Plus
  • Linkedin

Add a comment