![]() After cleaning the dataset and getting rid of irrelevant information, the dataset was ready to be uploaded to Tableau Public. The Spotify dataset was downloaded as a CSV file and uploaded to Openrefine. Openrefine is an open source web-based program that allows users to clean and manipulate datasets. ![]() According to the data set’s creator, the songs were scraped using BeautifulSoup from, and the additional song features were calculated using a python library called Spotipy. In addition to the data set having the song title, artist, and rank on the chart, the dataset also included different measures such as danceability, popularity, energy, tempo, and valence, just to name a few. ![]() After sifting through many unfinished datasets and ones with questionable credibility, I came across a dataset on that featured all of Spotify’s weekly top 200 songs from 2020-2021. The initial step in this process was finding a reliable dataset that could be used to create the visualization. There were three main steps to getting the final visualizations: the first was finding a data set on a public database, cleaning the data with Openrefine, and then creating the visualizations with Tableau Public. It is important to point out that this lab will not be focused on specific songs and genres, but rather the characteristics of each song. The dataset that was used for this lab includes all of the weekly top 200 songs from 2020-2021 according to Spotify. Through visualizations, we will explore key characteristics of songs to find the most popular combinations and when these characteristics are most popular. In this second lab, we were asked to create a visualization using Openrefine and Tableau Public. ![]() These more discrete factors that make up a song could give us some key insight into what makes a song a top global hit. But, when we look at the top charts and trending songs, what traits do they have in common? What makes a song so popular that it captures global attention? There are so many different factors that go into a song and make it the way it is, whether it’s the tempo, the length, or the musical key. At this point, we all know which artists and songs will be crowding the top charts.
0 Comments
Leave a Reply. |