Ingredients Frequently Used Together

Problem

You are given two DataFrames. `recipe_uses` (loaded from `recipe_uses.csv`) has columns `cook_id`, `item_id`, and `grams`; each row means a cook used a given pantry item in one of their recipes. `pantry_items` (loaded from `pantry_items.csv`) has columns `item_id`, `aisle`, and `unit_cost`, with `item_id` as its primary key.

Find every pair of pantry items that were used together by at least three different cooks. Treat each pair only once, with the smaller `item_id` first. Return the two item ids, the aisle of each item, and the number of distinct cooks who used both.

Return `item1_id`, `item2_id`, `item1_aisle`, `item2_aisle`, and `cook_count`, ordered by `cook_count` descending, then `item1_id` ascending, then `item2_id` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns item1_id, item2_id, item1_aisle, item2_aisle, cook_count.

Starter code (Pandas (Python))

import pandas as pd

def frequent_ingredient_pairs(recipe_uses, pantry_items) -> pd.DataFrame:
    # Your code here
    return recipe_uses

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