This project analyzes Gesaffelstein and The Weeknd's tracks using data fetched from the Spotify API. It stores key track details like popularity, duration, and album information in a MySQL database and uses Python for data extraction. SQL queries are employed to analyze trends, track performance, and clean up duplicate data.
Project Overview This project analyzes Gesaffelstein and The Weeknd's tracks using data fetched from the Spotify API. It stores key track details such as popularity, duration, and album information in a MySQL database. Python is used for data extraction, and SQL queries are employed to analyze trends, track performance, and clean up duplicate data.
Technologies Used Python (for data extraction and analysis) Spotipy (Spotify API wrapper) MySQL (for data storage) SQL (for querying and data analysis)