baseball_sql
SQL scripts for working with the baseball data from retrosheet and baseball-databank, as provided by boxball (by sdvinay)
Marcels
Implemented the 2022 Marcel Projections in Python (by jack-kelly-12)
baseball_sql | Marcels | |
---|---|---|
4 | 3 | |
2 | 1 | |
- | - | |
5.7 | 10.0 | |
3 months ago | over 1 year ago | |
Jupyter Notebook | Jupyter Notebook | |
- | - |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
baseball_sql
Posts with mentions or reviews of baseball_sql.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-08.
-
Looking for feedback on my implementation of the Marcel Projections in Python
You'll pick up on this stuff as you read and write more code, and your code will become simpler. Inspired by your work, I took my own pass at implementing Marcels today. Feel free to take a look and ask me any questions.
-
[Brenden] Feel free to correct me if I'm wrong, but I think it's safe to say this is the first time in MLB history that the winning pitcher of game 1 in a doubleheader is the starting catcher of game 2.
If you do check it out, and use python/pandas, here is some code I wrote to make the Retrosheet game log data more usable (cells 1-6 specifically). It corrects some inconsistencies in column names, and adds useful columns like year, game_id, game type.
-
In honor of Tony’s birthday here are a few crazy Tony Gwynn stats
If anybody is curious, my code and details are here.
-
Finding a player's stats through N games
I started with SQL and then moved to python/pandas. And basically it just took a lot of practice; any time I hear a fun fact or trivia question, I see if I can replicate it myself. Even if I know something is easy to do with Stathead, I've forced myself to code it myself. I moved on to harder and more interesting stuff, like component park factors, aging curves, umpire effects, etc. Some of my code is here.
Marcels
Posts with mentions or reviews of Marcels.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-08.
-
Looking for feedback on my implementation of the Marcel Projections in Python
To anyone interested, thanks to JamminOnTheOne, I fixed my method of regressing to the mean and released .csvs for 2022 and 2023 Marcel projections. I also added a general script that outputs the Marcel projections from user input of year. https://github.com/jack-kelly-12/Marcels/tree/main
-
Marcel's Projections in Python
Thanks for the help guys! I implemented my first version of the 2022 Marcels here if you're interested: https://github.com/jack-kelly-12/Marcels
What are some alternatives?
When comparing baseball_sql and Marcels you can also consider the following projects:
boxball - Prebuilt Docker images with Retrosheet's complete baseball history data for many analytical frameworks. Includes Postgres, cstore_fdw, MySQL, SQLite, Clickhouse, Drill, Parquet, and CSV.