Second Most Expensive Book Price

Problem

A bookshop keeps the listed price of every title in one DataFrame.

**DataFrame: `catalog_titles`**

| Column | Type |
|-------------|------|
| title_id | int |
| list_price | int |

Each row holds the listed price (in whole shekels) of one book; `title_id` is unique.

Return a DataFrame with a single column `runner_up_price` holding the **second highest distinct** `list_price`. If there is no second distinct price, the value must be `None`.

**Example** — with prices 40, 55 and 72, the second highest distinct price is 55.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns runner_up_price.

Starter code (Pandas (Python))

import pandas as pd

def second_dearest_title(catalog_titles) -> pd.DataFrame:
    # Your code here
    return catalog_titles

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