Difference between revisions of "Sonia Zhang (Work Log)"
Jump to navigation
Jump to search
SONIAZHANG (talk | contribs) |
SONIAZHANG (talk | contribs) |
||
| Line 16: | Line 16: | ||
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/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 value in 'country' as 'UNITED STATES' based on 'state' information. | + | 03/06/2017 - Updated ptoassigneend table. Filled some of the missing value in 'country' as 'UNITED STATES' based on 'state' information. |
Revision as of 16:37, 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 - Updated ptoassigneend table. Filled some of the missing value in 'country' as 'UNITED STATES' based on 'state' information.
