Difference between revisions of "Clinical Trials Loading"

From DISI
Jump to navigation Jump to search
(Created page with " 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:/...")
 
Line 4: Line 4:
 
     http://wiki.docking.org/index.php/Creating_clinical_name_mappings --> how to create name_mappings
 
     http://wiki.docking.org/index.php/Creating_clinical_name_mappings --> how to create name_mappings
  
  2.
+
  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:

Revision as of 19:03, 24 August 2017

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: