Second-Priciest Listing per Neighborhood

Problem

A property portal gives you a DataFrame `listings` with an asking_price and the neighborhood each listing sits in. For each neighborhood, find the listings whose asking_price is the second-highest distinct price in that neighborhood. If several listings share that second-highest price, return all of them. Skip any neighborhood that has fewer than two distinct price levels. Return a DataFrame with columns listing_id and neighborhood, ordered by listing_id.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns listing_id, neighborhood.

Starter code (Pandas (Python))

import pandas as pd

def second_priciest_listing_per_neighborhood(listings) -> pd.DataFrame:
    # Your code here
    return listings

Related Pandas questions

• 7-Day Rolling Signup AverageMedium
• Accounts Streaming From Two Devices at OnceMedium
• Agent Resolution RateMedium
• Agents With a Dominant Contact ChannelMedium
• Airbnb Popularity Bucket PricingMedium
• Amazon Unique Shipments per MonthMedium