Challenge 4: Concat on Columns [Bands] (Medium)
This challenge expects you to perform a horizontal concatenation of two DataFrames .
We'll cover the following
Problem definition
Your music analyst now has two datasets. The first is the standard music dataset with the band names and their associated data.
| artist | country | plays | genre | fans |
|---|---|---|---|---|
| Leprous | 5 | 1000 | metal | 500 |
| ABBA | 5 | 2000 | pop | 100 |
| Bryan Adams | 6 | 2500 | pop | 200 |
| Rush | 6 | 3000 | rock | 500 |
The second dataset contains an extra piece of information for each band (the bands in both datasets are the same), which is the number of monthly listeners.
| artist | monthly_listeners |
|---|---|
| Leprous | 300 |
| ABBA | 20 |
| Bryan Adams | 40 |
| Rush | 280 |
Can you help the music analyst find the bands that have a ratio of monthly listeners to fans greater than 0.5?
Level up your interview prep. Join Educative to access 80+ hands-on prep courses.