Comprehensive Drug Information Dataset

The "Pharmaceutical Product Data Repository" is a comprehensive dataset.

@kaggle.anoopjohny_comprehensive_drug_information_dataset

Table List

1 table(29.69 KB)

Drugdata

@kaggle.anoopjohny_comprehensive_drug_information_dataset.drugdata

29.69 KB
220 rows
20 columns

drug_id Drug ID	drug_name Drug Name	generic_name Generic Name	drug_class Drug Class	indications Indications	dosage_form Dosage Form	strength Strength	route_of_administration Route Of Administration	mechanism_of_action Mechanism Of Action	side_effects Side Effects	contraindications Contraindications	interactions Interactions	warnings_and_precautions Warnings And Precautions	pregnancy_category Pregnancy Category	storage_conditions Storage Conditions	manufacturer Manufacturer	approval_date Approval Date	availability Availability	ndc NDC	price Price
1	Aspirin	Acetylsalicylic Acid	Analgesic	Headache	Tablet	325 mg	Oral	Inhibits prostaglandin synthesis	Stomach irritation	Allergy to NSAIDs	Anticoagulants: increased bleeding risk	Gastric ulcers: risk of bleeding	Category C	Room temperature	PharmaCorp	15-01-2022	OTC	12345678901	5.99
2	Amoxicillin	Amoxicillin	Antibiotic	Bacterial Infections	Capsule	500 mg	Oral	Inhibits bacterial cell wall synthesis	Nausea	Allergic reactions	Penicillin: reduced efficacy	Take with food to reduce stomach upset	Category B	Room temperature	MediPharm	20-11-2021	Prescription	23456789012	12.49
3	Lisinopril	Lisinopril	Antihypertensive	Hypertension	Tablet	10 mg	Oral	Blocks conversion of angiotensin I to angiotensin II	Cough	Kidney problems	Diuretics: increased risk of kidney problems	Monitor kidney function regularly	Category D	Room temperature	HealthMeds	05-03-2022	Prescription	34567890123	8.75
4	Albuterol	Albuterol	Bronchodilator	Asthma	Inhaler	100 mcg/inhalation	Inhalation	Stimulates beta-2 adrenergic receptors	Tremor	Rapid heart rate	Beta-blockers: decreased effectiveness	Use as needed for acute asthma symptoms	Category C	Room temperature	RespirePharma	10-08-2021	Prescription	45678901234	22.99
5	Omeprazole	Omeprazole	Proton Pump Inhibitor	Acid Reflux	Capsule	20 mg	Oral	Reduces stomach acid production	Headache	Abdominal pain	Clopidogrel: reduced effectiveness	Take before a meal	Category C	Room temperature	MediCare	30-05-2022	OTC	56789012345	6.25
6	Levothyroxine	Levothyroxine	Hormone	Thyroid Disorder	Tablet	50 mcg	Oral	Replaces or supplements thyroid hormone	Dizziness	Heart palpitations	Adrenal insufficiency: monitor carefully	Take on an empty stomach	Category A	Room temperature	EndoHealth	18-02-2022	Prescription	67890123456	9.99
7	Simvastatin	Simvastatin	Cholesterol-lowering	Hyperlipidemia	Tablet	20 mg	Oral	Inhibits cholesterol synthesis	Muscle pain	Liver problems	CYP3A4 inhibitors: increased risk of side effects	Avoid grapefruit juice	Category X	Room temperature	PharmaCare	05-10-2021	Prescription	78901234567	7.85
8	Metformin	Metformin	Oral Antidiabetic	Type 2 Diabetes	Tablet	1000 mg	Oral	Decreases glucose production by the liver	Diarrhea	Lactic acidosis	Kidney problems: avoid in severe impairment	Take with meals	Category B	Room temperature	DiabetesRx	22-04-2022	Prescription	89012345678	4.5
9	Ibuprofen	Ibuprofen	NSAID	Pain and Inflammation	Tablet	200 mg	Oral	Inhibits prostaglandin synthesis	Upset stomach	GI bleeding	Allergy to NSAIDs	Anticoagulants: increased bleeding risk	Category C	Room temperature	ReliefMeds	08-09-2021	OTC	90123456789	3.15
10	Ciprofloxacin	Ciprofloxacin	Fluoroquinolone	Bacterial Infections	Tablet	500 mg	Oral	Inhibits bacterial DNA synthesis	Nausea	Tendon rupture	Antacids: reduced effectiveness	Take 2 hours before or 6 hours after antacids	Category C	Room temperature	PharmaX	30-12-2021	Prescription	12345678902	18.75


CREATE TABLE drugdata (
  "drug_id" BIGINT,
  "drug_name" VARCHAR,
  "generic_name" VARCHAR,
  "drug_class" VARCHAR,
  "indications" VARCHAR,
  "dosage_form" VARCHAR,
  "strength" VARCHAR,
  "route_of_administration" VARCHAR,
  "mechanism_of_action" VARCHAR,
  "side_effects" VARCHAR,
  "contraindications" VARCHAR,
  "interactions" VARCHAR,
  "warnings_and_precautions" VARCHAR,
  "pregnancy_category" VARCHAR,
  "storage_conditions" VARCHAR,
  "manufacturer" VARCHAR,
  "approval_date" VARCHAR,
  "availability" VARCHAR,
  "ndc" BIGINT,
  "price" DOUBLE
);