Webmd

---
name: webmd-drug-reviews
description: >
  Query the WebMD Drug Reviews dataset (~362 k patient reviews, 2007–2020).
  Use whenever the user asks about patient-reported drug effectiveness,
  ease of use, satisfaction ratings, side effects, or reviews for a
  specific drug or medical condition.
---

# WebMD Drug Reviews Query Skill

Search patient reviews by drug name or medical condition. Auto-fallback: if no drug matches, searches conditions.

| Input Example | Match Logic |
|---|---|
| `Lipitor` | substring on `Drug` column |
| `High Blood Pressure` | substring on `Condition` column |
| any text | try `Drug` first → fall back to `Condition` |

## API

| Function | Input | Returns |
|---|---|---|
| `load_reviews(path)` | CSV path (default `DATA_PATH`) | list[dict] |
| `search(rows, entity)` | single entity string | list[dict] |
| `search_by_drug(rows, drug)` | drug name string | list[dict] |
| `search_by_condition(rows, cond)` | condition string | list[dict] |
| `search_batch(rows, entities)` | list of entity strings | dict[str, list[dict]] |
| `summarize(hits, entity)` | matched rows + label | compact text (counts, avg ratings, top conditions/drugs) |
| `to_json(hits)` | matched rows | list[dict] |

## Usage

See `if __name__ == "__main__"` block in `10_WebMD_Drug_Reviews.py` for runnable examples covering: single drug lookup, single condition lookup, batch search, and JSON output.

## Data

- **Source**: `webmd.csv` (Kaggle – rohanharode07/webmd-drug-reviews-dataset)
- **Columns**: `Drug`, `Condition`, `Reviews`, `Side`, `Age`, `Sex`, `Effectiveness`, `EaseofUse`, `Satisfaction`
- **Ratings**: 1-5 star scale for Effectiveness, EaseofUse, Satisfaction
- **Path**: `DATA_PATH` variable in `10_WebMD_Drug_Reviews.py`
  (`resources_metadata/drug_review/WebMDDrugReviews/webmd.csv`)