Get tempo metadata (or any of Spotify's metrics) for tracks from Billboard lists and make a handy Excel spreadsheet.
You'll need numpy, scipy, xlsxwriter, billboard.py, and spotipy all set (including client ID and client secret for Spotify's API)
This is a relatively straightforward way of getting the BPM tempo tags of tracks from Billboard lists. It will iterate for however many weeks and chart positions you want.
You can also change 'tempo' for any of Spotify's tagged attributes (like 'danceability' or 'valence'), and can change 'hot-100' to any of Billboard's other lists (like 'r-b-hip-hop-songs' or 'country-songs')
A few little issues:
Spotify's BPM data can be odd, mostly in that the algorithm often finds strange tactus levels that are twice as fast as the "real" beat. There are also, of course, tracks missing from Spotify's collection. This script has some inelegant solutions to both (halving any tempo above 200 [or whatever upper limit you deem acceptable] and subsituting a median tempo for missing metadata).