353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:41, 13 March 2017
, 17:41, 13 March 2017→Restructure Address Information
From addrline1, addrline2 and city, I extracted city, post code and state respectively and stored in 'city_addr1', 'city_addr2', 'city_city'.
Applied similar methods to filter out patent records from Japan. The post code in Japan follows pattern [three digits- four digits].
