Skip to content

Ash-180/Visualisation-Using-Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 

Repository files navigation

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?

About

Data Visualisation using Excel

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published