Clinical Trials Loading: Difference between revisions

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:/...")
 
No edit summary
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: