Write SQL and Python, run instantly in your browser, and track your progress.
You are a Product Analyst at Netflix. The Pricing team needs plan attributes in a long format for their analytics dashboard. Convert the plan data from wide format (one row per plan with multiple attribute columns) to long format (one row per plan-attribute combination).
| Column Name | Type |
|---|---|
| plan_id | int64 |
| plan_code | object |
| plan_name | object |
| monthly_price |
You are a Product Analyst at Netflix. The Pricing team needs plan attributes in a long format for their analytics dashboard. Convert the plan data from wide format (one row per plan with multiple attribute columns) to long format (one row per plan-attribute combination).
| Column Name | Type |
|---|---|
| plan_id | int64 |
| plan_code | object |
| plan_name | object |
| monthly_price |
| float64 |
| float64 |
| max_screens | int64 |
| max_screens | int64 |
| plan_id | plan_code | plan_name | monthly_price | max_screens |
|---|---|---|---|---|
| 1 | BASIC_US | Basic | 9.99 | 1 |
| 2 | STD_US | Standard | 15.49 | 2 |
| plan_id | plan_code | plan_name | monthly_price | max_screens |
|---|---|---|---|---|
| 1 | BASIC_US | Basic | 9.99 | 1 |
| 2 | STD_US | Standard | 15.49 | 2 |
| plan_id | plan_code | attribute | value |
|---|---|---|---|
| 1 | PLN00001 | max_screens | 1 |
| 1 | PLN00001 | monthly_price | 6.99 |
| 2 | PLN00002 | max_screens | 2 |
| 2 | PLN00002 | monthly_price | 12.99 |
| plan_id | plan_code | attribute | value |
|---|---|---|---|
| 1 | PLN00001 | max_screens | 1 |
| 1 | PLN00001 | monthly_price | 6.99 |
| 2 | PLN00002 | max_screens | 2 |
| 2 | PLN00002 | monthly_price | 12.99 |
Showing first 5 of 40 rows.
Showing first 5 of 40 rows.
1. Data Selection:
2. Reshaping:
3. Output:
1. Data Selection:
2. Reshaping:
3. Output:
| 3 |
| 3 |
| PREM_US |
| PREM_US |
| Premium |
| Premium |
| 22.99 |
| 22.99 |
| 4 |
| 4 |
| 4 | ADS_US | Basic with Ads | 6.99 | 1 |
| 4 | ADS_US | Basic with Ads | 6.99 | 1 |
| 3 | PLN00003 | max_screens | 4 |
| 3 | PLN00003 | max_screens | 4 |