Challenge 1: Basic Merge [Countries & Bands] (Trivial)
Explore merging two datasets in Pandas by matching different column names to combine music band data with country information. Learn how to group the merged data by country names to calculate the total plays per country and convert results to a Python dictionary for analysis.
We'll cover the following...
We'll cover the following...
Problem definition
Your music analyst now has two datasets with complementary information.
The first dataset contains information about bands, and their associated data. However, instead of names, it refers to countries by their IDs. Here are the first three rows:
| artist | country | plays | genre | fans |
|---|---|---|---|---|
| The Beatles | 1 | 150 | rock | 50 |
| Pink Floyd | 1 | 10000 | rock | 1500 |