TLDR; Looking to build an app to help with my fantasy football league. While I can use the Sleeper API to pull most of the league info, I will have to scrape the player's dollar value from each team's league page. What should my tech stack be?
Web App Goals:
Grab each team's rosters via Sleeper API.
Grab each rostered player's dollar value, most likely via scraper.
Grab the transaction history of each rostered player.
Calculate how many seasons a player has been on a roster.
Calculate how much a total roster "costs." For example, Add all of a team's players' values together, then subtract from the team budget of $200.
I run a relatively complicated 10-team dynastic contract league on Sleeper.app. Currently, I use a series of Google Sheets to manage contract lengths, player values, team budgets, etc. Here's a viewable copy of the spreadsheet: https://docs.google.com/spreadsheets/d/1nMVwXi9Vl34TdzprooGMHdlUWRlnaIRJVcX5PzmnzmU/edit?usp=sharing. While I can pull most of the information via the Sleeper API, I've read the Sleeper API documentation from front to back. I can't get player values without manually inputting them or using a web scraper.
I am starting to build an app to help manage all of this, and I understand Python is the best way to handle this. Usually, I update each team's player values and budget about a month before our rookie draft, but I would like to keep each team's budget up to date on at least a weekly basis to make this process less of a grind for me.
Some background: I am a front-end developer and designer who is very comfortable with command lines on a Mac or a PC. I have experience running Docker and built a simple web scraper 9 or 10 years ago.
Rosters as of 12/16/22
Key:,Contract Ended,Key:,Taxi squad eligible
Last Year of Contract
Position,Player Name,Year and Method Aquired,Initial Cost,23-24 Cost,Taxi Squad Eligible,Keeper
Contract Start,Last Year of Contract,20-21,21-22,22-23,23-24,24-25
Lizzy,Remaining Budget,Upcoming Keeper Tota...