Quietly Rented Board Games

Problem

A board game cafe lends out games and tracks every rental.

DataFrame: `game` (`game.csv`)

```text
+-------------+--------+
| Column | Type |
+-------------+--------+
| game_id | int |
| title | object |
| shelved_on | object |
+-------------+--------+
```
`game_id` is unique. `shelved_on` is the date the game first became available to rent.

DataFrame: `rental` (`rental.csv`)

```text
+-------------+--------+
| Column | Type |
+-------------+--------+
| rental_id | int |
| game_id | int |
| copies | int |
| rented_on | object |
+-------------+--------+
```
`rental_id` is unique. Each row records that some copies of a game were rented on a date.

Write a function that returns the games rented fewer than 10 copies in the last year, excluding any game on the shelf for less than one month. Assume today is 2023-06-23, so 'last year' means rentals on or after 2022-06-23, and a game is too new if it was shelved on or after 2023-05-23. Return columns `game_id` and `title` in any order.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns game_id, title.

Starter code (Pandas (Python))

import pandas as pd

def quiet_games(game: pd.DataFrame, rental: pd.DataFrame) -> pd.DataFrame:
    # Your code here
    return game

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