A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code
Latest commit
Files
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
Local analysis of complete spotify streaming dataset (endsong_*.json). Made in 3 hours alongside with chatGPT, fixing bugs as they appeared.
That’s a whole lot of data
# deps $ pip install geoip2 basemap pandas matplotlib # get geodb for local ip lookup $ curl -L -o city.mmdb https://github.com/lysenkobv/maxmind-geolite2-database/raw/master/city.mmdb # create sqlite3 database from json dump $ python makedb.py datafolder/ # run analysis ! $ python map-ips-city.py
$ python top-cities.py
df city country count
20 Berlin Germany 2629
...
$ python top-songs-per-country.py
DE La femme d'argent Air
DE Piano Concerto No. 3 in D Minor, Op. 30: I. Allegro ma non tanto Sergei Rachmaninoff
DE La mer, L. 109: II. Jeux de vagues Claude Debussy
DE Samba da Bencao Bebel Gilberto
DE Merry Christmas Mr. Lawrence Ryuichi Sakamoto
DE WEIGHT OFF KAYTRANADA
...
