Baseball

MLB Predict Home Runs

@kaggle.jcraggy_baseball

Table List

3 tables(2.15 MB)

Park Dimensions

Test

Train

Train

@kaggle.jcraggy_baseball.train

905 KB
46244 rows
25 columns

bip_id Bip Id	game_date Game Date	home_team Home Team	away_team Away Team	batter_team Batter Team	batter_name Batter Name	pitcher_name Pitcher Name	batter_id Batter Id	pitcher_id Pitcher Id	is_batter_lefty Is Batter Lefty	is_pitcher_lefty Is Pitcher Lefty	bb_type Bb Type	bearing Bearing	pitch_name Pitch Name	park Park	inning Inning	outs_when_up Outs When Up	balls Balls	strikes Strikes	plate_x Plate X	plate_z Plate Z	pitch_mph Pitch Mph	launch_speed Launch Speed	launch_angle Launch Angle
1	Wed Aug 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ARI	COL	COL	arenado, nolan	ray, robbie	571448	592662		1	line_drive	left	Slider		1		1	2	-0.15	1.97	87.8	108.9	9
2	Mon Aug 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COL	ARI	COL	arenado, nolan	ray, robbie	571448	592662		1	line_drive	left	4-Seam Fastball	7	1	1	3	1	-0.71	2.88	95.2		18
3	Mon Aug 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COL	ARI	COL	arenado, nolan	ray, robbie	571448	592662		1	popup	left	Slider	7	3		1	2	-0.54	1.75	86.5	75	49
4	Wed Aug 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ARI	COL	COL	blackmon, charlie	ray, robbie	453568	592662	1	1	fly_ball	right	Slider		1			2	-0.42	3.15	86.7	90.6	54
5	Mon Aug 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COL	ARI	COL	blackmon, charlie	ray, robbie	453568	592662	1	1	ground_ball	left	4-Seam Fastball	7	1	1	1		0.18	3.27	96.1		6
6	Mon Aug 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COL	ARI	COL	blackmon, charlie	ray, robbie	453568	592662	1	1	fly_ball	center	Slider	7	3		2	2	-0.99	1.52	86.2	66.7	27
7	Mon Aug 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COL	ARI	COL	blackmon, charlie	ray, robbie	453568	592662	1	1	line_drive	center	4-Seam Fastball	7	4	2	1	1	0.45	3.36	95		8
8	Wed Aug 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ARI	COL	COL	diaz, elias	ray, robbie	553869	592662		1	line_drive	left	4-Seam Fastball		1	2	2	2	0.31	1.9	92	95.7
9	Wed Aug 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ARI	COL	COL	rodgers, brendan	ray, robbie	663898	592662		1	ground_ball	center	4-Seam Fastball		4		3	2	0.12	1.45	90.9		-6
10	Wed Aug 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ARI	COL	COL	butera, drew	ray, robbie	460077	592662		1	fly_ball	left	Slider		4	1	1	1	-0.44	2.33	85.5	89.7	55


CREATE TABLE train (
  "bip_id" BIGINT,
  "game_date" TIMESTAMP,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "batter_team" VARCHAR,
  "batter_name" VARCHAR,
  "pitcher_name" VARCHAR,
  "batter_id" BIGINT,
  "pitcher_id" BIGINT,
  "is_batter_lefty" BIGINT,
  "is_pitcher_lefty" BIGINT,
  "bb_type" VARCHAR,
  "bearing" VARCHAR,
  "pitch_name" VARCHAR,
  "park" BIGINT,
  "inning" BIGINT,
  "outs_when_up" BIGINT,
  "balls" BIGINT,
  "strikes" BIGINT,
  "plate_x" DOUBLE,
  "plate_z" DOUBLE,
  "pitch_mph" DOUBLE,
  "launch_speed" DOUBLE,
  "launch_angle" DOUBLE,
  "is_home_run" BIGINT
);