Given an Airbnb dataset, write a query or a Pandas script to find the biggest median price difference between superhosts and non-superhosts.
Assume the comparison is made separately for each neighborhood. Exclude listings with missing neighborhoods, missing host status, or non-positive prices, and compare only neighborhoods containing both host types.
neighborhood, superhost_median_price, non_superhost_median_price, and median_price_difference.| Column | Type | Description |
|---|---|---|
| listing_idPK | INT | Unique listing identifier |
| neighborhood | VARCHAR(100) | Neighborhood where the listing is located |
| price | DECIMAL(10,2) | Nightly listing price |
| host_is_superhost | BOOLEAN | Whether the listing host is a superhost |