Changes

=====1. Introduction=====*Five features (addrline1, addrline2, city, country, postcode) in the table contain address information.*Features addrline1, addrline2 and city are not cleaned. They have city, country and postcode information. *The first object of this project is to extract postcode, state and city information from the three features above.*Then, we summarize the postcode, state and city information in the original table and those extracted from addresses to generate only one postcode, state and city for each records.*By now, we only focus on cleaning American patents. =====2. Postcode(U.S.)=====

city | postcode_citypostcode_extracted

The extracted post code records are stored in table ptoassigneend_missus_finalptoassigneend_us_extracted.

=====3. State (U.S.)=====

Some The following patterns can be used to extract state information.

This pattern is not reliable. When addrline1 looks this way, addrline2 always provide more detailed address information than addrline2addrline1. Besides, a great part of state info extracted from 'A CORP.* OF [State]' doesn't match the state extracted from detailed addrline2. In this way, we discard this pattern.

The extracted state records are stored in the table ptoassigneend_missus_finalptoassigneend_us_extracted.

=====4. City (U.S.)===== Some patterns can be used to extract city information.

Three lists of samples extracted from addrline1, addrline2 and city are The following patterns can be used to summarize the patternsextract city information. They are in Z:/PatentAddress/

MASSACHUSETTS 02780-7319 ('State '+'Postcode')

Contain all the original features as well as city, state and postcode info extracted from features addrline1, addrline2 and city. See Section 2, 3, 4 .2.1 for extraction processdetails.