Spotify Interview problem solved using Python | US Tracks Dominance

In this video we will discuss an interesting and cool advanced analytics problem asked in a Spotify. In this problem we have to find number of days a US track has stayed in the 1st position for both the US and worldwide rankings on the same day. Link to the dataset https://github.com/Hitesh-Damani/datascience_interviews_dataset/blob/6f22afa9fd083a8657afb3ddcbd7b5edd3eaa930/spotify_worldwide_daily_song_ranking.csv https://github.com/Hitesh-Damani/datascience_interviews_dataset/blob/6f22afa9fd083a8657afb3ddcbd7b5edd3eaa930/spotify_daily_rankings_2017_us.csv Link to SQL Solution https://www.youtube.com/watch?v=agYySY-Bsg8 -------------------------------------------------------------------------------------------------- Support me by subscribing to my channel so that I can upload these kind of videos https://www.youtube.com/@hiteshdamani30 #python #dataanalysts #datascienceinterview #pythoninterviewquestions #ai #pythonfordatascience #pythonforbeginners #dataengineers #spotifyinterview