Write SQL and Python, run instantly in your browser, and track your progress.
You are a Product Analyst at Meta. The Profile team wants to display a default bio for users who haven't set one yet. Fill in missing bio values with 'No bio provided' so the UI displays consistent content.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| account_status | object |
You are a Product Analyst at Meta. The Profile team wants to display a default bio for users who haven't set one yet. Fill in missing bio values with 'No bio provided' so the UI displays consistent content.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| account_status | object |
| bio | object |
| bio | object |
| user_id | username | full_name | account_status | bio |
|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | active | |
| 2 | its_emily | Emily Anderson | active | Entrepreneur | crypto enthusiast | Tokyo |
| user_id | username | full_name | account_status | bio |
|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | active | |
| 2 | its_emily | Emily Anderson | active | Entrepreneur | crypto enthusiast | Tokyo |
| user_id | username | full_name | account_status | bio | ||
|---|---|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | active | No bio provided | ||
| 2 | its_emily | Emily Anderson | active | Entrepreneur | crypto enthusiast | Tokyo |
| 3 | karen_wilson | Karen Wilson |
| user_id | username | full_name | account_status | bio | ||
|---|---|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | active | No bio provided | ||
| 2 | its_emily | Emily Anderson | active | Entrepreneur | crypto enthusiast | Tokyo |
| 3 | karen_wilson | Karen Wilson |
Showing first 5 of 60 rows.
Showing first 5 of 60 rows.
1. Data Selection:
2. Cleaning:
3. Output:
1. Data Selection:
2. Cleaning:
3. Output:
| 3 | karen_wilson | Karen Wilson | active | travel lover. Student. Living my best life. |
| 3 | karen_wilson | Karen Wilson | active | travel lover. Student. Living my best life. |
| 4 | liam80 | Liam O'Brien | active | reading lover. Student. Living my best life. |
| 4 | liam80 | Liam O'Brien | active | reading lover. Student. Living my best life. |
| 5 | liam21 | Liam Patel | active | nature | photography | Tokyo based |
| 5 | liam21 | Liam Patel | active | nature | photography | Tokyo based |
| active |
| active |
| travel lover. Student. Living my best life. |
| travel lover. Student. Living my best life. |
| 4 | liam80 | Liam O'Brien | active | reading lover. Student. Living my best life. |
| 4 | liam80 | Liam O'Brien | active | reading lover. Student. Living my best life. |
| 5 | liam21 | Liam Patel | active | nature | photography | Tokyo based |
| 5 | liam21 | Liam Patel | active | nature | photography | Tokyo based |