How to Find Data for the Best Music of the Past
Getting Started With Data.World
Data.world is a social platform for finding and sharing data sets. It allows you to create projects that use publicly available data. It also has a ton of integrations that allow it to work with many popular tools. On top of all that, it has a very generous free tier for personal use.
Start by creating an account. After you've signed in, get the music list by using the search box in the center of the page at the very top. Search for "Billboard hot weekly charts" and select the option that has thousands of bookmarks.
Start by bookmarking the dataset so you can easily find it again later.
If you scroll down, you'll see that there are two files. There is a CSV (comma-separated values) file with detailed information on the music charts themselves.
The Excel file, on the other hand, has lots of interesting information about the music from Spotify. There are many different ways you can import this data into Spotify, but Soundiiz works best.
There are about 30,000 songs in those datasets. Chances are, you won't like them all, so you'll need to sort through the data.
Sifting Through The Musical Data
As mentioned, there are two great sets in the hot weekly chart project. One covers Billboard data, and the other covers Spotify data.
Looking At The Billboard Data
For data about the best music, you'll need to open the HotStuff.csv file. This file includes actual data from the Billboard Hot 100 Charts dating all the way back to 1958.
You can sort the columns to help you find the most popular songs by date and chart position. The list has over 300,000 songs, so it may take some time to load.
You can then sort the data however you want using the more advanced options available in spreadsheet programs.
It may still be a little bit slow to sort and navigate through the data. But once it fully loads, it'll become easier to scroll through.
Exploring The Spotify Data
The Spotify dataset is located in the "Hot 100 Audio Features.xlsx" file, and has a lot of nifty information about the songs. The columns include information like danceability and popularity (according to Spotify).
This dataset is only about 30,000 records, so it should be much more responsive, and you won't need to export it.
Geeking Out With The Data
If you know SQL, you're in luck because that's where Data.world really shines! There is a feature that lets you search any dataset with basic SQL commands.
Let's say that you want to see every song by Adele that hit the top 10. First, you'd select query from the upper right-hand corner of the data view. Then, you'd type in your SQL query and click Run query, also in the upper right-hand corner.
Related Courses And Certification
Android Programming Course and Certification
Internet Technologies Course and Certification
Internet Marketing Course and Certification
