WebMD Drug Reviews Dataset
Dataset of user reviews on various drugs
@kaggle.rohanharode07_webmd_drug_reviews_dataset
Webmd
@kaggle.rohanharode07_webmd_drug_reviews_dataset.webmd
- 61.66 MB
- 362806 rows
- 12 columns
ageAge | conditionCondition | dateDate | drugDrug | drugidDrugId | easeofuseEaseofUse | effectivenessEffectiveness | reviewsReviews | satisfactionSatisfaction | sexSex | sidesSides | usefulcountUsefulCount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 75 or over | Stuffy Nose | Sun Sep 21 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | 25dph-7.5peh | 146724 | 5 | 5 | I'm a retired physician and of all the meds I have tried for my allergies (seasonal and not) - this one is the most effective for me. When I first began using this drug some years ago - tiredness as a problem but is not currently. | 5 | Male | Drowsiness, dizziness , dry mouth /nose/throat, headache , upset stomach , constipation , or trouble sleeping may occur. | |
| 25-34 | Cold Symptoms | Thu Jan 13 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 25dph-7.5peh | 146724 | 5 | 5 | cleared me right up even with my throat hurting it went away after taking the medicine | 5 | Female | Drowsiness, dizziness , dry mouth /nose/throat, headache , upset stomach , constipation , or trouble sleeping may occur. | 1 |
| 65-74 | Other | Mon Jul 16 2012 00:00:00 GMT+0000 (Coordinated Universal Time) | warfarin (bulk) 100 % powder | 144731 | 2 | 3 | why did my PTINR go from a normal of 2.5 to over 100? | 3 | Female | ||
| 75 or over | Other | Thu Sep 23 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | warfarin (bulk) 100 % powder | 144731 | 2 | 2 | FALLING AND DON'T REALISE IT | 1 | Female | ||
| 35-44 | Other | Tue Jan 06 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | warfarin (bulk) 100 % powder | 144731 | 1 | 1 | My grandfather was prescribed this medication (Coumadin) to assist in blood thinning due to a heart and thyroid condition. His primary doctor was aware that he was on an aspirin regiment and still prescribed this medicine, it caused his blood to thin out to much and he ended up internally bleeding … | 1 | Male | 1 | |
| 55-64 | Other | Sat Jul 19 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | warfarin (bulk) 100 % powder | 144731 | 4 | 4 | help heart condition operation well | 4 | Male | ||
| 25-34 | Birth Control | Thu Jun 15 2017 00:00:00 GMT+0000 (Coordinated Universal Time) | wymzya fe | 163180 | 5 | 5 | Haven't gotten pregnant so it does it's job. I was switched to this brand from another generic. I get nauseous and generally feel tired on this, also more headaches. | 2 | Female | Nausea , vomiting , headache , bloating , breast tenderness, swelling of the ankles /feet (fluid retention), or weight change may occur. | |
| 45-54 | Disease of Ovaries with Cysts | Mon Jan 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time) | wymzya fe | 163180 | 5 | 5 | I have take this for 5 years age 45-50 to prevent ovarian cysts (I had 2 burst). Now stopped because of age. No side effects. | 5 | Female | Nausea , vomiting , headache , bloating , breast tenderness, swelling of the ankles /feet (fluid retention), or weight change may occur. | |
| 25-34 | Acne | Wed Apr 27 2016 00:00:00 GMT+0000 (Coordinated Universal Time) | wymzya fe | 163180 | 4 | 2 | 2 | Female | Nausea , vomiting , headache , bloating , breast tenderness, swelling of the ankles /feet (fluid retention), or weight change may occur. | 1 | |
| 55-64 | Stuffy Nose | Mon Oct 29 2012 00:00:00 GMT+0000 (Coordinated Universal Time) | 12 hour nasal relief spray, non-aerosol | 9800 | 4 | 2 | The 12 hour spray only works for me for 6 hours. | 2 | Male | Temporary burning, stinging, dryness in the nose, runny nose , and sneezing may occur. |
CREATE TABLE webmd (
"age" VARCHAR,
"condition" VARCHAR,
"date" TIMESTAMP,
"drug" VARCHAR,
"drugid" BIGINT,
"easeofuse" BIGINT,
"effectiveness" BIGINT,
"reviews" VARCHAR,
"satisfaction" BIGINT,
"sex" VARCHAR,
"sides" VARCHAR,
"usefulcount" BIGINT
);