Book Suggestions from Reading Buddies

Problem

You are given two DataFrames.

`buddies` has columns `reader_a` and `reader_b`. Each row means `reader_a` and `reader_b` are reading buddies. The relationship is mutual but is stored once, in either order of the two ids.

`reads` has columns `reader_id` and `book_id`. Each row means `reader_id` has read `book_id`.

Suggest books to **reader 1** based on what their reading buddies have read. Do not suggest a book reader 1 has already read. Return each suggested book once.

Return the single column `suggested_book` with no duplicates, in any order.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 5 rows with the columns suggested_book.

Starter code (Pandas (Python))

import pandas as pd

def book_suggestions(buddies, reads) -> pd.DataFrame:
    # Your code here
    return buddies

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