Skip to content

Instantly share code, notes, and snippets.

View bdilday's full-sized avatar

Ben Dilday bdilday

45 followers · 1 following
View GitHub Profile
@bdilday
bdilday / retrosheet_events_2016.csv
Last active May 28, 2017 20:56
sample retrosheet data
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 1.
"GAME_ID","YEAR_ID","AWAY_TEAM_ID","INN_CT","BAT_HOME_ID","OUTS_CT","BALLS_CT","STRIKES_CT","PITCH_SEQ_TX","AWAY_SCORE_CT","HOME_SCORE_CT","BAT_ID","BAT_HAND_CD","RESP_BAT_ID","BAT_ON_DECK_ID","BAT_IN_HOLD_ID","RESP_BAT_HAND_CD","PIT_ID","PIT_HAND_CD","RESP_PIT_ID","RESP_PIT_HAND_CD","POS2_FLD_ID","POS3_FLD_ID","POS4_FLD_ID","POS5_FLD_ID","POS6_FLD_ID","POS7_FLD_ID","POS8_FLD_ID","POS9_FLD_ID","BASE1_RUN_ID","BASE2_RUN_ID","BASE3_RUN_ID","EVENT_TX","LEADOFF_FL","PH_FL","BAT_FLD_CD","BAT_LINEUP_ID","EVENT_CD","BAT_EVENT_FL","AB_FL","H_CD","SH_FL","SF_FL","EVENT_OUTS_CT","DP_FL","TP_FL","RBI_CT","WP_FL","PB_FL","FLD_CD","BATTEDBALL_CD","BUNT_FL","FOUL_FL","BATTEDBALL_LOC_TX","ERR_CT","ERR1_FLD_CD","ERR1_CD","ERR2_FLD_CD","ERR2_CD","ERR3_FLD_CD","ERR3_CD","BAT_DEST_ID","RUN1_DEST_ID","RUN2_DEST_ID","RUN3_DEST_ID","BAT_PLAY_TX","RUN1_PLAY_TX","RUN2_PLAY_TX","RUN3_PLAY_TX","RUN1_SB_FL","RUN2_SB_FL","RUN3_SB_FL","RUN1_CS_FL","RUN2_CS_FL","RUN3_CS_FL","RUN1_PK_FL","RUN2_PK_FL","RUN3_PK_FL","RUN1_RESP_PIT_ID","RUN2_R
@bdilday
bdilday / d3.sankey.js
Last active May 2, 2017 01:19 — forked from emeeks/d3.sankey.js
Sankey Particles III - d3v4
d3.sankey = function() {
var sankey = {},
nodeWidth = 24,
nodePadding = 8,
size = [1, 1],
nodes = [],
links = [];
sankey.nodeWidth = function(_) {
if (!arguments.length) return nodeWidth;
@bdilday
bdilday / results2017.csv
Last active March 27, 2017 00:40
2017KaggleMarchMadness_Results
Id team1 team2 result
2017_1112_1315 Arizona North Dakota 1
2017_1116_1371 Arkansas Seton Hall 1
2017_1124_1308 Baylor New Mexico St 1
2017_1137_1452 Bucknell West Virginia 0
2017_1139_1457 Butler Winthrop 1
2017_1153_1448 Cincinnati Kansas St 1
2017_1166_1348 Creighton Rhode Island 0
2017_1173_1455 Dayton Wichita St 0
2017_1181_1407 Duke Troy 1
@bdilday
bdilday / generateBattingMarcels.py
Created March 13, 2017 01:56 — forked from JeffSackmann/generateBattingMarcels.py
Generate a full season's worth of batting Marcel projections from past years' stats
## Generate a full season's worth of batting Marcel projections from past years' stats
from createTuple import createTuple ## gist: 778481
from writeMatrixCSV import writeMatrixCSV ## gist: 778484
def makeBatTable(r):
for stat in ['AB', 'H', 'D', 'T', 'HR', 'SO', 'BB', 'SF', 'HP', 'CI']:
if stat in r: pass
else: r[stat] = 0
if r['AB'] == 0:
@bdilday
bdilday / generatePitchingMarcels.py
Created March 13, 2017 01:56 — forked from JeffSackmann/generatePitchingMarcels.py
Generate a full season's worth of pitching Marcel projections from past years' stats
## Generate a full season's worth of pitching Marcel projections from past years' stats
from createTuple import createTuple ## gist: 778481
from writeMatrixCSV import writeMatrixCSV ## gist: 778484
def makePitTable(r):
for stat in ['AB', 'H', 'D', 'T', 'HR', 'SO', 'BB', 'SF', 'HP', 'CI', 'IPouts', 'R']:
if stat in r: pass
else: r[stat] = 0
ab = 0.9*r['IPouts'] + r['H']
@bdilday
bdilday / march_madness_nodes.csv
Created February 21, 2017 19:25
march madness bracket tree
game_number seed_high seed_low child_game_number
1 1 63 33
2 30 36 33
3 19 50 34
4 14 52 34
5 23 41 35
6 10 56 35
7 27 38 36
8 7 61 36
9 4 67 37
@bdilday
bdilday / pitching.metrics.ranks.csv
Last active January 21, 2017 01:21
comparison of pitching metrics from baseball reference & bpro
We can't make this file beautiful and searchable because it's too large.
"YEAR","NAME","RANK","LVL","AGE","G","GS","PITCHES","IP","IPStart","IPRelief","FIP","cFIP","ERA","DRA","PWARP","player_ID","WAR","WAA","IPouts","lg.dra","lg.era","lg.fip","lg.cfip","dra.minus","era.minus","fip.minus","cfip.minus","pwarp.per.inning","war.per.inning","era.rank","era.m.rank","dra.rank","dra.m.rank","fip.rank","fip.m.rank","cfip.rank","cfip.m.rank","pwarp.rank","pwarp.per.inning.rank","war.rank","war.per.inning.rank"
1968,"Bob Gibson",4495,"MLB",32,34,34,0,304.7,"304.7","0.0",1.93,69,1.12,1.9,8.51,"gibsobo01",11.24,8.6428,914,3.1796935736251,2.80775061774639,2.84043976293038,95.4706774366999,0.597541856158753,0.398895825334714,0.679472251159055,0.722734999400724,0.0279291106005907,0.0368927789934354,1,2,25,118,6,90,163,189,189,376,6,31
1985,"Dwight Gooden",4506,"MLB",20,35,35,0,276.7,"276.7","0.0",2.06,58,1.53,1.98,10.61,"goodedw01",12.15,9.7825,830,4.0327490848567,3.59918578955359,3.7396735848314,96.9331481491894,0.490980211844834,0.425096143811394,0.550850215472182,0.598350524123413,0.038344777
@bdilday
bdilday / AustralianTaxableIncome.csv
Created January 2, 2017 15:19
makeover monday week 1 data
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 5 columns, instead of 3 in line 9.
Gender Rank,Occupation,Gender,Individuals,Average Taxable Income $
795,Abattoir process worker; Meat process worker; Meatworker – meatworker’s labourer,Female,5961,36359
881,Abattoir process worker; Meat process worker; Meatworker – meatworker’s labourer,Male,17241,40954
699,Aboriginal and Torres Strait Islander education worker,Female,1386,40926
828,Aboriginal and Torres Strait Islander education worker,Male,636,44077
641,Aboriginal and Torres Strait Islander health liaison officer; Aboriginal and Torres Strait Islander health worker,Female,1878,43545
760,Aboriginal and Torres Strait Islander health liaison officer; Aboriginal and Torres Strait Islander health worker,Male,903,47833
200,Accountant; Bank accountant; Chartered accountant; Financial analyst,Female,78380,71552
136,Accountant; Bank accountant; Chartered accountant; Financial analyst,Male,77112,105107
157,Accounting practice manager; Architectural practice manager; Legal practice manager; Manager – other practice; Veterinary practice manager,Female
@bdilday
bdilday / HOF_candidates_bbrefid_2017.csv
Last active November 27, 2016 21:33
baseball reference IDs for 2017 HOF candidates
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
bbrefid
bagweje01
bondsba01
clemero02
hoffmtr01
kentje01
martied01
mcgrifr01
mussimi01
raineti01
@bdilday
bdilday / iwrs_1961_2011.csv
Created October 14, 2016 01:43
intentional walk rage scale 1961-2011
We can't make this file beautiful and searchable because it's too large.
game_id,home_team,away_team,offender,recip,pit_id,bat_id,bat_ondeck_id,inn,outs,s1,s2,s3,s4,s5,s6,sTotal
BAL196104162,BAL,MIN,MIN1961,BAL1961,kralj101,triag101,hansr102,1,1,9,3,3,3,0,0,18
BAL196104240,BAL,CLE,BAL1961,CLE1961,pappm101,kirkw101,philb102,6,1,4,3,0,3,0,0,10
BAL196105170,BAL,DET,BAL1961,DET1961,fishj101,cashn101,boros101,7,1,3,3,0,3,0,0,9
BAL196106062,BAL,LAA,LAA1961,BAL1961,mcbrk101,triag101,hansr102,4,2,6,3,0,3,3,0,15
BAL196106080,BAL,MIN,BAL1961,MIN1961,fishj101,killh102,allib103,8,1,2,3,0,3,0,0,8
BAL196106300,BAL,DET,DET1961,BAL1961,bunnj101,triag101,hansr102,6,1,4,3,0,3,0,0,10
BAL196106300,BAL,DET,BAL1961,DET1961,wilhh101,cashn101,boros101,9,0,1,3,0,3,3,0,10
BAL196107010,BAL,DET,BAL1961,DET1961,stocw101,maxwc101,aguih101,8,2,2,0,3,3,3,0,11
BAL196107010,BAL,DET,BAL1961,DET1961,hyded101,cashn101,boros101,11,1,1,3,0,3,0,0,7