Changes

Create As mentioned, city, state and postcode info are extracted from 'addrline1', 'addrline2' and 'city'. Original table also contains 'postcode', 'city' and 'state'. In this way, we have four postcode, four city and four postcode for each record.  Info extracted from addresses and info from original table are not consistent. So, the object of this section is to pick out the best postcode, city and state for each record, and create a Master Table with original features and cleaned postcode, city, and state.