Challenge 3: Basic Concat [Bands] (Trivial)
This challenge expects you to concatenate two similar DataFrames.
We'll cover the following
Problem definition
Your music analyst now has two datasets, with the same information about the bands and their associated data split in two.
The first dataset is the standard music dataset you’ve been using so far.
| artist | country | plays | genre | fans |
|---|---|---|---|---|
| The Beatles | 1 | 150 | rock | 50 |
| Pink Floyd | 1 | 10000 | rock | 1500 |
| Metallica | 2 | 500 | metal | 50 |
The second dataset has the same columns as the original music dataset-just with different bands.
| 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 |
Can you help the music analyst find the sum of plays for the two datasets merged together?
Level up your interview prep. Join Educative to access 70+ hands-on prep courses.