For records of which addrline1, addrline2 and city don't contain postcode info, just clean the feature postcode as the postcode_cleaned
All the cleaned postcodes for U.S. patents are stored in ptoassigneend_us_postcodecleaned. (# 35724603572604)
=====State=====
For records of which addrline1, addrline2 and city don't contain state info, just take feature state as the state_cleaned.
* Output
SQL code is in:
E:/McNair/Projects/PatentAddress/StateClean.sql
States extracted from addrline1, addrline2 and city are stored in ptoassigneend_state.
All the cleaned states for U.S. patents are stored in ptoassigneend_us_statecleaned. (# 3572605)
====Issues====