Data Pre-Processing

Data Sources for this Kernel

  1. Spotify’s Worldwide Daily Song Ranking This dataset contains the daily ranking of the 200 most listened songs in 53 countries from 2017 and 2018 by Spotify users. It contains more than 2 million rows, which comprises 6629 artists, 18598 songs for a total count of one hundred five billion streams count. The data spans from 1st January 2017 to 9th January 2018 and will be kept up-to-date on following versions. It has been collected from Spotify’s regional chart data.

  2. Audio features of top Spotify songs of 2017 This dataset includes the names, artists, Spotify URIs and audio features of tracks from the Top Tracks of 2017 playlist. It covers attributes such as danceability, energy, key, loudness, mode, speechiness, acousticness, instrumentalness, liveness, valence, tempo, duration, time_signature.

Packages Used for the analysis.

  1. dplyr - For easily manipulating the dataset.
  2. ggplot2 - For creating good looking plots.
  3. countrycode - For looking up country names as the dataset only provides an abbreviated code for each country.
  4. rworldmap - For plotting data on a world map.

Dashboard

row

Artists Who Are Consistently in Top 10

row

Top 10 Artists

Artist In_top_10
Ed Sheeran 15546
Luis Fonsi 9122
The Chainsmokers 7038
J Balvin 6803
ZAYN 4994
Danny Ocean 4651
DJ Khaled 4504
Clean Bandit 3913
Kygo 3695
Dua Lipa 3450