Update MySQL Vintage Metagame DB

vintage-db-script
vintage-db-script2

Github Link, Jupyter Notebook

  • Download latest MTGO Vintage metagame data from community maintained Google Sheet.
  • Clean, format, and save data to .csv.
  • Insert new records to MySQL database.
  • Required Inputs: Google Sheets ID, MySQL Login.

Multifaced Card Data

multifaced-cards-script

GitHub Link

  • Pull names of Split, Transform, DFC, MDFC, Adventure cards using Scryfall API.
  • Stored in .txt file.
  • Used as an input for MTGO-Tracker.

ESPN Fantasy Football, Weekly Scores Scraper

ff_script

Github Link

  • Download weekly scores and matchups from ESPN Fantasy Football leagues and save to .csv.
  • Login will be prompted for if league is not set to public.
  • Approximate run time: 2 minutes/year.
  • Required Inputs: League ID, Year, and Total Scoring Periods (Regular Season Weeks + Post-season Rounds).

MTG Goldfish, Decklist Scraper

mtggoldfish-script

Github Link

  • Scrapes MTGGoldfish.com for uniquely named decklists with 2 or more occurrences.
  • Saves lists as .txt files separated into folders by Month.
  • Saves an ALL_DECKS file for use with MTGO-Tracker.
  • Required Inputs: Month (YYYY-MM), Format.

Chess PGN Parser, PGN-to-CSV

pgn

Github Link

  • Parses all .pgn files in script folder location.
  • Creates a table with each record representing individual chess moves and resulting board state.
  • Saves table as .csv file.
  • Required Inputs: Folder containing one or more .pgn files and script file.