Challenge 4: Concat on Columns [Bands] (Medium)
Explore how to concatenate two Pandas DataFrames horizontally by setting the index and combining columns. Learn to calculate ratios and filter data, helping you analyze band metrics like monthly listeners versus fans for practical data analytics.
We'll cover the following...
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 |