Three-Flower Bouquet Costs

Problem

You are given a DataFrame `stems` with columns `stem_name` and `price`, the per-stem price for each kind of flower a florist stocks.

A signature bouquet uses exactly **three different stems**. List the cost of every possible three-stem bouquet. Within each bouquet the stem names must appear in alphabetical order, separated by commas, and no stem may repeat. Output `bouquet` (the comma-joined names) and `total_price` (the rounded sum of the three prices, to 2 decimals). Order by `total_price` descending, then `bouquet` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns bouquet, total_price.

Starter code (Pandas (Python))

import pandas as pd

def three_flower_bouquet_costs(stems) -> pd.DataFrame:
    # Your code here
    return stems

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