{"id":136,"date":"2017-09-28T13:16:35","date_gmt":"2017-09-28T20:16:35","guid":{"rendered":"http:\/\/www.ootp.cavebutter.net\/blog\/?p=136"},"modified":"2017-09-28T13:16:35","modified_gmt":"2017-09-28T20:16:35","slug":"batting-stats-1-the-easy-stuff","status":"publish","type":"post","link":"http:\/\/www.ootp.cavebutter.net\/blog\/archives\/136","title":{"rendered":"Batting Stats 1: The Easy Stuff"},"content":{"rendered":"

The goal here is to create a table (or view) for all offensive stats for each player-year-stint-split. \u00a0Let’s go back and parse that briefly: \u00a0Stats are collected for each player who accumulates them. \u00a0Each player gets his own row. \u00a0For each year that a player accumulates stats, a new row of data is created for that player. \u00a0For each team that a player plays in a given year (stint), a new row of data is created for that player. \u00a0Stats are accumulated and placed into three splits for each player-year-stint: Overall, vs. Left, and vs. Right.<\/p>\n

I will most likely create views for each split, but for the moment I am going to focus only on Overall (split_id=1)<\/code>.<\/p>\n

As this view is where I have gotten tripped up in the past, I’m going to take it slowly here, checking against game data periodically. \u00a0So, easy bit first: Let’s get the counting stats and the more traditional rate stats out of the way:<\/p>\n

#Calculated batting stats for OOTP\r\n    CREATE OR REPLACE VIEW CalcBatting AS\r\n\r\n    SELECT b.year\r\n    , b.league_id\r\n    , b.player_id\r\n    , b.stint #We can eventually move this down the list\r\n    , b.split_id #We can eventually remove this\r\n    , b.team_id #We can eventually move this down the list\r\n    , l.abbr as Lg\r\n    , t.abbr as Team\r\n    , b.g\r\n    , b.ab\r\n    , b.ab+b.bb+b.sh+b.sf+b.hp as PA\r\n    , b.r \r\n    , b.h\r\n    , b.d\r\n    , b.t\r\n    , b.hr\r\n    , b.rbi\r\n    , b.sb\r\n    , b.cs\r\n    , b.bb\r\n    , b.k\r\n    , b.ibb\r\n    , b.hp\r\n    , b.sh\r\n    , b.sf\r\n    , b.gdp\r\n        FROM \r\n      players_career_batting_stats b \r\n      INNER JOIN leagues l ON b.league_id=l.league_id \r\n      INNER JOIN teams t ON b.team_id=t.team_id\r\n    WHERE b.ab<>0 AND b.split_id=1\r\n    ORDER BY b.player_id, b.year<\/code><\/pre>\n
We’ll pick a random player from in-game and make sure we line up. \u00a0Let’s pick player #14 from 2015 and compare to OOTP. \u00a0Not expecting any problems on the easy stuff. \u00a0Still, just to be sure.<\/p>\n
\"\"<\/a>
Output from calcbatting<\/figcaption><\/figure>\n
\"\"<\/a>
Frank Garcia<\/figcaption><\/figure>\n
So far so good. \u00a0Next post will finish up with the standard stats and some of the easier advanced stats.<\/p>\n","protected":false},"excerpt":{"rendered":"
The goal here is to create a table (or view) for all offensive stats for each player-year-stint-split. \u00a0Let’s go back and parse that briefly: \u00a0Stats are collected for each player who accumulates them. \u00a0Each player gets his own row. \u00a0For each year that a player accumulates stats, a new row of data is created for… Continue reading Batting Stats 1: The Easy Stuff<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[25],"tags":[14,7,4,22,24],"class_list":["post-136","post","type-post","status-publish","format-standard","hentry","category-batting","tag-batting","tag-mysql","tag-ootp","tag-players","tag-view"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t