Write SQL and Python, run instantly in your browser, and track your progress.
You are a Data Analyst at X (Twitter). The Content team needs clean post data merged with user information for engagement analysis. Clean both datasets and merge them, handling missing content appropriately.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| account_status | object |
You are a Data Analyst at X (Twitter). The Content team needs clean post data merged with user information for engagement analysis. Clean both datasets and merge them, handling missing content appropriately.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| account_status | object |
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_text | object |
| content_type | object |
| status | object |
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_text | object |
| content_type | object |
| status | object |
| user_id | username | account_status |
|---|---|---|
| 1 | andrea4 | active |
| 2 | its_emily | active |
| 3 | karen_wilson | active |
| 4 | liam80 | active |
| user_id | username | account_status |
|---|---|---|
| 1 | andrea4 | active |
| 2 | its_emily | active |
| 3 | karen_wilson | active |
| 4 | liam80 | active |
| post_id | user_id | content_text | content_type | status |
|---|---|---|---|---|
| 1 | 1 | Answering your questions about entrepreneurship | video | published |
| 2 | 1 | For everyone asking about technology, here's a helpful resource | link | published |
| post_id | user_id | content_text | content_type | status |
|---|---|---|---|---|
| 1 | 1 | Answering your questions about entrepreneurship | video | published |
| 2 | 1 | For everyone asking about technology, here's a helpful resource | link | published |
| post_id | user_id | content_text | content_type | status | username | content_preview |
|---|---|---|---|---|---|---|
| 1 | 1 | Answering your questions about entrepreneurship | video | published | andrea4 | Answering your questions ... |
| 2 | 1 | For everyone asking about technology, here's a helpful resource | link | published |
| post_id | user_id | content_text | content_type | status | username | content_preview |
|---|---|---|---|---|---|---|
| 1 | 1 | Answering your questions about entrepreneurship | video | published | andrea4 | Answering your questions ... |
| 2 | 1 | For everyone asking about technology, here's a helpful resource | link | published |
Showing first 5 of 179 rows.
Showing first 5 of 179 rows.
1. Data Selection:
2. Cleaning Operations:
3. Merge:
4. Output:
1. Data Selection:
2. Cleaning Operations:
3. Merge:
4. Output:
| 5 | liam21 | active |
| 5 | liam21 | active |
| 3 | 1 | Sunset vibes from Austin | image | published |
| 3 | 1 | Sunset vibes from Austin | image | published |
| 4 | 2 | What's your take on web development? | poll | published |
| 4 | 2 | What's your take on web development? | poll | published |
| 6 | 2 | Reminder that rest is productive. You've got this! | text | published |
| 6 | 2 | Reminder that rest is productive. You've got this! | text | published |
| andrea4 |
| andrea4 |
| For everyone asking about... |
| For everyone asking about... |
| 3 | 1 | Sunset vibes from Austin | image | published | andrea4 | Sunset vibes from Austin |
| 3 | 1 | Sunset vibes from Austin | image | published | andrea4 | Sunset vibes from Austin |
| 4 | 2 | What's your take on web development? | poll | published | its_emily | What's your take on web d... |
| 4 | 2 | What's your take on web development? | poll | published | its_emily | What's your take on web d... |
| 6 | 2 | Reminder that rest is productive. You've got this! | text | published | its_emily | Reminder that rest is pro... |
| 6 | 2 | Reminder that rest is productive. You've got this! | text | published | its_emily | Reminder that rest is pro... |