import matplotlib.pyplot as plt
%matplotlib inline

#Which artist has the most songs listed?
print(df['Artist'].value_counts()[:1])

#How many hits did the Stones have?
len(df[df['Artist'] == 'the rolling stones'])

#How many did The Beatles have?
len(df[df['Artist'] == 'the beatles'])

#How many songs are there total? How many years?
(df['Year'].value_counts())

#How many songs have the word 'love' in their lyrics?
len(df[df['Lyrics'].str.contains(" love ", na=False)])

#How many songs have the word 'no' in their lyrics?
len(df[df['Lyrics'].str.contains(" no ", na=False)])

#Did any songs rank for more than one year?
df['Song'].value_counts()[:10]

(df['Song'].value_counts())

"""
Explanation: which artist has the most songs listed?
how many billboard hits did the rolling stones have?
vs the beatles?
how many songs total? how many years?
how many song lyrics have the word 'love'?
how many song lyrics include the word 'no'?
which song has the most uses of the word 'no'?
did any songs rank for more than one year?
what is the most common word in #1-ranked songs?
i/me vs you more common?
which artist has most number ones?
make a list of all the #1s
End of explanation
"""


(df['Lyrics'].value_counts())

"""
Explanation: what is the most common word in #1-ranked songs?
End of explanation
"""


(df['Artist'].value_counts())

"""
Explanation: make a list of all the #1s
End of explanation
"""


list(df['Rank'].groupby(df['Artist']))
#list(df['preTestScore'].groupby(df['company']))

"""
Explanation: which artist has most number ones?
End of explanation
"""


