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))