Data

Tools

Indexes

Applications

Experiments

Open Source Science

https://github.com/arvkevi/walkup

Create a spotify playlist from MLB walkup songs

https://github.com/arvkevi/walkup

Science Score: 26.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ○
    CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Academic email domains
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (6.6%) to scientific vocabulary
Last synced: 10 months ago · JSON representation

Repository

Create a spotify playlist from MLB walkup songs

Basic Info
  • Host: GitHub
  • Owner: arvkevi
  • License: mit
  • Language: Jupyter Notebook
  • Default Branch: main
  • Homepage: https://walkup.streamlit.app
  • Size: 387 KB
Statistics
  • Stars: 0
  • Watchers: 2
  • Forks: 0
  • Open Issues: 1
  • Releases: 0
Created over 2 years ago · Last pushed 11 months ago
Metadata Files
Readme License

README.md

MLB Walk-Up Songs Database

This repository contains data and scripts for managing a database of MLB walk-up songs.

Setup Instructions

Local Database Setup

  1. Make sure PostgreSQL is installed on your system.
  2. Install the required Python packages:

pip install -r requirements.txt

  1. Create a local PostgreSQL database:

createdb mlb_walk_up_songs

  1. Load the data from the CSV file:

python load_data.py

AWS RDS Setup

  1. Edit the .env file with your AWS credentials:

AWS_ACCESS_KEY_ID=your_access_key AWS_SECRET_ACCESS_KEY=your_secret_key AWS_REGION=us-east-1 RDS_USERNAME=postgres RDS_PASSWORD=your_password RDS_SECURITY_GROUP=your_security_group_id

  1. Run the AWS RDS setup script:

python aws_db_setup.py

Database Schema

The mlb_walk_up_songs table has the following columns:

  • player: Player name
  • song_name: Name of the walk-up song
  • song_artist: Artist of the song
  • team: Player's team
  • walkup_date: Date when the walk-up song was used
  • spotify_uri: Spotify URI for the song
  • explicit: Boolean indicating if the song has explicit content

Usage

You can connect to the database using the following connection string:

  • Local: postgresql://localhost:5432/mlb_walk_up_songs
  • AWS RDS: The endpoint will be displayed after running the AWS RDS setup script.

Owner

  • Name: Kevin Arvai
  • Login: arvkevi
  • Kind: user
  • Location: Washington, D.C.

Data science & clinical genomics

GitHub Events

Total
  • Delete event: 1
  • Push event: 39
  • Pull request event: 2
  • Create event: 1
Last Year
  • Delete event: 1
  • Push event: 39
  • Pull request event: 2
  • Create event: 1