Quote:
Originally Posted by NoOne
you should look into setting the data up in a db, then make various report templates that query the data and fill everything in for you. absolutely no effort or work required after you set it up.
|
Quote:
Originally Posted by Rizon
The DB way is interesting (MS Access?). Do you have any examples with data so I can see it in action?
|
Thanks to NoOne and Rizon, I got inspired to sit down for a weekend and code a Python script to read in CSV files, use PyMongo to save the raw data to MongoDB, and then query the raw data from MongoDB to calculate stats.
I wanted an easier way to see wOBA, ISO, and xFIP splits for my entire fictional league. It's not user-friendly at all and runs from the command line.
Also, compare the game save file to the database size.
3.7G braves.lg/
ootp_braves 0.953GB
Source code and example output can be found here.
https://github.com/namtsui/ootp