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. (by droher)
pybaseball
Pull current and historical baseball statistics using Python (Statcast, Baseball Reference, FanGraphs) (by jldbc)
Our great sponsors
| boxball | pybaseball | |
|---|---|---|
| 7 | 33 | |
| 110 | 1,123 | |
| - | - | |
| 5.5 | 4.6 | |
| 4 months ago | 4 days ago | |
| Python | Python | |
| Apache License 2.0 | MIT License |
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.
boxball
Posts with mentions or reviews of boxball.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-01-31.
-
Importing Retrosheet to Tableau or Power BI
I haven't worked with BI tools, but I'll make the same recommendation for Retrosheet data that I always do: check out the Boxball distributions, specifically the CSV files (or the parquet files if you prefer). You can load those right in, rather than futzing with Retrosheet's event files and processing them manually, etc., just to get to the same spot.
-
Delta Aging Curve Python
The original data source is the Baseball Databank (aka "The Lahman Database"). I use the Boxball distributions, which include both retrosheet and Baseball Databank data.
- What's the current standard for getting mlb data into a database? I used to use Baseball On a Stick (which accessed the old gameday data) but that doesn't work now. I found "mlbdata" which accesses the mlb API but I can't figure out how to make it put stuff into a database. Is there a good option?
-
How do I compile a list of a team's games where event x did not happen?
You know, I thought about that after posting, that the dailies might not be available directly from retrosheet. I use the Boxball distributions, which take the retrosheet data and process it into database images. These distributions include a "daily" table with the daily logs. So apparently Boxball is generating that table.
-
Aggregate Game Logs
I used to think the same thing, and then I found the Boxball pre-built images. You still have to be a bit handy to get them working, but it's way easier than starting from scratch with raw retrosheet data. I initially used the postgres image and worked in SQL, and then switched to python/pandas and the parquet files.
-
Finding a player's stats through N games
I've always been good with data, math, Excel, etc., but decided to take it to another level during the pandemic. The most difficult thing about Retrosheet data is getting into a usable format. Luckily, the boxball project has created a number of ready-to-download images with all of the data, for different database technologies.
-
RE24 Data for wOBA Calculations
For Retrosheet data, I've been using pre-built images from Boxball, rather than going through the whole process of downloading and converting the files from retrosheet. The Boxball images are awesome. I mostly use the Parquet files for Pandas, but they have other formats (e.g., postgres Docker images, CSV, etc) there.
pybaseball
Posts with mentions or reviews of pybaseball.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-04-24.
- pybaseball help
- Best baseballdata source for datascraping
-
Baseball Savant API
pybaseball and MLB-StatsAPI are the go-to python wrappers for the official MLB API.
- Data sources for MLB ABs?
-
Looking for Spray Angle Data from this season (preferably)
I think pybaseball includes spray angle in their statcast() data frame! And if not, there definitely is the (x,y) location of where the ball landed, so you could probably do some trig to calculate that too.
-
Anyone willing to help create a webscrape for first pitch data?
Check out the docs here: https://github.com/jldbc/pybaseball/blob/master/docs/playerid_reverse_lookup.md
-
Python Code help
I think a lot of what you're looking to do though can be accomplished a bit easier by utilizing pre-existing Python libraries like Pybaseball.
- Help running pybaseball commands in Python
-
MLB Stats API Application time?
most folks without direct access to mlb's api scrape baseball savant's data api. packages like baseballr or pybaseball can help with this. remember, this is in the open on a trust model: no commercial use, and don't hammer the api.
-
Where to get started analyzing basic baseball metrics
And if you’re using Python, it’s pybaseball I believe. https://github.com/jldbc/pybaseball
What are some alternatives?
When comparing boxball and pybaseball you can also consider the following projects:
ElectroCRUD - Database CRUD Application Built on Electron | MySQL, Postgres, SQLite
MLB-StatsAPI - Python wrapper for MLB Stats API
chadwick - Chadwick tools for manipulating baseball data
baseballr - A package written for R focused on baseball analysis. Currently in development.
baseball_sql - SQL scripts for working with the baseball data from retrosheet and baseball-databank, as provided by boxball
sports.py - A simple Python package to gather live sports scores
mara-pipelines - A lightweight opinionated ETL framework, halfway between plain scripts and Apache Airflow
condenser - Condenser is a database subsetting tool
strat-o-rama - Generating plausible Strat-O-Matic cards from MLB data
baseball-pi - Get the live box score, plays, and batter stats of your favorite MLB team right on your desktop.