Write SQL and Python, run instantly in your browser, and track your progress.
You are a Frontend Engineer at LinkedIn. The Profile team needs to display user names in a consistent format for the mobile app. Create a display name that shows the first name followed by last initial (e.g., "Andrea D."). Also extract just the first name for personalized greetings.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
You are a Frontend Engineer at LinkedIn. The Profile team needs to display user names in a consistent format for the mobile app. Create a display name that shows the first name followed by last initial (e.g., "Andrea D."). Also extract just the first name for personalized greetings.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| object |
| object |
| country | object |
| country | object |
| join_date | object |
| join_date | object |
| account_status | object |
| account_status | object |
| is_verified | int64 |
| is_verified | int64 |
| bio | object |
| bio | object |
| user_id | username | full_name | country | join_date | account_status | is_verified | bio | |
|---|---|---|---|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | andrea.davis@gmail.com | AU | 2025-03-31 19:11:04 |
| user_id | username | full_name | country | join_date | account_status | is_verified | bio | |
|---|---|---|---|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | andrea.davis@gmail.com | AU | 2025-03-31 19:11:04 |
| user_id | username | full_name | first_name | display_name |
|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | Andrea | Andrea D. |
| 2 | its_emily | Emily Anderson | Emily | Emily A. |
| 3 | karen_wilson | Karen Wilson | Karen | Karen W. |
| user_id | username | full_name | first_name | display_name |
|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | Andrea | Andrea D. |
| 2 | its_emily | Emily Anderson | Emily | Emily A. |
| 3 | karen_wilson | Karen Wilson | Karen | Karen W. |
Showing first 5 of 60 rows.
Showing first 5 of 60 rows.
1. Data Selection:
2. Transformation:
3. Output:
1. Data Selection:
2. Transformation:
3. Output:
| active |
| active |
| 0 |
| 0 |
| 2 | its_emily | Emily Anderson | emily.anderson@proton.me | DE | 2025-02-10 22:12:29 | active | 0 | Entrepreneur | crypto enthusiast | Tokyo |
| 2 | its_emily | Emily Anderson | emily.anderson@proton.me | DE | 2025-02-10 22:12:29 | active | 0 | Entrepreneur | crypto enthusiast | Tokyo |
| 3 | karen_wilson | Karen Wilson | karen.wilson@yahoo.com | ES | 2025-04-23 11:08:04 | active | 1 | travel lover. Student. Living my best life. |
| 3 | karen_wilson | Karen Wilson | karen.wilson@yahoo.com | ES | 2025-04-23 11:08:04 | active | 1 | travel lover. Student. Living my best life. |
| 4 | liam80 | Liam O'Brien | liam.o'brien@gmail.com | AU | 2025-06-28 05:31:09 | active | 1 | reading lover. Student. Living my best life. |
| 4 | liam80 | Liam O'Brien | liam.o'brien@gmail.com | AU | 2025-06-28 05:31:09 | active | 1 | reading lover. Student. Living my best life. |
| 5 | liam21 | Liam Patel | liam.patel@proton.me | SG | 2025-05-10 16:07:39 | active | 0 | nature | photography | Tokyo based |
| 5 | liam21 | Liam Patel | liam.patel@proton.me | SG | 2025-05-10 16:07:39 | active | 0 | nature | photography | Tokyo based |
| 4 | liam80 | Liam O'Brien | Liam | Liam O. |
| 4 | liam80 | Liam O'Brien | Liam | Liam O. |
| 5 | liam21 | Liam Patel | Liam | Liam P. |
| 5 | liam21 | Liam Patel | Liam | Liam P. |