Skip to content

Latest commit

 

History

History
21 lines (15 loc) · 1.29 KB

README.md

File metadata and controls

21 lines (15 loc) · 1.29 KB

Analyzing Spotify Listening History With Tableau!

In this repository, I've included some files that I used in order to analyze my Spotify listening history using Tableau Desktop! Hope you find it useful as well. You can view the dashboard I created here.

My Spotify Dashboard

How to use:

Pre-requisites:

  • Familiarity with PostgreSQL (and a running server/database)
  • Tableau (of course!)
  • Your technical Spotify listening information (obtained by emailing [email protected]).
  • A database GUI (i.e., DBeaver), if you prefer.
  1. Run create.sql to create the necessary tables in your database.
  2. Add your endsong_#.json files to the array on line 13 in insert_data.py. Also make sure to add the client id and client secret variables for the Spotify API (lines 66-67).
  3. Install the necessary packages and run insert_data.py! Make sure to ensure it is connected to your database properly.
  4. Set your database as a datasource in the Tableau workbook.
  5. Enjoy your listening history visualized!