Each Reader's Favourite Genre

Problem

You are given three DataFrames:
- `readers` with `reader_id`, `display_name`
- `reads` with `read_id`, `read_on`, `reader_id`, `genre_id`
- `genres` with `genre_id`, `genre_name`

For each reader, find the genre(s) they read most often (the highest number of `reads` rows). If a reader is tied between several genres at their top count, return every tied genre.

Return columns `reader_id`, `genre_id`, `genre_name`. Readers with no reads do not appear.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 6 rows with the columns reader_id, genre_id, genre_name.

Starter code (Pandas (Python))

import pandas as pd

def each_readers_favourite_genre(readers, reads, genres) -> pd.DataFrame:
    # Your code here
    return readers

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