Most-Voted Book of the Month

Problem

You are given two DataFrames.

`book`
```text
+---------+--------+
| Column | Type |
+---------+--------+
| book_id | int |
| title | object |
+---------+--------+
book_id is the unique key.
```

`ballot`
```text
+-----------+---------+
| Column | Type |
+-----------+---------+
| ballot_id | int |
| book_id | int |
+-----------+---------+
ballot_id is the unique key. Each row is one vote cast for the given book_id.
```

Find the `title` of the book that received the most votes (assume there is no tie). Return a DataFrame with a single column `title`.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns title.

Starter code (Pandas (Python))

import pandas as pd

def top_book(book: pd.DataFrame, ballot: pd.DataFrame) -> pd.DataFrame:
    # Your code here
    return book

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