353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:04, 20 March 2017
, 16:04, 20 March 2017→Restructure Address Information
:'''1. Introduction'''
::*Five features (addrline1, addrline2, city, country, postcode) in the table contains contain address information.
::*Features addrline1, addrline2 and city are not cleaned. They have city, country and postcode information.
::*The object of this project is to extract city, country and postcode information from the three features above.
::*By now, we only focus on cleaning American patents.
::The extracted records are stored in table ptoassigneend_missus.
:'''3. Issues
::* Different countries have different kinds of post codes. The ultimate post code and zip regex can be found:
http://stackoverflow.com/questions/578406/what-is-the-ultimate-postal-code-and-zip-regex
