def loadTrainData(self): print('loadTrainData') df = pd.read_csv('../Dataset/TrainData.csv') df.drop(['Unnamed: 0'], axis=1, inplace=True) from Model.TableModel import pandasModel model = pandasModel(df) print('hi') self.tableView_train.setModel(model)
def browseFile(self): filename = QFileDialog.getOpenFileName() path = filename[0] print(path) df = pd.read_csv(path) global test_df test_df= df df.drop(['Unnamed: 0'], axis=1, inplace=True) from Model.TableModel import pandasModel model = pandasModel(df) self.tableView_test.setModel(model)
def showDoctorList(self): try: department = self.comboBox_department_2.currentText() specialization = self.comboBox_specialization_2.currentText() df = pd.read_csv('../dataset/doctor_info_table.csv') data = df[(df['department']==department)&(df['specialization']==specialization)] from Model.TableModel import pandasModel model = pandasModel(data) self.tableView_doctor_list.setModel(model) except Exception as e: print('showDoctorList Error:',str(e))
def showPatientInfoTable(self): try: patientName = self.comboBox_patientName.currentText() if patientName != "Choose Patient": df = pd.read_csv('../dataset/patient_info_table.csv') patientId = df[df['name']==patientName].patient_id.iloc[0] global patient_id patient_id = patientId medical_df = pd.read_csv('../dataset/patient_medical_info.csv') medical_data = medical_df[(medical_df['patient_id']==patientId)&(medical_df['doctor_id']==self.id)][['id','patient_id','diseases','medication','list_of_medicine','date']] from Model.TableModel import pandasModel model = pandasModel(medical_data) self.tableView_patient_list.setModel(model) except Exception as e: print('showPatientInfoTabel Error:',str(e))