Analyze one year of radio station songs with SQL, Spark, Spotify, and Databricks

One crazy data scientist set out to answer the question that we've all wondered: didn't I just hear that song two hours ago? The author scraped websites of four French radio stations, then enriched the data via the Spotify API. The results are really fascinating. The #1 French radio station repeats their songs an average of 3.5 times per day and allocates fully 15 minutes out of every hour to commercials.

This research is exhaustive, and was definitely a ton of work to produce. Very impressive.


Want to receive more content like this in your inbox?