Write SQL and Python, run instantly in your browser, and track your progress.
You are a Data Analyst at LinkedIn. The Growth team needs a report showing follower relationships with full names for both the follower and the person they follow. You'll need to merge the relationships DataFrame with the users DataFrame twice - once to get the follower's name and once to get the followee's name.
| Column Name | Type |
|---|---|
| follow_id | int64 |
| follower_id | int64 |
| followee_id | int64 |
| created_at |
You are a Data Analyst at LinkedIn. The Growth team needs a report showing follower relationships with full names for both the follower and the person they follow. You'll need to merge the relationships DataFrame with the users DataFrame twice - once to get the follower's name and once to get the followee's name.
| Column Name | Type |
|---|---|
| follow_id | int64 |
| follower_id | int64 |
| followee_id | int64 |
| created_at |
| object |
| object |
| status | object |
| status | object |
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| object | |
| country | object |
| join_date | object |
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| object | |
| country | object |
| join_date | object |
| follow_id | follower_id | followee_id | created_at | status |
|---|---|---|---|---|
| 1 | 1 | 7 | 2025-08-17 22:47:52 | active |
| 2 | 1 | 16 | 2025-08-15 18:38:27 | active |
| follow_id | follower_id | followee_id | created_at | status |
|---|---|---|---|---|
| 1 | 1 | 7 | 2025-08-17 22:47:52 | active |
| 2 | 1 | 16 | 2025-08-15 18:38:27 | active |
| 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 |
| follow_id | follower_name | followee_name |
|---|---|---|
| 1 | Andrea Davis | Juan Hassan |
| 2 | Andrea Davis | Ren Thompson |
| 3 | Andrea Davis | Isabella Anderson |
| 4 | Andrea Davis | Deepa Yamamoto |
| 5 | Andrea Davis | Raj Kumar |
| follow_id | follower_name | followee_name |
|---|---|---|
| 1 | Andrea Davis | Juan Hassan |
| 2 | Andrea Davis | Ren Thompson |
| 3 | Andrea Davis | Isabella Anderson |
| 4 | Andrea Davis | Deepa Yamamoto |
| 5 | Andrea Davis | Raj Kumar |
Showing first 5 of 486 rows.
Showing first 5 of 486 rows.
1. DataFrames:
2. Multiple Merges:
3. Output:
1. DataFrames:
2. Multiple Merges:
3. Output:
| account_status | object |
| account_status | object |
| is_verified | int64 |
| is_verified | int64 |
| bio | object |
| bio | object |
| 3 |
| 3 |
| 1 |
| 1 |
| 55 |
| 55 |
| 2025-07-03 11:47:43 |
| 2025-07-03 11:47:43 |
| active |
| active |
| 4 | 1 | 9 | 2025-05-18 03:03:10 | active |
| 4 | 1 | 9 | 2025-05-18 03:03:10 | active |
| 5 | 1 | 31 | 2025-04-28 21:15:53 | active |
| 5 | 1 | 31 | 2025-04-28 21:15:53 | active |
| 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 |