Does anyone use SQL/Python/etc to handle/evaluate players in OOTP?

[MrDov]

I've recently taught myself SQL and am in the middle of learning Python and have struggled to find ways to practice those skills. I thought exporting various OOTP reports would be a good way to do it, however I'm struggling to think of productive ways to do it and improve my game experience. Does anyone export OOTP reports and what sort of work do you do on those reports to improve your GM abilities?

[stealofhome]

Check out cavebutter's thread here: http://www.ootpdevelopments.com/boar...d.php?t=288581

And also his blog with lots of info too: http://ootp.cavebutter.net/blog

[drhay53]

I use python to scrape things from the html reports that can be dumped. In fact, I have a bug report out now because you can't get a full league with minors report without it automatically getting set to paginated, which means I can't dump players to a file where the ratings are determined by my scout (there may be a way to do it with csv's, but I already have an html scraper set up).

I dump all kinds of things to the html reports and then do all kinds of operations on them. I use the python package Beautiful Soup to do the scraping:
https://www.crummy.com/software/BeautifulSoup/bs4/doc/

I can answer simple questions if they ever come up, but my code for OOTP is probably pretty indecipherable to other people. It's a bit of a mess.

Edit: here are some of the things I do:
- dump ratings and rolled up value stats (WAR, FIP-, wRC+, ZR, etc), then perform a linear regression to determine the value of each rating.
- dump career and season statistics and use that to algorithmically set a batting order
- estimate the dollar value of WAR on the free agent market
- quickly get a glance at the best players available according to my own evaluation, which weights personality and injury history in addition to ratings, during the draft, or during a trade with a certain team, or for international FA, etc.