Artists by grammies

We used Data on Songs from Billboard 1999-2019, specifically grammyAlbums_199-2019.csv and grammySongs_1999-2019.csv. We concatenated the two datasets into one and summed up the amount of awards each artist received. The resulting graph shows the amount of grammy awards each artist has received. It only shows artists with more than 4 awards to keep readability.

From this graph we can see that ‘Adele’ has the most amount of awards, but only by one.

Show code cell source Hide code cell source

import plotly.graph_objs as go
import plotly.express as px
import pandas as pd

df = pd.read_csv("../cleaned/grammyAlbums_199-2019.csv", index_col=0)
df2 = pd.read_csv("../cleaned/grammySongs_1999-2019.csv", index_col=0)
df2.rename(columns={'GrammyAward': 'Award'}, inplace=True)
df = pd.concat([df, df2])
df = df.groupby('Artist', as_index=False).count()
df = df.loc[df['Artist'] != 'Various Artists']
df = df.loc[df['Award'] > 4]
df.sort_values('Award', inplace=True)

px.histogram(df, x='Artist', y='Award', title='Amount of grammies received per artist').show()