Sonia Zhang (Work Log) - Revision history

MichelleH at 16:14, 2 November 2017

2017-11-02T16:14:59Z

2017-03-27T21:53:58Z

Summer Work

2017-03-21T21:12:19Z

2017-03-21T21:09:31Z

2017-03-15T19:46:45Z

2017-03-14T22:17:04Z

2017-03-14T22:13:34Z

2017-03-14T21:44:49Z

2017-03-14T20:32:41Z

2017-03-14T20:30:03Z

@@ Line 1: / Line 1: @@
+===Summer 2017===
 /23/2017 - Set Up the User Page and the Work Log Page. Got an overview of the patent data.
@@ Line 29: / Line 27: @@
 /16/2017 - 03/27/2017 - Restructure addrline1, addrline2 and city features. See [[Patent Data Restructure]].
 [[Category:Work Log]]

← Older revision		Revision as of 21:53, 27 March 2017
Line 27:		Line 27:

	03/15/2017 - Cleaned the country column.		03/15/2017 - Cleaned the country column.
		+
		+	03/16/2017 - 03/27/2017 - Restructure addrline1, addrline2 and city features. See [[Patent Data Restructure]].
	[[Category:Work Log]]		[[Category:Work Log]]

← Older revision		Revision as of 21:09, 21 March 2017
Line 1:		Line 1:

−	~~[[Category:Work Log]]~~
−	~~[[Category:Internal]]~~

	[[Sonia Zhang]] [[Work Logs]] [[Sonia Zhang (Work Log)\|(log page)]]		[[Sonia Zhang]] [[Work Logs]] [[Sonia Zhang (Work Log)\|(log page)]]

← Older revision		Revision as of 19:46, 15 March 2017
Line 27:		Line 27:

	The problem needed to be solved is that the post code from some countries follows the same pattern of the street code. For example, based on the pattern of [three digits-three digits], records from South Korea and German(some) are extracted.		The problem needed to be solved is that the post code from some countries follows the same pattern of the street code. For example, based on the pattern of [three digits-three digits], records from South Korea and German(some) are extracted.
		+
		+	03/15/2017 - Cleaned the country column.

← Older revision		Revision as of 22:17, 14 March 2017
Line 23:		Line 23:

	03/14/2017 - Focused on the country and post code information. Extracted country and post code information from addrline1 and addrline2 columns for patents from Japan and South Korea.		03/14/2017 - Focused on the country and post code information. Extracted country and post code information from addrline1 and addrline2 columns for patents from Japan and South Korea.
		+
		+	Cleaned the names of country. (Not finished yet)

	The problem needed to be solved is that the post code from some countries follows the same pattern of the street code. For example, based on the pattern of [three digits-three digits], records from South Korea and German(some) are extracted.		The problem needed to be solved is that the post code from some countries follows the same pattern of the street code. For example, based on the pattern of [three digits-three digits], records from South Korea and German(some) are extracted.

← Older revision		Revision as of 22:13, 14 March 2017
Line 22:		Line 22:
	03/13/2017 - Applied similar methods to extract address information from Japanese patents. The results are stored in 'ptoassigneend_missjapan'. Matched the post code pattern to 200 distinct countries that exist in patent table.		03/13/2017 - Applied similar methods to extract address information from Japanese patents. The results are stored in 'ptoassigneend_missjapan'. Matched the post code pattern to 200 distinct countries that exist in patent table.

−	03/14/2017 - Focused on the country and post code information. Extracted country and post code information from addrline1 and addrline2 columns for patents from Japan and South Korea.	+	03/14/2017 - Focused on the country and post code information. Extracted country and post code information from addrline1 and addrline2 columns for patents from Japan and South Korea.
		+
		+	The problem needed to be solved is that the post code from some countries follows the same pattern of the street code. For example, based on the pattern of [three digits-three digits], records from South Korea and German(some) are extracted.

← Older revision		Revision as of 21:44, 14 March 2017
Line 22:		Line 22:
	03/13/2017 - Applied similar methods to extract address information from Japanese patents. The results are stored in 'ptoassigneend_missjapan'. Matched the post code pattern to 200 distinct countries that exist in patent table.		03/13/2017 - Applied similar methods to extract address information from Japanese patents. The results are stored in 'ptoassigneend_missjapan'. Matched the post code pattern to 200 distinct countries that exist in patent table.

−	03/14/2017 -	+	03/14/2017 - Focused on the country and post code information. Extracted country and post code information from addrline1 and addrline2 columns for patents from Japan and South Korea.

← Older revision		Revision as of 20:32, 14 March 2017
Line 22:		Line 22:
	03/13/2017 - Applied similar methods to extract address information from Japanese patents. The results are stored in 'ptoassigneend_missjapan'. Matched the post code pattern to 200 distinct countries that exist in patent table.		03/13/2017 - Applied similar methods to extract address information from Japanese patents. The results are stored in 'ptoassigneend_missjapan'. Matched the post code pattern to 200 distinct countries that exist in patent table.

−	03/14/2017 - As mentioned above, three kinds of information that can be extracted from address columns are city, country and post code (plus state for U.S.). The post code extracted is quite accurate for almost all the countries, and so is the country information (and the state for U.S.).	+	03/14/2017 -
−
−	The problem is that the city information extracted is not quite good. It messes up with street names. One approach to increase the accuracy is to list all the possible cities in each country, and then match the address columns to these cities, which is time consuming.

← Older revision		Revision as of 20:30, 14 March 2017
Line 20:		Line 20:
	03/10/2017 - Extracted U.S. address information in ptoassigneend table. The extracted records are stored in the new table 'ptoassigneend_missus'. See details [[Patent Data Restructure]]		03/10/2017 - Extracted U.S. address information in ptoassigneend table. The extracted records are stored in the new table 'ptoassigneend_missus'. See details [[Patent Data Restructure]]

−	03/12/2017 - Applied similar methods to extract address information from Japanese patents. The results are stored in 'ptoassigneend_missjapan'. Matched the post code pattern to 200 distinct countries that exist in patent table.	+	03/13/2017 - Applied similar methods to extract address information from Japanese patents. The results are stored in 'ptoassigneend_missjapan'. Matched the post code pattern to 200 distinct countries that exist in patent table.
		+
		+	03/14/2017 - As mentioned above, three kinds of information that can be extracted from address columns are city, country and post code (plus state for U.S.). The post code extracted is quite accurate for almost all the countries, and so is the country information (and the state for U.S.).
		+
		+	The problem is that the city information extracted is not quite good. It messes up with street names. One approach to increase the accuracy is to list all the possible cities in each country, and then match the address columns to these cities, which is time consuming.