Repository for MySQL database building code
Steps:
-
Download raw clinical data from ClinCapture and save it to local as "CSV_Patient_data.csv"
-
Run "clinic_info.ipynb" to split raw data into four csvs "enroll.csv","imaging_visit.csv","imaging_visit2.csv", and "30fu.scv"
-
Run "connect_enroll.ipynb"
-
Run "Connect_imaging_visit.ipynb"
-
Run "Connect_imaging_visit2.ipynb"
-
Run "Connect_30d.ipynb"
-
Run "codebook.ipynb", get codebook.csv as result
-
Convert "codebook.csv" as "codebook.txt" using tab delimited
-
Run "create_table_codebook.ipynb"
-
Import software data into Mysql using "Dump20150529.sql", this sql file should be updated periodically
-
Run "connect_softwaredataipynb"
P.S All csv files mentioned above can be found in folder "Input_csv"