-
Notifications
You must be signed in to change notification settings - Fork 2
/
Med_Repository.py
36 lines (26 loc) · 1.24 KB
/
Med_Repository.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
import pandas as pd
## Import os if using join to bring in file ##
import os
## Specify the file path to define excel_file_path ##
excel_file_path = r'C:\Users\Carter\Documents\GitHub\MedInfoPro\Data\Medicine_description.xlsx'
## Read the Excel file into a Pandas DataFrame ##
df = pd.read_excel(excel_file_path)
print(df)
### Now that the data set works and is defined as 'excel_file_path' we can upload the repository for the GUI ###
from Medication import Medication
class MedicationRepository:
def __init__(self) -> None:
self.__med_list = []
self.__db = pd.read_excel(excel_file_path)
## define functions for interface ##
def __init__(self, excel_file_path):
# Load the Excel dataset into a pandas DataFrame
self.medication_data = pd.read_excel(excel_file_path)
def get_medication_info(self, medication_name):
# Retrieve information from the DataFrame based on the medication name
medication_info = self.medication_data.loc[
self.medication_data['Medication Name'] == medication_name, 'Information'].values
if len(medication_info) > 0:
return medication_info[0]
else:
return "Information not available for this medication."