353
edits
Changes
Jump to navigation
Jump to search
NextFirst, 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.
No comma, no dot
Patent Assignment Data Restructure (view source)
Revision as of 17:56, 18 April 2017
, 17:56, 18 April 2017→Identify Clean Data
As mentioned, the ptoassigneend_us_extracted is cleaned. This section works on the remaining records which are stored in ptoassigneend_us_temp.
*zip that is a zip
*city that is a city
The feature city is messy. In this way, we first clean feature city before identifying clean data.
* IS NOT NULL AND city != '' AND city !~* '([,]|[.])'
Problem: can't identify cities
-- 23501
