264
edits
Changes
Jump to navigation
Jump to search
week 27-31: continue learn SQL week 3-7: if SQL fails then condense all grant files into one excel thing and do it by hand, find way to get patent stuff week 10-14: finish grant stuff then work on making the database, figure out what other data I want to pull and finish up patent stuffwhat data visualizations I want to make
no edit summary
This project revolves around examining Medical Centers and viewing their research to see how innovative it is and whether or not Medical Centers in the U.S. are using the grants and money they receive to discover and create new treatments and services. For this project, I plan on collecting data on patents, NIH and NSF grants, and clinical trial data based on zipcodes of medical centers to show how much innovation occurs in these centers. For each research dataset, I plan on finding how many of each type of event (patent, trial, grant) is filed under each zipcode. At this time, I have all the raw data for each research dataset and am going through using regular expressions, I plan on finding out how many matches I have by the end of this week (March 23). After examining these results, I will decide how to present the data and create a paper around it.
Progress report: March 23: I have all the raw data contained in my folderCatherine matched patents, grants, and clinical trials to Medical Centers. By the end of the next week, I plan She is currently working on matching putting all the data using zipcodes that I can, then deciding how to proceed afterinto a database.
Project data is in:
==Deliverables==
week 203-247: learn SQL and put all data into a database stuff
week 17-21: look at all data, make outline
