Also known as "Cost-effective Digital Prescription using Pharmaceutical Knowledge Graph" is a AranongoDB-based knowledge graph containing comprehensive medication data. When provided with a prescription, the system efficiently analyzes the medicines and suggests reliable, cost-effective alternatives.
-
For instance, if the initial prescription costs 900 rupees for three medicines priced at 300 rupees each, the software identifies trustworthy substitutes priced at 100 rupees each, totaling 300 rupees. This results in substantial savings of 600 rupees for the user, maintaining reliability while significantly cutting costs.
-
This is a group project made during internship at AICOE JIO by Aryan Rathore and Reva Bharara under the careful guidance of our mentor Mr. Krishna Kumar Tiwari (head of knowledge graph platform at AICOE JIO platforms limited)
-
This project is proof of concept and is at a prototyping phase
Having witnessed the financial strain caused by my father's battle with bone TB and the ensuing ICU expenses, I was motivated to create this project. We aim to help families in similar situations by providing cost-effective healthcare solutions. This software uses a medicine database to offer affordable alternatives, aiming to ease the financial burden while ensuring quality care for those facing substantial medical expenses.
- Our work has been successfully been accepted and published in Asian Journal of Research in Computer Science
- A PDF of the published paper has been attached on github and links are attached below
- https://www.researchgate.net/publication/376431111_Cost-effective_Digital_Prescription_using_Pharmaceutical_Knowledge_Graph
- https://journalajrcos.com/index.php/AJRCOS/article/view/395
- DOI- 10.9734/ajrcos/2023/v16i4395
-
The original prescription was Rs.2577 but GraphPrescribe found an alternative prescription of Rs.114 saving 2463 Rs/-
The original medicines was Rs.103 but GraphPrescribe found an alternative medicines named Ascoril LS Syrup which Rs.97 saving 6 Rs/-
- The blog series attached is a 3-part series also made in our JIO internship. this will familiarize you with the concepts needed to understand the approach of this project.
- https://medium.com/everythingisconnected
- This csv contains all the info of the medicines.
- This dataset has 38074 rows where each row represents one medicine.
# | Column | Non-Null Count | Dtype |
---|---|---|---|
0 | name | 38074 non-null | object |
1 | manufacturer | 38074 non-null | object |
2 | chemicals | 38074 non-null | object |
3 | uses | 38074 non-null | object |
4 | side_effects | 38074 non-null | object |
5 | Habit Forming | 38074 non-null | object |
6 | Therapeutic Class | 38074 non-null | object |
7 | Chemical Class | 38074 non-null | object |
8 | Action Class | 38074 non-null | object |
9 | MRP | 38074 non-null | int64 |
-
Objective: The primary goal of this notebook is to execute web-scraping procedures on publicly accessible medicine websites.
-
Data Collection: Utilize web-scraping techniques to extract relevant data from diverse public medicine websites.
-
Dataset Creation: Compile the extracted information into a comprehensive medicine dataset.
-
Saved Dataset: The Compile data was stored in the a_to_z_medicine_data_web_scraping.csv
-
Objective: This notebook aims to conduct Preliminary, Exploratory data analysis and extract meaningful insights from the gathered medicine dataset before integrating it into the knowledge graph.
-
The insights have been attached above.
-
Objective: The primary objective of this notebook is to construct a knowledge graph of medicines. This graph will serve the purpose of identifying medicine replacements and uncovering hidden insights within the dataset
-
Data Acquisition: Read data from the "a_to_z_medicine_data_web_scraping.csv" file containing medicine information.
-
Database Setup: Create the "drug_repurposing_3" database on ArangoDB and upload columns as collections.
-
Graph Construction: Construct edge collections and upload the remaining dataset, organizing them as edges in the knowledge graph.
- Objective: given a prescription of medicines find alternative medicines that are lower in cost and show the comparision graph
- TO DO: add proper GUI to this code
- The project as of now is just a proof of concept so i does not has proper website or GUI.
- Only 38k~ medicines have been added for this to be functional we will need to add more medicines
- Special filters for paitents with medical conditions like sugar, BP or pregnancy need to be added
- Make a project of the idea rather than a proof of concept.
- 🧑🏫 Krishna Kumar Tiwari
- email: krishna.tiwari@ril.com
- LinkedIn : https://www.linkedin.com/in/agentkk/
- 👨Aryan Rathore
- LinkedIn : https://www.linkedin.com/in/aryan-rathore-b15459215/
- email: aryanrathore13572002@gmail.com, aryan.rathore2021@vitbhopal.ac.in
- 👩 Reva Bharara
- email: bhararareva@gmail.com, revabharara@gmail.com
- LinkedIn : https://www.linkedin.com/in/reva-bharara-a83a78241/