Write SQL and Python, run instantly in your browser, and track your progress.
You are a Data Engineer at Target. The E-commerce team needs product categories displayed in uppercase for the website's navigation menu. Transform the category column to uppercase.
| Column Name | Type |
|---|---|
| product_id | int64 |
| product_name | object |
| category | object |
| price | float64 |
You are a Data Engineer at Target. The E-commerce team needs product categories displayed in uppercase for the website's navigation menu. Transform the category column to uppercase.
| Column Name | Type |
|---|---|
| product_id | int64 |
| product_name | object |
| category | object |
| price | float64 |
| is_active | int64 |
| is_active | int64 |
| product_id | product_name | category | price | is_active |
|---|---|---|---|---|
| 1 | Casper Original Mattress Queen | Home | 1095.0 | 1 |
| 2 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | 1 |
| product_id | product_name | category | price | is_active |
|---|---|---|---|---|
| 1 | Casper Original Mattress Queen | Home | 1095.0 | 1 |
| 2 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | 1 |
| product_id | product_name | category | price | is_active | category_upper |
|---|---|---|---|---|---|
| 1 | Casper Original Mattress Queen | Home | 1095 | 1 | HOME |
| 2 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | 1 | BEAUTY |
| 3 | CalDigit TS4 Thunderbolt Dock |
| product_id | product_name | category | price | is_active | category_upper |
|---|---|---|---|---|---|
| 1 | Casper Original Mattress Queen | Home | 1095 | 1 | HOME |
| 2 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | 1 | BEAUTY |
| 3 | CalDigit TS4 Thunderbolt Dock |
Showing first 5 of 50 rows.
Showing first 5 of 50 rows.
1. Data Selection:
2. String Transformation:
3. Output:
1. Data Selection:
2. String Transformation:
3. Output:
| 3 | CalDigit TS4 Thunderbolt Dock | Office | 399.99 | 1 |
| 3 | CalDigit TS4 Thunderbolt Dock | Office | 399.99 | 1 |
| 4 | Under Armour Tech 2.0 T-Shirt | Sports | 25.0 | 1 |
| 4 | Under Armour Tech 2.0 T-Shirt | Sports | 25.0 | 1 |
| 5 | Staples TRU RED Copy Paper 10-Ream | Office | 54.99 | 1 |
| 5 | Staples TRU RED Copy Paper 10-Ream | Office | 54.99 | 1 |
| Office |
| Office |
| 399.99 |
| 399.99 |
| 1 |
| 1 |
| OFFICE |
| OFFICE |
| 4 | Under Armour Tech 2.0 T-Shirt | Sports | 25 | 1 | SPORTS |
| 4 | Under Armour Tech 2.0 T-Shirt | Sports | 25 | 1 | SPORTS |
| 5 | Staples TRU RED Copy Paper 10-Ream | Office | 54.99 | 1 | OFFICE |
| 5 | Staples TRU RED Copy Paper 10-Ream | Office | 54.99 | 1 | OFFICE |