Baseball

MLB Predict Home Runs

@kaggle.jcraggy_baseball

Table List

3 tables(2.15 MB)

Park Dimensions

Test

Train

Test

@kaggle.jcraggy_baseball.test

1.26 MB
65779 rows
24 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_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
16	Wed Jun 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	MIA	TOR	MIA	marte, starling	ray, robbie	516782	592662	1	fly_ball	center	Slider	14	6		2	1	-0.09	2.1	87.6	109	22
17	Wed Jun 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	MIA	TOR	MIA	marte, starling	ray, robbie	516782	592662	1	ground_ball	center	Slider	14	1	1	1	2	0.67	1.71	88.4	25.5
18	Tue Jun 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	TOR	MIA	MIA	marte, starling	ray, robbie	516782	592662	1	fly_ball	left	Slider	28	5	2			-0.5	2.61	89.1	94.2
19	Tue Jun 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	TOR	MIA	MIA	marte, starling	ray, robbie	516782	592662	1	ground_ball	left	Slider	28	3	2	2	1	-0.45	1.78	90.4	83.1
32	Sun Jun 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	BOS	TOR	BOS	hernandez, enrique	ray, robbie	571771	592662	1	line_drive	center	Slider	3	5	2			0.26	2.29	90.1	108.1
33	Sun Jun 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	BOS	TOR	BOS	hernandez, enrique	ray, robbie	571771	592662	1	line_drive	center	4-Seam Fastball	3	3	2		1	0.48	2.43	96.5	95.1	22
34	Wed Jul 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	TOR	BOS	BOS	hernandez, enrique	ray, robbie	571771	592662	1	line_drive	center	Knuckle Curve	28	5	1			-0.28	1.92	79.8	95.5	18
35	Wed Jul 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	TOR	BOS	BOS	hernandez, enrique	ray, robbie	571771	592662	1	line_drive	left	4-Seam Fastball	28	3	1		2	-0.2	3.1	95.5		19
36	Wed Jul 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	TOR	BOS	BOS	hernandez, enrique	ray, robbie	571771	592662	1	fly_ball	center	4-Seam Fastball	28	1		1		-0.39	2.9	95.1	80	49
61	Sun Jul 11 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	TB	TOR	TB	mejia, francisco	ray, robbie	642336	592662	1	popup	center	4-Seam Fastball	26	3			2	-0.48	2.06	95.4	80.2	53


CREATE TABLE test (
  "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
);