My Python script reads in raw data from the game's csv files, saves it to a database, reads from the database to calculate some stats for splits, and outputs batter and pitcher csv files.
name,year,team,pos,bats,pa,pa_l,pa_r,woba,woba_l,w oba_r,iso,iso_l,iso_r
Moritz Lingen,2019,POR,3B,R,618.0,201.0,417.0,0.363,0.401 ,0.345,0.257,0.297,0.239
Ian Zilberman,2019,POR,SS,R,572.0,185.0,387.0,0.302,0. 312,0.297,0.111,0.116,0.109
name,year,team,pos,throws,ip,ip_l,ip_r,era,era_l,e ra_r,xfip,xfip_l,xfip_r,k9,k9_l,k9_r,bb9,bb9_l,bb9 _r
Carlos Navarro,2019,POR,P,R,196.0,87.0,108.0,4.684,4.759, 4.667,4.292,4.36,4.247,6.75,6.931,6.667,2.526,3.10 3,2.083
Tom Warner,2019,POR,P,R,138.0,60.0,77.0,4.304,4.35,4.3 25,4.231,4.028,4.401,7.435,7.35,7.597,1.957,0.9,2. 805
Then, I slice and dice the data inside my spreadsheet. Certainly, the game provides a lot of tools to keep track of this information. Using my own notes, I can do things like sort by lineup, mark star players, and research matchups.
I'm still trying to figure out an ideal workflow because the update operation takes 1 minute per team and ~30 minutes to calculate the csv files for the entire league. I plan to update stats every few months during the current season.
I've found that taking the time to sit back and explore the data that the game generates is really immersive and fun! I love the suggestions in this thread and seeing how you all play the game. I have started to incorporate some of these ideas into my workflow. For instance, before, I would never really keep track of the star players of other teams and just focused on building up my own team. Then, I noticed what you all were paying attention to and keeping track of in your spreadsheets. By writing things down and observing the vast landscape, I am better enjoying the dynamic game of baseball.
Also, stats-only is hard, and I will take any edge that I can get.
