Write SQL and Python, run instantly in your browser, and track your progress.
You are a Category Analyst at Amazon. The Pricing team needs to understand each product's price contribution within its category. For each product, calculate what percentage its price represents of the total price sum within its category.
This requires using transform() to calculate group-level statistics while preserving the original row structure.
| Column Name | Type |
|---|---|
| product_id | int64 |
| sku | object |
| product_name |
You are a Category Analyst at Amazon. The Pricing team needs to understand each product's price contribution within its category. For each product, calculate what percentage its price represents of the total price sum within its category.
This requires using transform() to calculate group-level statistics while preserving the original row structure.
| Column Name | Type |
|---|---|
| product_id | int64 |
| sku | object |
| product_name |
| object |
| object |
| category | object |
| category | object |
| price | float64 |
| price | float64 |
| currency | object |
| currency | object |
| is_active | int64 |
| is_active | int64 |
| weight_kg | float64 |
| weight_kg | float64 |
| created_at | object |
| created_at | object |
| product_id | sku | product_name | category | price | currency | is_active | weight_kg | created_at |
|---|---|---|---|---|---|---|---|---|
| 1 | SKU-10001 | Casper Original Mattress Queen | Home | 1095.0 | USD |
| product_id | sku | product_name | category | price | currency | is_active | weight_kg | created_at |
|---|---|---|---|---|---|---|---|---|
| 1 | SKU-10001 | Casper Original Mattress Queen | Home | 1095.0 | USD |
| product_id | product_name | category | price | pct_of_category |
|---|---|---|---|---|
| 19 | Ray-Ban Aviator Classic Sunglasses | Apparel | 163 | 55.44 |
| 46 | Nike Air Force 1 '07 | Apparel | 110 | 37.41 |
| 26 | Hanes ComfortSoft T-Shirt 6-Pack | Apparel | 21 | 7.14 |
| product_id | product_name | category | price | pct_of_category |
|---|---|---|---|---|
| 19 | Ray-Ban Aviator Classic Sunglasses | Apparel | 163 | 55.44 |
| 46 | Nike Air Force 1 '07 | Apparel | 110 | 37.41 |
| 26 | Hanes ComfortSoft T-Shirt 6-Pack | Apparel | 21 | 7.14 |
Showing first 5 of 50 rows.
Showing first 5 of 50 rows.
1. Calculation:
2. Output:
1. Calculation:
2. Output:
| 1 |
| 1 |
| 31.75 |
| 31.75 |
| 2025-02-14 10:57:38 |
| 2025-02-14 10:57:38 |
| 2 | SKU-10002 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | USD | 1 | 0.66 | 2025-02-27 07:20:29 |
| 2 | SKU-10002 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | USD | 1 | 0.66 | 2025-02-27 07:20:29 |
| 3 | SKU-10003 | CalDigit TS4 Thunderbolt Dock | Office | 399.99 | USD | 1 | 0.5 | 2024-12-11 00:49:57 |
| 3 | SKU-10003 | CalDigit TS4 Thunderbolt Dock | Office | 399.99 | USD | 1 | 0.5 | 2024-12-11 00:49:57 |
| 4 | SKU-10004 | Under Armour Tech 2.0 T-Shirt | Sports | 25.0 | USD | 1 | 0.15 | 2024-11-22 04:49:00 |
| 4 | SKU-10004 | Under Armour Tech 2.0 T-Shirt | Sports | 25.0 | USD | 1 | 0.15 | 2024-11-22 04:49:00 |
| 5 | SKU-10005 | Staples TRU RED Copy Paper 10-Ream | Office | 54.99 | USD | 1 | 22.68 | 2025-01-10 01:43:59 |
| 5 | SKU-10005 | Staples TRU RED Copy Paper 10-Ream | Office | 54.99 | USD | 1 | 22.68 | 2025-01-10 01:43:59 |
| 2 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | 65.25 |
| 2 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | 65.25 |
| 6 | Sunday Riley Good Genes | Beauty | 122 | 18.51 |
| 6 | Sunday Riley Good Genes | Beauty | 122 | 18.51 |