11000 Medicine Details

11000 Medicine details web scrapped from 1mg

@kaggle.singhnavjot2062001_11000_medicine_details

Table List

1 table(755.77 KB)

Medicine Details

@kaggle.singhnavjot2062001_11000_medicine_details.medicine_details

755.77 KB
11825 rows
9 columns

medicine_name Medicine Name	composition Composition	uses Uses	side_effects Side Effects	image_url Image URL	manufacturer Manufacturer	excellent_review Excellent Review %	average_review Average Review %	poor_review Poor Review %
Avastin 400mg Injection	Bevacizumab (400mg)	Cancer of colon and rectum Non-small cell lung cancer Kidney cancer Brain tumor Ovarian cancer Cervical cancer	Rectal bleeding Taste change Headache Nosebleeds Back pain Dry skin High blood pressure Protein in urine Inflammation of the nose	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/f5a26c491e4d48199ab116a69a969be3.jpg	Roche Products India Pvt Ltd	22	56	22
Augmentin 625 Duo Tablet	Amoxycillin (500mg) + Clavulanic Acid (125mg)	Treatment of Bacterial infections	Vomiting Nausea Diarrhea Mucocutaneous candidiasis	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/wy2y9bdipmh6rgkrj0zm.jpg	Glaxo SmithKline Pharmaceuticals Ltd	47	35	18
Azithral 500 Tablet	Azithromycin (500mg)	Treatment of Bacterial infections	Nausea Abdominal pain Diarrhea	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/cropped/kqkouvaqejbyk47dvjfu.jpg	Alembic Pharmaceuticals Ltd	39	40	21
Ascoril LS Syrup	Ambroxol (30mg/5ml) + Levosalbutamol (1mg/5ml) + Guaifenesin (50mg/5ml)	Treatment of Cough with mucus	Nausea Vomiting Diarrhea Upset stomach Stomach pain Allergic reaction Dizziness Headache Rash Hives Tremors Palpitations Muscle cramp Increased heart rate	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/3205599cc49d4073ae66cbb0dbfded86.jpg	Glenmark Pharmaceuticals Ltd	24	41	35
Aciloc 150 Tablet	Ranitidine (150mg)	Treatment of Gastroesophageal reflux disease (Acid reflux)Treatment of Peptic ulcer disease	Headache Diarrhea Gastrointestinal disturbance	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/cropped/pn7apngctvrtweencwi1.jpg	Cadila Pharmaceuticals Ltd	34	37	29
Allegra 120mg Tablet	Fexofenadine (120mg)	Treatment of Sneezing and runny nose due to allergiesTreatment of Allergic conditions	Headache Drowsiness Dizziness Nausea	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/fa7427131ec64163b5bbafb529df0736.jpg	Sanofi India Ltd	35	42	23
Avil 25 Tablet	Pheniramine (25mg)	Treatment of Allergic conditionsTreatment of Respiratory disease with excessive mucusTreatment of Skin conditions with inflammation & itchingTreatment and prevention of Meniere's disease	Sedation	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/cropped/mmsye6bf97tkcocat24j.jpg	Sanofi India Ltd	40	34	26
Aricep 5 Tablet	Donepezil (5mg)	Alzheimer's disease	Common cold Urinary incontinence Rash Nausea Diarrhea Insomnia difficulty in sleeping Weight loss Accidental injury	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/d7ojjdaw2gsm5sie1glu.jpg	Eisai Pharmaceuticals India Pvt Ltd	43	28	29
Amoxyclav 625 Tablet	Amoxycillin (500mg) + Clavulanic Acid (125mg)	Treatment of Bacterial infections	Vomiting Nausea Diarrhea Mucocutaneous candidiasis	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/acaa6608e016456f9cafcca2156ad3de.jpg	Abbott	36	43	21
Atarax 25mg Tablet	Hydroxyzine (25mg)	Treatment of AnxietyTreatment of Skin conditions with inflammation & itching	Sedation Nausea Vomiting Upset stomach Constipation	https://onemg.gumlet.io/l_watermark_346,w_480,h_480/a_ignore,w_480,h_480,c_fit,q_auto,f_auto/cropped/v9py58kciridvbi7bqls.jpg	Dr Reddy's Laboratories Ltd	35	41	24


CREATE TABLE medicine_details (
  "medicine_name" VARCHAR,
  "composition" VARCHAR,
  "uses" VARCHAR,
  "side_effects" VARCHAR,
  "image_url" VARCHAR,
  "manufacturer" VARCHAR,
  "excellent_review" BIGINT,
  "average_review" BIGINT,
  "poor_review" BIGINT
);