Newbook
Spotify Database Daily Charts Over 3 Years
Introduction
In this project, we will analyze the Spotify Huge Database Daily Charts Over 3 Years from Kaggle.This huge dataset contains all the songs in Spotify's Daily Top 200 charts in 35+1 (global) countries around the world for a period of over 3 years (2017-2020). The data set can be viewed using this link:
https://www.kaggle.com/datasets/pepepython/spotify-huge-database-daily-charts-over-3-years?select=Final+database.csv
Exploratory Data Analysis (EDA)
Exploratory Data Analysis is a process of examining or understanding the data and extracting insights or main characteristics of the data. EDA is generally classified into two methods, i.e. graphical analysis and non-graphical analysis.
EDA is very essential because it is a good practice to first understand the problem statement and the various relationships between the data features before getting your hands dirty.
Kaggle
Kaggle, a subsidiary of Google LLC, is an online community of data scientists and machine learning practitioners. Kaggle allows users to find and publish data sets, explore and build models in a web-based data-science environment, work with other data scientists and machine learning engineers, and enter competitions to solve data science challenges.
Here is an outline of the steps we'll follow:
- Downloading a dataset from an online source Kaggle.
- Data preparation and cleaning
- Exploratory Analysis and Visualization.
- Asking and Answering questions.
- Summary
- Inferences and conclusion.
- Reference
"Final Database" includes many data for each song. It aggregates the populairty for songs into a single score for each. For each song several variables were retrieved by using Spotify's API (such as artist, country, genre, …)
Use the "Run" button to execute the code.
Download and Read the Data
!pip install opendatasets --upgrade --quiet
import opendatasets as od download_url = 'https://www.kaggle.com/datasets/pepepython/spotify-huge-database-daily-charts-over-3-years?select=Final+database.csv'
od.download(download_url)Please provide your Kaggle credentials to download this dataset. Learn more: http://bit.ly/kaggle-creds
Your Kaggle username: ritusingh1510
Your Kaggle Key: ··········
Downloading spotify-huge-database-daily-charts-over-3-years.zip to ./spotify-huge-database-daily-charts-over-3-years
100%|██████████| 191M/191M [00:01<00:00, 108MB/s]
data_filename = './spotify-huge-database-daily-charts-over-3-years/Final database.csv'