In the modern era, there's a growing interest in homeopathic medicine due to its holistic approach to healing. This project aims to analyze data related to homeopathic medicine products, including benefits, pricing, brands, ratings, and ingredients.
This project helps entrepreneurs estimate costs for a homeopathic store and select relevant products. It uses data analysis to empower informed decisions, aiming to create an interactive dashboard for cost evaluation and product selection based on benefits.
| Files/Folder | Description |
|---|---|
| Excel file | This file provides you the insights and the analysis and other files(merged_data.xlsx, medicine_details_final.xlsx, merged_data.xlsx) have the scrapped data from the 1 Mg website. |
| Python File | This contains the .ipynb file related to the web scrapping part. |
- Performed Web Scraping with the help of Python BeautifulSoup library.
-
Converted the data into dataframes with help pandas library
-
Performed Data Analysis with the help of Pandas and Excel.
1). The area in which highest medicines are sold is EYE.
2). SBL Pvt Ltd has the highest average number of ratings, i.e. ₹ 559.12, in the Hair-benefit area.
3). The brand SBL Pvt Ltd has most greater than 4-point review medicines.
4). Natrum Muriaticum in Heart key benefit area, is the most used Ingredient overall.
- The most used ingredient is Belladonna.
- The number of medicines in the benefits area Eye is highest.
- SBL Pvt Ltd has the highest average number of ratings in the Hair-benefit area.
- The brand SBL Pvt Ltd has most greater than 4-point review medicines.
- SBL Pvt Ltd and Bjain Pharmaceutical Pvt Ltd are the two brands that are used most among the benefit areas.
- The Brand SBL Pvt Ltd has the highest number of medicines of where a number of ratings is present.
- Most rated medicine is from the Eye benefit area.
- The highest number of medicine, which are rated above 3.5, is from the Eye benefit area.
- Medicines of Eye benefit area would be recommended to purchase or from the brand SBL Pvt Ltd.
- Website Ban: Faced repeated bans on the 1Mg official website during data scraping attempts.
- Google Colab Solution: Resolved the issue by migrating scraping operations to Google Colab.
- Extended Scraping Time: Extracting details of each medicine took more time than anticipated.
- Duplicate Data Issue: Encountered delays due to duplicate data in the scraping process.
- Learning Efficiency: Gained insights into optimizing scraping methods for speed and accuracy.
Despite challenges in data scraping and extended collection time, this project recommends prioritizing "Eye" benefit area medicines and considering products from SBL Pvt Ltd for a homeopathic store. The experience underscores the significance of adaptability, efficiency, and meticulous analysis in informed decision-making for the retail of homeopathic medicine.