<aside> <img src="/icons/light-bulb_purple.svg" alt="/icons/light-bulb_purple.svg" width="40px" />
Goal
I embarked on this project after discovering that Spotify allows users to request their personal data. As a music enthusiast and regular Spotify user, I found the opportunity to delve into a year's worth of my listening data intriguing. Exploring how my data was collected and analyzed to generate 'Spotify Wrapped' added an additional layer of fascination to the project.
Process
The data was gotten from Spotify's official website in JSON format. While the files included various account and profile information, my primary focus lay on the 'Streaming History' and 'Playlist' files as the contained 15,000+ records of data. Subsequently, I converted and combined the data from the 'Streaming History' files in using Excel, before loading and refining it in Python for comprehensive cleaning and analysis using pandas.
Insights
Here are some interesting insights I obtained from my analysis:
<aside> <img src="/icons/checkmark_purple.svg" alt="/icons/checkmark_purple.svg" width="40px" /> I listened for approximately 45,000 minutes between July 2022 and July 2023.
To get this result, I summed up the minutes played column after converting the milliseconds column.
45,000 minutes might seem like a lot but:
45,000 minutes ⇒ 750 hours ⇒ 31.25 days
With 365 days in a year, this tells me that I don’t listen to music enough and I need to up the ante to be a top listener.
Code for millisecond conversion:
</aside>
<aside> <img src="/icons/checkmark_purple.svg" alt="/icons/checkmark_purple.svg" width="40px" /> I listened to an average of 59 tracks a day in 2022, and 51 tracks in 2023.
I found this result interesting because in the latter part of 2022, I started my Master’s degree so the extra work explains why I wasn’t listening to as many songs per day.
</aside>
<aside> <img src="/icons/checkmark_purple.svg" alt="/icons/checkmark_purple.svg" width="40px" /> The day I listened to the most artists was April 30th, 2023.
This shows that on this day I spent a lot of time on the platform, so I was able to discover new music from new artists.
</aside>
<aside> <img src="/icons/checkmark_purple.svg" alt="/icons/checkmark_purple.svg" width="40px" /> The playlist with the most songs was “Liked from Radio.”
This playlist contains songs that I like from Spotify’s recommendations. Clearly, Spotify knows me well. Maybe a little too well.
</aside>