Clinical Trials Loading

From DISI
Revision as of 19:03, 24 August 2017 by Enkhjargal (talk | contribs)
Jump to navigation Jump to search
1. Relevant Files:
   /nfs/db/trials/important --> clinical trials raw data 
   /nfs/home/teague/work/Projects/trials/extract.py --> script to clean the raw data
   http://wiki.docking.org/index.php/Creating_clinical_name_mappings --> how to create name_mappings
2. SQL queries to create a new clinical trial schema and table are located in zinc code:
   SQL_statement/clinical_trial
3. To load the data from raw data: