I created this graph to help answer which songs rank No.1 for more than 10 weeks. Weeks ranked No.1 is the most important variable for my focus and thus my first step was to remove songs whose week position is not 1. Then I grouped by song_id to compute the total weeks ranked No.1 for each song. y-axis was restructured to rank the songs from the longest to the shortest time. Old Town Road ranked No.1 for the longest time (almost 20 weeks), followed by One Sweet Day and Despacito for 16 weeks. The total weeks on chart (ranked top 100) is also included. Although Macarena is not in the top 3, it was on chart for the longest time. There seems to be no relationship between weeks on chart and weeks ranked No.1.