Warehouses Stocking Heavy Items Too Thinly

Problem

Two CSV files describe storage. `warehouses.csv` holds each warehouse (`warehouse_id`, `warehouse_name`, `region`); `stock.csv` records each stocked item (`stock_id`, `warehouse_id`, `item_name`, `units`, `weight_kg`). Find warehouses with a stocking skew: the heaviest item has fewer on-hand units than the lightest item. Only consider warehouses carrying at least three distinct items. Report the skew as the lightest item's units divided by the heaviest item's units, rounded to two decimals, as `stock_skew`. Sort by `stock_skew` descending, then by `warehouse_name` alphabetically.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns warehouse_name, stock_skew.

Starter code (Pandas (Python))

import pandas as pd

def find_stocking_skew(warehouses, stock) -> pd.DataFrame:
    # Your code here
    return warehouses

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