337
edits
Changes
Jump to navigation
Jump to search
no edit summary
[[Installing python in a database]], added building Python function section to [[Working with PostgreSQL]] at the bottom of the page.
Ran FDA Trial data ripping again, as the text output files were wiped. Plan on discussing with Julia and Meghana again about pulling universities and other relevant institutions from the Assignee List USA. Talked to Sonia about pulling city, state, zipcode information, hence python was installed in a database. Will work with Sonia on Wednesday afternoon and see how best a regex function could be implemented
3/8/2017 WEDNESDAY 9AM-12PM
Output sql tables from finished run of Jeemin_FDATrial_as_key_data_ripping.py
Ran through assigneelist_USA.txt to see how many different ways UNIVERSITY could be spelled wrong. There were many.
Tried to logic through creating a pattern that could catch all different versions of UNIVERSITY. Discuss further on whether UNIVERSITIES and those that include UNIVERSITIES but include INC in the end should be pulled as relevant information
