353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:00, 18 April 2017
, 17:00, 18 April 2017→Identify Clean Data
==== Identify Clean Data ====
As mentioned, the ptoassigneend_us_extracted is cleaned. So this This section works on the remaining records which are in ptoassigneend_us_temp.
Next, filter out records with city that is a city, zip that is a zip, state that is a state. Note: The consistency between city and state or city and postcode is not checked in this section.
*zip that is a zip
Match the pattern 5-4 or 5 digits.
*city state that is a citystate
All the records not null are valid state names.
*state city that is a statecity
