def edit_data(self):
table = "neo_adjuvant_therapy"
enter = sql.review_data(self.conn, self.cursor, table,
self.file_number, names(table))
if enter:
sql.delete_rows(self.cursor, 'nact_drug_table', "file_number",
self.file_number)
sql.delete_rows(self.cursor, 'nact_tox_table', "file_number",
self.file_number)
data = self.nact_test()
data_sql, drug_table, tox_response = data
sql.update_multiple(self.conn, self.cursor, table, names(table),
self.file_number, data_sql)
drug_table.to_sql("nact_drug_table",
self.conn,
index=False,
if_exists="append")
tox_response.to_sql("nact_tox_table",
self.conn,
index=False,
if_exists="append")
print("clip information")
module = "clip_information"
col_list = names(module)
enter = sql.review_data(self.conn, self.cursor, table,
self.file_number, col_list)
if enter:
data = self.clip_information()
sql.update_multiple(self.conn, self.cursor, table, col_list,
self.file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "surgery_seport"
print("Surgery Information")
col_list = names("surgery_information")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = surgery_information(file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("Node Excision")
col_list = names("node_excision")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = node_excision(file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("Post-Surgery management")
col_list = names("post_surgery")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = post_surgery(file_number, user_name)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "Radiology"
print("Mammography")
col_list = names("mammography")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = mammography(file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("Automated Breast Volume Scan")
col_list = names("abvs")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = abvs(file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("Sono-Mammography")
col_list = names("sonomammo")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = sonomammo(file_number, user_name)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("MRI Breast")
col_list = names("mri_breast")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = mri_breast(file_number, user_name)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "Neo_Adjuvant_Therapy"
enter = review_data(conn, cursor, table, file_number, names(table))
if enter:
delete_rows(cursor, 'NACT_Drug_Table', "File_number", file_number)
delete_rows(cursor, 'NACT_Tox_table', "File_number", file_number)
data = nact_test(file_number, user_name)
data_sql, drug_table, tox_response = data
update_multiple(conn, cursor, table, names(table), file_number,
data_sql)
drug_table.to_sql("NACT_Drug_Table",
conn,
index=False,
if_exists="append")
tox_response.to_sql("NACT_Tox_table",
conn,
index=False,
if_exists="append")
print("Clip Information")
module = "clip_information"
col_list = names(module)
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data = clip_information(file_number)
update_multiple(conn, cursor, table, col_list, file_number, data)
def edit_data(self):
print("Block Report information")
col_list = names("biopsy_report_info")
enter = sql.review_data(self.conn, self.cursor, self.table, self.file_number, col_list)
if enter:
data = BiopsyData.biopsy_report_info(self)
sql.update_multiple(self.conn, self.cursor, self.table, col_list, self.file_number, data)
print("Tumour Biopsy data")
col_list = names("tumour_biopsy_data")
enter = sql.review_data(self.conn, self.cursor, self.table, self.file_number, col_list)
if enter:
data = BiopsyData.tumour_biopsy_data(self)
sql.update_multiple(self.conn, self.cursor, self.table, col_list, self.file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "radiology"
print("Mammography")
col_list = names("mammography")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
tables = ['Calcification_Mammography', 'Mammography_Multiple_Mass']
for i in tables:
add_update_sql.delete_multiple(cursor, i, file_number)
data = mammography(conn, cursor, file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("3D-Tomosynthesis")
col_list = names("tomosynthesis")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = tomosynthesis(file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("Automated Breast Volume Scan")
col_list = names("abvs")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = abvs(file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("Sono-Mammography")
col_list = names("sonomammo")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
add_update_sql.delete_multiple(cursor,
'SonnoMammography_Multiple_Mass',
file_number)
data = sonomammo(conn, cursor, file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("MRI Breast")
col_list = names("mri_breast")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
add_update_sql.delete_multiple(cursor, 'MRI_Multiple_Mass',
file_number)
data = mri_breast(conn, cursor, file_number, user_name)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "hormonetherapy_survival"
print("Hormone Therapy Details")
col_list = names.names_longterm(module_name="hormone")
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data = hormone(file_number)
update_multiple(conn, cursor, table, col_list, file_number, data)
print("Recurrence and follow-up status")
col_list = names.names_longterm(module_name="metastasis")
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data = metastasis(file_number, user_name)
update_multiple(conn, cursor, table, col_list, file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "Radiotherapy"
col_list = names.names_radiation()
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data = radiation(file_number, user_name)
update_multiple(conn, cursor, table, col_list, file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "clinical_exam"
print("Initial Clinical Examination")
col_list = pccm_names.name_clinical("clinical_exam_initial")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = clinical_exam_initial(file_number, user_name)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
print("Nipple Cytology")
col_list = pccm_names.name_clinical("nipple_cytology")
enter = add_update_sql.review_data(conn, cursor, table, file_number,
col_list)
if enter:
data = nipple_cytology(file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list,
file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "patient_information_history"
print("Patient Biographical Information")
col_list = pccm_names.names_info("bio_info")
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data = bio_info(file_number)
update_multiple(conn, cursor, table, col_list, file_number, data)
col_list = pccm_names.names_info("phys_act") + pccm_names.names_info(
"habits") + pccm_names.names_info("nut_supplements")
print("Patient habits")
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data_phys = phys_act(conn, cursor, file_number)
data_hab = habits(file_number)
data_nut = nut_supplements(conn, cursor, file_number)
data = data_phys + data_hab + data_nut
update_multiple(conn, cursor, table, col_list, file_number, data)
print("Patient family and reproductive details")
col_list = pccm_names.names_info("family_details")
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data = family_details(conn, cursor, file_number)
update_multiple(conn, cursor, table, col_list, file_number, data)
print("Patient and family medical history")
col_list = pccm_names.names_info("med_history") + pccm_names.names_info(
"cancer_history") + pccm_names.names_info("family_cancer")
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data_med = med_history(conn, cursor, file_number)
data_can = cancer_history(conn, cursor, file_number)
data_fam = family_cancer(conn, cursor, file_number)
data = data_med + data_can + data_fam
update_multiple(conn, cursor, table, col_list, file_number, data)
print("Patient Symptoms")
col_list = pccm_names.names_info("det_by") + pccm_names.names_info(
"breast_symptoms")
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data_det = det_by(file_number)
data_symp = breast_symptoms(file_number, user_name)
data = data_det + data_symp
update_multiple(conn, cursor, table, col_list, file_number, data)
print_info(cursor, file_number)
def edit_data(conn, cursor, file_number, user_name):
table = "Clinical_Exam"
print("Initial Clinical Examination")
col_list = pccm_names.name_clinical("clinical_exam_initial")
enter = add_update_sql.review_data(conn, cursor, table, file_number, col_list)
if enter:
data = clinical_exam_initial(file_number, user_name)
add_update_sql.update_multiple(conn, cursor, table, col_list, file_number, data)
print("Nipple Cytology")
col_list = pccm_names.name_clinical("nipple_cytology")
enter = add_update_sql.review_data(conn, cursor, table, file_number, col_list)
if enter:
data = nipple_cytology(file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list, file_number, data)
print("Other Tests (USG Abdomen, PET Scan, Bone Scan, CECT Abdomen and Thorax)")
col_list = pccm_names.name_clinical("other_test")
enter = add_update_sql.review_data(conn, cursor, table, file_number, col_list)
if enter:
data = other_test(file_number)
add_update_sql.update_multiple(conn, cursor, table, col_list, file_number, data)
def edit_data(self):
print("Surgery Block information")
col_list = names(self.module_list[0])
enter = sql.review_data(self.conn, self.cursor, self.table,
self.file_number, col_list)
if enter:
data = SurgeryBlockData.surgery_block_information_1(self)
sql.update_multiple(self.conn, self.cursor, self.table, col_list,
self.file_number, data)
print("Surgery Block information (Tumour Details)")
col_list = names(self.module_list[1])
enter = sql.review_data(self.conn, self.cursor, self.table,
self.file_number, col_list)
if enter:
sql.delete_rows(self.cursor, 'block_data', "file_number",
self.file_number)
data, block_data_df = SurgeryBlockData.surgery_block_information_2(
self)
sql.update_multiple(self.conn, self.cursor, self.table, col_list,
self.file_number, data)
block_data_df.to_sql("block_data",
self.conn,
index=False,
if_exists="append")
print("Surgery Block information (Node Details)")
col_list = names(self.module_list[2])
enter = sql.review_data(self.conn, self.cursor, self.table,
self.file_number, col_list)
if enter:
data = SurgeryBlockData.surgery_block_information_3(self)
sql.update_multiple(self.conn, self.cursor, self.table, col_list,
self.file_number, data)
print("Pathological Stage")
col_list = names(self.module_list[3])
enter = sql.review_data(self.conn, self.cursor, self.table,
self.file_number, col_list)
if enter:
data = SurgeryBlockData.path_stage(self)
sql.update_multiple(self.conn, self.cursor, self.table, col_list,
self.file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "Adjuvant_ChemoTherapy"
enter = review_data(conn, cursor, table, file_number, names(table))
if enter:
delete_rows(cursor, 'Chemo_Drug_Table', "File_number", file_number)
delete_rows(cursor, 'Chemo_Tox_table', "File_number", file_number)
data = chemotherapy(file_number, user_name)
data_sql, drug_table, tox_response = data
update_multiple(conn, cursor, table, names(table), file_number,
data_sql)
drug_table.to_sql("Chemo_Drug_Table",
conn,
index=False,
if_exists="append")
tox_response.to_sql("Chemo_Tox_table",
conn,
index=False,
if_exists="append")
def edit_data(self):
table = "patient_information_history"
print("Patient Biographical Information")
col_list = pccm_names.names_info("bio_info")
enter = review_data(self.conn, self.cursor, table, self.file_number,
col_list)
if enter:
data = self.bio_info()
update_multiple(self.conn, self.cursor, table, col_list,
self.file_number, data)
col_list = pccm_names.names_info("phys_act") + pccm_names.names_info(
"habits") + pccm_names.names_info("nut_supplements")
print("Patient habits")
enter = review_data(self.conn, self.cursor, table, self.file_number,
col_list)
if enter:
data_phys = self.phys_act()
data_hab = self.habits()
data_nut = self.nut_supplements()
data = data_phys + data_hab + data_nut
update_multiple(self.conn, self.cursor, table, col_list,
self.file_number, data)
print("Patient family and reproductive details")
col_list = pccm_names.names_info("family_details")
enter = review_data(self.conn, self.cursor, table, self.file_number,
col_list)
if enter:
data = self.family_details()
update_multiple(self.conn, self.cursor, table, col_list,
self.file_number, data)
print("Patient medical history")
col_list = pccm_names.names_info(
"med_history") + pccm_names.names_info("cancer_history")
enter = review_data(self.conn, self.cursor, table, self.file_number,
col_list)
if enter:
data_med = self.med_history()
data_can = self.cancer_history()
data = data_med + data_can
update_multiple(self.conn, self.cursor, table, col_list,
self.file_number, data)
print("Patient Family Cancer History")
col_list = pccm_names.names_info("family_cancer")
enter = review_data(self.conn, self.cursor, table, self.file_number,
col_list)
if enter:
data_fam = self.family_cancer()
update_multiple(self.conn, self.cursor, table, col_list,
self.file_number, data_fam)
print("Patient Symptoms")
col_list = pccm_names.names_info("det_by") + pccm_names.names_info(
"breast_symptoms")
enter = review_data(self.conn, self.cursor, table, self.file_number,
col_list)
if enter:
data_det = self.det_by()
data_symp = self.breast_symptoms()
data = data_det + data_symp
update_multiple(self.conn, self.cursor, table, col_list,
self.file_number, data)
print('Other tests for diagnosis/metastatic checkup')
col_list = pccm_names.names_info('other_test')
enter = review_data(self.conn, self.cursor, table, self.file_number,
col_list)
if enter:
data = self.other_test()
update_multiple(self.conn, self.cursor, table,
pccm_names.names_info("other_test"),
self.file_number, data)
def nact_regime(file_number, user_name):
col_drug = names("NACT_Drug_per_week")
drug_per_week = pd.DataFrame(columns=col_drug)
col_cycle_all = names("NACT_Drug_Cycle")
data_per_cycle = pd.DataFrame(columns=col_cycle_all)
col_drug_response = names("NACT_Toxicity")
tox_response_all = pd.DataFrame(columns=col_drug_response)
check = False
while not check:
nact = ask_y_n_statement.ask_y_n("Has neo adjuvant therapy been done for the patient?")
if nact:
nact = "Neo Adjuvant therapy given"
place_nact = ask_y_n_statement.ask_y_n_na("Has Chemotherapy been done at PCCM?", "At PCCM", "Outside",
"Not Certain, requires follow-up")
details_nact = ask_y_n_statement.ask_y_n("Are Chemotherapy details available?", "Details Available",
"Details to be taken from patient")
if details_nact == "Details Available":
date_nact = input("Date of starting neo-adjuvant therapy: ")
plan_nact = input("Type of NACT plan: ")
cycle_number, week_number = (1,)*2
week_end, cycle_index, week_index, drug_index = (0,)*4
add_cycle = True
while add_cycle:
check_cycle = False
while not check_cycle:
cyc_name = "Cycle " + str(cycle_number)
print(cyc_name)
week_add = True
while week_add:
check_drug_tox = False
while not check_drug_tox:
week = "Week " + str(week_number)
print(week)
week_check = ask_y_n_statement.ask_y_n("Is week correct?")
if not week_check:
week_number = input("Week number? ")
week_number = int(week_number)
week = "Week " + str(week_number)
patient_wt = input("Patient weight (in kg): ")
drug_per_week, drug_cyc = drug_add(file_number, cyc_name, cycle_number, week, patient_wt, drug_per_week, drug_index)
tox_response = chemo.tox_table(file_number, cyc_name, week, drug_cyc)
tox_grade, tox, tox_treatment, tox_response = tox_response
change_tox = ask_y_n_statement.ask_option("Changes to NACT treatment due to toxicity",
["No change", "NACT regime changed", "NACT stopped"])
if change_tox =="NACT regime changed":
change = input("Please describe changes to NACT regime: ")
change_tox = change_tox+": "+change
data_tox_response = [file_number, cycle_number, week, "/".join(drug_cyc), tox, tox_grade, tox_treatment,
tox_response, change_tox]
tox_response_all.loc[week_index] = data_tox_response
check_drug_tox = review_df(tox_response_all.loc[week_index])
week_number = week_number + 1
week_index = week_index + 1
week_add = ask_y_n_statement.ask_y_n("Add another week to " + cyc_name + " ?")
patient_wt_end_cycle = patient_wt
drug_cycle = drug_per_week.query('Cycle_number==' + str(cycle_number))
tox_cycle = tox_response_all.query('Cycle_number==' + str(cycle_number))
data_cycle, drug_dose = chemo.get_cycle_data(drug_cycle, tox_cycle)
drug_week, tox_week, tox_grade_week, tox_treatment_week, tox_response_week, change_tox_week \
= data_cycle
response_check = ask_y_n_statement.ask_option("Method used to check response to NACT in this cycle",
["Response not checked", "Other"])
if response_check != "Response not checked":
response_nact = ask_y_n_statement.ask_option("Tumour response to NACT treatment",
response_nact = ask_y_n_statement.ask_option("Tumour response to NACT treatment",
["Partial", "Complete", "Progressing", "Static",
"Other"])
response_size = input("Tumour Size as assessed by " + response_check+" (cm): ")
date = input("Date of tumour size assessment: ")
else:
response_nact, response_size, date = ("NA", )*3
week_end = week_number - week_end -1
weeks = str(week_end)+" Weeks"
data_cycle_all = [file_number, cyc_name, weeks, patient_wt_end_cycle, drug_week, tox_week, tox_grade_week,
tox_treatment_week, tox_response_week, change_tox_week, drug_dose, response_check,
response_nact, response_size, date]
data_per_cycle.loc[cycle_index] = data_cycle_all
check_cycle = review_df(data_per_cycle.loc[cycle_index])
cycle_number = cycle_number + 1
cycle_index = cycle_index + 1
add_cycle = ask_y_n_statement.ask_y_n("Add another cycle? ")
trast_nact = ask_y_n_statement.ask_y_n("Trastuzumab used?")
if trast_nact:
trast_regime = ask_y_n_statement.ask_option("Trastuzumab use was", ["Sequential", "Concurrent"])
trast_nact = "Trastuzumab used"
trast_courses = input("Number of courses of trastuzumab/herceptin taken: ")
else:
trast_nact = "Trastuzumab not used"
trast_regime, trast_courses = ("NA",)*2
date_complete = input("Date of completion of NACT")
complete_nact = ask_y_n_statement.ask_y_n("Was NACT completed as per schedule?")
if complete_nact:
reason_incomplete = "NACT completed as per schedule"
else:
reason_incomplete = ask_y_n_statement.ask_option("Reason for discontinuation", ["Toxicity",
"Reluctance of patient", "Progression on chemotherapy", "Advised by treating doctor",
"Death due to toxicity", "Death due to progressive disease", "Preferred treatment at another centre",
"Death due to unrelated cause", "Patient was unable to afford treatment"])
reason_incomplete = "NACT incomplete: "+reason_incomplete
number_cycles = data_per_cycle.shape[0]
number_weeks = week_number -1
drug_dose = []
drug_dose_unit_df = drug_per_week.loc[:,("Drugs", "Dose_unit")].drop_duplicates()
for index in range(1, 2):
dose_ = drug_per_week.loc[:, ("Drugs", "Dose")]
dose_sum_cycle = dose_.groupby("Drugs").sum()
for index in range(0, len(list(dose_sum_cycle.index))):
dose_unit_ = list(drug_dose_unit_df.loc[:, "Dose_unit"])[index]
data = list(dose_sum_cycle.index)[index] + ": " + str(
list(dose_sum_cycle.loc[:, "Dose"])[index]) + " " + dose_unit_
drug_dose.append(data)
drug_admin = "; ".join(drug_dose)
hormone_therapy = ask_y_n_statement.ask_y_n("Was hormone therapy given?")
if hormone_therapy:
hormone_therapy = "Hormone therapy given"
therapy_type = ask_y_n_statement.ask_option("Hormone therapy type", ["Sequential", "Concurrent"])
therapy_duration = input("What was the duration of therapy? ")
therapy_side = ask_y_n_statement.ask_y_n("Were any side effects observed ?")
if therapy_side:
therapy_side = input("Please give details of side effects observed: ")
else:
therapy_side = "NA"
else:
hormone_therapy = "No hormone therapy given"
therapy_type, therapy_duration, therapy_side = ("NA", )*3
else:
date_nact, plan_nact, drug_admin, number_weeks, number_cycles, response_check, response_nact, response_size, \
date, reason_incomplete, date_complete, trast_nact, trast_regime, trast_courses, \
hormone_therapy, therapy_type, therapy_duration, therapy_side = ("Details to be taken from patient",) * 18
else:
nact = "No NeoAdjuvant Therapy given"
date_nact, plan_nact, drug_admin, number_weeks, number_cycles, response_check, response_nact, response_size, \
date, reason_incomplete, date_complete, trast_nact, trast_regime, trast_courses, \
hormone_therapy, therapy_type, therapy_duration, therapy_side, place_nact, details_nact = \
("No NeoAdjuvant Therapy given",)*20
last_update = datetime.now().strftime("%Y-%b-%d %H:%M")
data_list = [nact, date_nact, plan_nact, drug_admin,str(number_weeks), str(number_cycles),
response_check, response_nact, response_size, date, reason_incomplete, date_complete,
trast_nact, trast_regime, trast_courses, hormone_therapy, therapy_type, therapy_duration,
therapy_side, user_name, last_update, place_nact, details_nact]
col_list = names("Neo_Adjuvant_Therapy")
check = review_input(file_number, col_list, data_list)
return data_list, tox_response_all, drug_per_week, data_per_cycle
def clip_information(file_number):
check = False
while not check:
clip = ask_y_n_statement.ask_y_n("Was Clip inserted for surgery?")
if clip:
clip_number = input("Number of clips inserted: ")
clip_date = input("Date of clip insertion: ")
clip_cycle = input("Clip inserted after cycle? ")
else:
clip_date, clip_number, clip_cycle = ("NA", )*3
data_list = clip_number, clip_date, clip_cycle
col_list = names("clip_information")
check = review_input(file_number, col_list, data_list)
return data_list
def add_data(conn, cursor, file_number, user_name):
table = "Neo_Adjuvant_Therapy"
#file_row(cursor, file_number)
data = nact_regime(file_number, user_name)
data_sql, tox_response_all, drug_per_week, data_per_cycle = data
update_multiple(conn, cursor, table, names(table), file_number, data_sql)
tox_response_all.to_sql("NACT_Toxicity", conn, index=False, if_exists="append")
drug_per_week.to_sql("NACT_Drug_per_week", conn, index=False, if_exists="append")
data_per_cycle.to_sql("NACT_Drug_Cycle", conn, index=False, if_exists="append")
enter = ask_y_n_statement.ask_y_n("Input Clip Information")
if enter:
data = clip_information(file_number)
col_list = names("clip_information")
update_multiple(conn, cursor, table, col_list, file_number, data)
def edit_data(conn, cursor, file_number, user_name):
table = "Neo_Adjuvant_Therapy"
enter = review_data(conn, cursor, table, file_number, names(table))
if enter:
data = nact_regime(file_number, user_name)
data_sql, tox_response_all, drug_per_week, data_per_cycle = data
update_multiple(conn, cursor, table, names(table), file_number, data_sql)
delete_rows(cursor, 'NACT_Toxicity', "File_number", file_number)
tox_response_all.to_sql("NACT_Toxicity", conn, index=False, if_exists="append")
delete_rows(cursor, 'NACT_Drug_per_week', "File_number", file_number)
drug_per_week.to_sql("NACT_Drug_per_week", conn, index=False, if_exists="append")
delete_rows(cursor, 'NACT_Drug_Cycle', "File_number", file_number)
data_per_cycle.to_sql("NACT_Drug_Cycle", conn, index=False, if_exists="append")
print("Clip Information")
module = "clip_information"
col_list = names(module)
enter = review_data(conn, cursor, table, file_number, col_list)
if enter:
data = clip_information(file_number)
update_multiple(conn, cursor, table, col_list, file_number, data)
