Write SQL and Python, run instantly in your browser, and track your progress.
You are a Data Analyst at Netflix. The Retention team needs clean subscription data for churn analysis. The data needs multiple transformations: status labels, missing end dates filled, and boolean conversion.
| Column Name | Type |
|---|---|
| subscription_id | int64 |
| user_id | int64 |
| plan_id | int64 |
| start_date | object |
You are a Data Analyst at Netflix. The Retention team needs clean subscription data for churn analysis. The data needs multiple transformations: status labels, missing end dates filled, and boolean conversion.
| Column Name | Type |
|---|---|
| subscription_id | int64 |
| user_id | int64 |
| plan_id | int64 |
| start_date | object |
| end_date | object |
| end_date | object |
| status | object |
| status | object |
| auto_renew | int64 |
| auto_renew | int64 |
| subscription_id | user_id | plan_id | start_date | end_date | status | auto_renew |
|---|---|---|---|---|---|---|
| 1 | 58 | 6 | 2025-07-26 | active | 1 | |
| 2 |
| subscription_id | user_id | plan_id | start_date | end_date | status | auto_renew |
|---|---|---|---|---|---|---|
| 1 | 58 | 6 | 2025-07-26 | active | 1 | |
| 2 |
| subscription_id | user_id | plan_id | start_date | end_date | status | auto_renew | status_category | auto_renew_bool | is_churned |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 58 | 6 | 2025-07-26 | Ongoing | active | 1 | Healthy | True | False |
| subscription_id | user_id | plan_id | start_date | end_date | status | auto_renew | status_category | auto_renew_bool | is_churned |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 58 | 6 | 2025-07-26 | Ongoing | active | 1 | Healthy | True | False |
Showing first 5 of 75 rows.
Showing first 5 of 75 rows.
1. Data Selection:
2. Cleaning Operations:
3. Output:
1. Data Selection:
2. Cleaning Operations:
3. Output:
| 41 |
| 41 |
| 11 |
| 11 |
| 2025-03-15 |
| 2025-03-15 |
| 2025-05-29 |
| 2025-05-29 |
| canceled |
| canceled |
| 0 |
| 0 |
| 3 | 44 | 10 | 2025-06-28 | 2025-08-04 | canceled | 0 |
| 3 | 44 | 10 | 2025-06-28 | 2025-08-04 | canceled | 0 |
| 4 | 2 | 2 | 2025-02-27 | 2025-07-25 | expired | 0 |
| 4 | 2 | 2 | 2025-02-27 | 2025-07-25 | expired | 0 |
| 5 | 55 | 3 | 2025-07-10 | active | 1 |
| 5 | 55 | 3 | 2025-07-10 | active | 1 |
| 2 | 41 | 11 | 2025-03-15 | 2025-05-29 | canceled | 0 | Churned | False | True |
| 2 | 41 | 11 | 2025-03-15 | 2025-05-29 | canceled | 0 | Churned | False | True |
| 3 | 44 | 10 | 2025-06-28 | 2025-08-04 | canceled | 0 | Churned | False | True |
| 3 | 44 | 10 | 2025-06-28 | 2025-08-04 | canceled | 0 | Churned | False | True |
| 4 | 2 | 2 | 2025-02-27 | 2025-07-25 | expired | 0 | Churned | False | True |
| 4 | 2 | 2 | 2025-02-27 | 2025-07-25 | expired | 0 | Churned | False | True |
| 5 | 55 | 3 | 2025-07-10 | Ongoing | active | 1 | Healthy | True | False |
| 5 | 55 | 3 | 2025-07-10 | Ongoing | active | 1 | Healthy | True | False |