Popular Exhibit-to-Exhibit Routes

Problem

You are given one DataFrame `exhibit_visits` (loaded from `exhibit_visits.csv`), where each row is an exhibit a visitor finished, with columns `visitor_id`, `exhibit_id`, `exhibit_name`, `visited_at` (timestamp), and `enjoyment` (1 to 5). Consider only the enthusiasts: visitors who finished at least 5 exhibits AND whose average enjoyment is at least 4. For those visitors, look at each pair of exhibits visited back-to-back (the exhibit visited immediately after another, in time order), and count how often each ordered pair occurs across all enthusiasts. Return a DataFrame with `from_exhibit`, `to_exhibit`, and the occurrence count as `route_count`. Order by `route_count` descending, then `from_exhibit` ascending, then `to_exhibit` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 5 rows with the columns from_exhibit, to_exhibit, route_count.

Starter code (Pandas (Python))

import pandas as pd

def find_popular_routes(exhibit_visits) -> pd.DataFrame:
    # Your code here
    return exhibit_visits

Related Pandas questions

• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard
• Attendees By TrackHard
• Auto-Tagging Support TicketsHard
• Bake-Off Division ChampionsHard
• Branch Energy Spend vs Chain AverageHard