Project Title: Data-set Appending and Cleaning
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 firstname.lastname@example.org.
Add a comment