An end-to-end data pipeline that extracts Spotify user data via the API, transforms and stores it in a database, and can be queried to create analytics

Exact

Exact Union RegExp

dcbozada c59e73e8a6 updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again		2026-03-17 03:02:01 -04:00
__pycache__	updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again	2026-03-17 03:02:01 -04:00
.env.example	updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again	2026-03-17 03:02:01 -04:00
.gitignore	incorporating .gitignore file for api key safety	2025-12-17 10:10:46 -06:00
albums.json	updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again	2026-03-17 03:02:01 -04:00
api.py	added ignore_index to df concat so index rests in get_albums()	2026-03-10 23:53:42 -04:00
artists.json	updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again	2026-03-17 03:02:01 -04:00
CLAUDE.md	updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again	2026-03-17 03:02:01 -04:00
etl.py	Got album dict/df added, 20 limit so need to call endpoint 2 more times and concat the other 2 df's	2026-03-09 22:37:07 -04:00
get_token.py	added api.py to keep main.py clean, it handles all requests to spotify end points	2026-03-10 23:44:29 -04:00
listening_history.json	updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again	2026-03-17 03:02:01 -04:00
main.py	updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again	2026-03-17 03:02:01 -04:00
start_db.sh	updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again	2026-03-17 03:02:01 -04:00
tracks.json	updated .env example to include examples of what's needed to create docker setup, created spotify postgres db in docker and tested connection to it. also created the shell script start_db.sh for initial creation of db if this repo is cloned and to start the db back up again	2026-03-17 03:02:01 -04:00