Changes

As mentionedin Section 2.2.2, 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 postcodecandidates for city, four city state and four postcode for each record.

Info extracted from addresses and info from that in the original table are not consistent. SoIn this way, 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.