The dataset was extracted from http://organizeyourmusic.playlistmachinery.com/. After cleaning the dataset, 3 Questions are asked and those questions are answered using Visualisation in MS Excel. The following are the attributes and their meaning:
1)ID- Song ID
2)title- Song's title
3)artist- Song's artist
4)top genre- the genre of the track
5)year- Song's year in the Billboard
6)bpm (Beats.Per.Minute)- The tempo of the song.
7)nrgy: Energy- The energy of a song - the higher the value, the more energtic. song
8)Dnce: Danceability - The higher the value, the easier it is to dance to this song.
9)dB Loudness..dB.. - The higher the value, the louder the song
10)live Liveness - The higher the value, the more likely the song is a live recording
11)val Valence - The higher the value, the more positive mood for the song.
12)dur Length - The duration of the song.
13)acous Acousticness.. - The higher the value the more acoustic the song is.
14)spch Speechiness - The higher the value the more spoken word the song contains.
Following Questions are asked:
Question-1) Which Artist had the most songs from 2010-2019?
Question-2) Which Genre has the most songs from the year 2010-2019?
Question-3) Which Genre has the Max BPM and Energy?