Difference between revisions of "Sonia Zhang (Work Log)"

From edegan.com
Jump to navigation Jump to search
Line 14: Line 14:
 
03/1/2017 - Had a meeting discussing problems in the patent data.
 
03/1/2017 - Had a meeting discussing problems in the patent data.
  
03/2/2017 - Created a new table proassigneend2. Cleaned some of the 'name' and 'city' records in ptoassigneend2. Created ptoassigneend_country table to store country information. Figured out some methods to fill the empty 'city'/'country' information.
+
03/2/2017 - Cleaned some of the 'name' and 'city' records in ptoassigneend2. Created ptoassigneend_country table to store country information. Figured out some methods to fill the empty 'city'/'country' information.
 +
 
 +
03/06/2017 - Filled some of the missing 'country' based on 'state' information.

Revision as of 17:34, 6 March 2017


Sonia Zhang Work Logs (log page)

Summer Work

02/23/2017 - Set Up the User Page and the Work Log Page. Got an overview of the patent data.

02/27/2017 - Started working on the issues listed on Patent Data Issues.

02/28/2017 - Cleaned the assigneeinfo, msalist etc.

03/1/2017 - Had a meeting discussing problems in the patent data.

03/2/2017 - Cleaned some of the 'name' and 'city' records in ptoassigneend2. Created ptoassigneend_country table to store country information. Figured out some methods to fill the empty 'city'/'country' information.

03/06/2017 - Filled some of the missing 'country' based on 'state' information.