In this tutorial, we'll take data preparation to the next level by considering a variety of common data issues in the Spotify Top 200 rankings. We'll start off with multiple raw big data sets and end up with a single data frame ready for analysis!


Prerequisites


Learning Objectives


Support Needed?

For technical issues outside of scheduled classes, please check the support section on the course website.


1. Loading and Inspecting the Data

1.1 Merging Data

Spotify Charts has listed the daily top 200 most streamed songs by country since 2017. As you can see below, you can use the dropdown menus to change your selection, and clicking in the top right corner returns the data in CSV-format.