353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 15:03, 17 April 2017
, 15:03, 17 April 2017→Introduction
====Introduction====
*Five features (addrline1, addrline2, city, state, postcode) in the table contain address information.
*Features addrline1, addrline2 and city are not cleaned. They can have suite, street, city, state and postcode information. , or any combination of these
*The first object of this project is to extract postcode, state and city information from the three features above (Section 2.2.2).
*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 record (Section 2.2.3).
*By For now, we only focus on American patents.
====Extract Address Information====
