Python

1. How many songs mention life, war, & love by searching the song title only.

2. Write a function to receive any word as input, search the song titles only and return the number of top billboard songs that contain that word. Requirements:

function should receive any word or phrase as an input string & return a simple message with the number of songs that contain those words. E.g. [6] songs were found to contain [supplied phrase] in this dataset//// If the words or phrase supplied were not found, return the message No songs were found to contain the words: [supplied phrase] //// Deal with whatever letter case you are supplied i.e. all caps or all lowercase. ///// Test your function with the word like and confirm that your result reads [100] songs were found to contain [like] in this dataset

3. Identify the most common words in lyrics of TOP TEN SONGS ONLY from the dataset. Please write down the 20 most common words you identify from the lyrics of top ten songs.

4. Write a function to receive an artist name as input, search the dataset and return information about that artist from the database. Requirements:Function should receive an artist name as an input string and return (1) their average billboard ranking rounded up to a whole number, & (2) a list of their songs from the list of top 100./// Songs that they are featured in should also be retrieved /// If the artist name supplied is not found in the database, return the message No top 100 song found for the artist: [supplied artist name]./// Deal with all caps or all lowercase//// Consider the file type of EV&ERY row of information when writing out your function.

Data (excel comma splice csv - must be imported)

data https://raw.githubusercontent.com/walkerkq/musiclyrics/master/billboard_lyrics_1964-2015.csv