Artist and Song Performance Analysis

Introduction to Performance Metrics Analysis

Hello and welcome to this section: Artist and Song Performance Analysis! Today, we'll delve into understanding how artists and songs have performed on the Billboard Christmas charts. Our goal is to leverage pandas to uncover insights about song popularity and longevity. By the end of this lesson, you'll be able to compute and understand various performance metrics from chart data, laying a solid foundation for deeper visual analysis later on.

Data Grouping using Pandas

To analyze the performance efficiently, we need to group our dataset by song and performer . This helps in creating summaries and insights. The groupby() method in pandas is a powerful tool for this. Let's start by loading our dataset: Python import pandas as pd # Load the 'billboard_christmas.csv' data df = pd.read_csv("billboard_christmas.csv") # Group data by 'song' and 'performer' grouped_data = df.groupby(['song', 'performer']) print(grouped_data.first().head()) # Displaying the first entry for each group import pandas as pd # Load the 'billboard_christmas.csv' data df = pd.read_csv("billboard_christmas.csv") # Group data by 'song' and 'performer' grouped_data = df.groupby(['song', 'performer']) print(grouped_data.first().head()) # Displaying the first entry for each group Grouping by song and performer allows us to analyze the data at a granularity that aligns with our goal — each group represents a unique song and artist duo, making insights much more meaningful.

Output

text url ... day song performer ... A Great Big Sled The Killers Featuring Toni Halliday http://www.billboard.com/charts/hot-100/2006-1... ... 23 A Holly Jolly Christmas Burl Ives http://www.billboard.com/charts/hot-100/2017-0... ... 7 All I Want For Christmas Is You Mariah Carey http://www.billboard.com/charts/hot-100/2000-0... ... 8 Michael Buble http://www.billboard.com/charts/hot-100/2011-1... ... 31 Amen The Impressions http://www.billboard.com/charts/hot-100/1964-1... ... 21 url ... day song performer ... A Great Big Sled The Killers Featuring Toni Halliday http://www.billboard.com/charts/hot-100/2006-1... ... 23 A Holly Jolly Christmas Burl Ives http://www.billboard.com/charts/hot-100/2017-0... ... 7 All I Want For Christmas Is You Mariah Carey http://www.billboard.com/charts/hot-100/2000-0... ... 8 Michael Buble http://www.billboard.com/charts/hot-100/2011-1... ... 31 Amen The Impressions http://www.billboard.com/charts/hot-100/1964-1... ... 21

Calculating Performance Metrics

Once grouped, we can proceed to calculate various performance metrics. This step showcases pandas' ability to handle complex calculations efficiently with the agg() function. Let's explore how to extract meaningful metrics: Python# Calculate performance metrics using aggregation performance_metrics = grouped_data.agg({ 'peak_position': 'min', 'weeks_on_chart': 'max', 'week_position': 'mean', 'year': ['count', 'min', 'max'] }).round(2) print(performance_metrics.head())# Calculate performance metrics using aggregation performance_metrics = grouped_data.agg({ 'peak_position': 'min', 'weeks_on_chart': 'max', 'week_position': 'mean', 'year': ['count', 'min', 'max'] }).round(2) print(performance_metrics.head()) By aggregating with min, max, and mean, we can determine the best and most enduring songs — a critical analysis for music trends over the decades.

Join the 1M+ learners on CodeSignal

Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal

Python

import pandas as pd

# Load the 'billboard_christmas.csv' data
df = pd.read_csv("billboard_christmas.csv")

# Group data by 'song' and 'performer'
grouped_data = df.groupby(['song', 'performer'])
print(grouped_data.first().head())  # Displaying the first entry for each group

text

url  ... day
song                            performer                                                                               ...    
A Great Big Sled                The Killers Featuring Toni Halliday  http://www.billboard.com/charts/hot-100/2006-1...  ...  23
A Holly Jolly Christmas         Burl Ives                            http://www.billboard.com/charts/hot-100/2017-0...  ...   7
All I Want For Christmas Is You Mariah Carey                         http://www.billboard.com/charts/hot-100/2000-0...  ...   8
                                Michael Buble                        http://www.billboard.com/charts/hot-100/2011-1...  ...  31
Amen                            The Impressions                      http://www.billboard.com/charts/hot-100/1964-1...  ...  21

Python

# Calculate performance metrics using aggregation
performance_metrics = grouped_data.agg({
    'peak_position': 'min',
    'weeks_on_chart': 'max',
    'week_position': 'mean',
    'year': ['count', 'min', 'max']
}).round(2)

print(performance_metrics.head())

text

                                                                    peak_position  ...  year
                                                                              min  ...   max
song                            performer                                          ...      
A Great Big Sled                The Killers Featuring Toni Halliday            54  ...  2007
A Holly Jolly Christmas         Burl Ives                                      46  ...  2017
All I Want For Christmas Is You Mariah Carey                                   11  ...  2017
                                Michael Buble                                  99  ...  2011
Amen                            The Impressions                                 7  ...  1965

[5 rows x 6 columns]

Python

# Rename columns for clarity
performance_metrics.columns = [
    'best_position', 'total_weeks', 'avg_position',
    'appearances', 'first_year', 'last_year'
]

# Add derived columns 'years_active' and 'reached_top_10'
performance_metrics['years_active'] = (
    performance_metrics['last_year'] -
    performance_metrics['first_year'] + 1
)

# Calculating 'reached_top_10'
success_threshold = 10  # Define success as reaching top 10
performance_metrics['reached_top_10'] = performance_metrics['best_position'] <= success_threshold

Python

# Displaying the most successful songs by peak position
print("Most Successful Songs (by peak position):")
print(performance_metrics.sort_values('best_position').head())

# Displaying the most enduring songs by total weeks
print("\nMost Enduring Songs (by total weeks):")
print(performance_metrics.sort_values('total_weeks', ascending=False).head())

# Displaying best comeback songs by years active
print("\nBest Comeback Songs (by years active):")
print(performance_metrics.sort_values('years_active', ascending=False).head())

# Displaying most consistent performers with at least 5 appearances
print("\nMost Consistent Performers (by average position, min 5 appearances):")
multiple_hits = performance_metrics[performance_metrics['appearances'] >= 5]
print(multiple_hits.sort_values('avg_position').head())

text

Most Successful Songs (by peak position):
                                                   best_position  ...  reached_top_10
song                        performer                             ...                
Amen                        The Impressions                    7  ...            True
This One'S For The Children New Kids On The Block              7  ...            True
Auld Lang Syne              Kenny G                            7  ...            True
Same Old Lang Syne          Dan Fogelberg                      9  ...            True
Mistletoe                   Justin Bieber                     11  ...           False

[5 rows x 8 columns]

Most Enduring Songs (by total weeks):
                                               best_position  ...  reached_top_10
song                            performer                     ...                
Better Days                     Goo Goo Dolls             36  ...           False
Believe                         Brooks & Dunn             60  ...           False
Jingle Bell Rock                Bobby Helms               29  ...           False
All I Want For Christmas Is You Mariah Carey              11  ...           False
Same Old Lang Syne              Dan Fogelberg              9  ...            True

[5 rows x 8 columns]

Best Comeback Songs (by years active):
                                                           best_position  ...  reached_top_10
song                                        performer                     ...                
Jingle Bell Rock                            Bobby Helms               29  ...           False
Rockin' Around The Christmas Tree           Brenda Lee                14  ...           False
The Christmas Song (Merry Christmas To You) Nat King Cole             38  ...           False
All I Want For Christmas Is You             Mariah Carey              11  ...           False
White Christmas                             Bing Crosby               12  ...           False

[5 rows x 8 columns]

Most Consistent Performers (by average position, min 5 appearances):
                                                       best_position  ...  reached_top_10
song                            performer                             ...                
This One'S For The Children     New Kids On The Block              7  ...            True
All I Want For Christmas Is You Mariah Carey                      11  ...           False
Pretty Paper                    Roy Orbison                       15  ...           False
Amen                            The Impressions                    7  ...            True
Do They Know It'S Christmas?    Band-Aid                          13  ...           False

[5 rows x 8 columns]

Introduction to Performance Metrics Analysis

Data Grouping using Pandas

Output

Calculating Performance Metrics

Join the 1M+ learners on CodeSignal

Output

Adding Derived Insights and Columns

Interpreting and Presenting the Analysis

Lesson Summary