MLB ELO 1871 - 2022

MLB ELO 1871 - 2022 For Predictions

@kaggle.dtrade84_mlb_elo_1871_2022

Table List

1 table(20.48 MB)

Mlb Elo

@kaggle.dtrade84_mlb_elo_1871_2022.mlb_elo

20.48 MB
225857 rows
26 columns

date Date	season Season	playoff Playoff	team1 Team1	team2 Team2	elo1_pre Elo1 Pre	elo2_pre Elo2 Pre	elo_prob1 Elo Prob1	elo_prob2 Elo Prob2	rating1_pre Rating1 Pre	rating2_pre Rating2 Pre	pitcher1 Pitcher1	pitcher2 Pitcher2	rating_prob1 Rating Prob1	rating_prob2 Rating Prob2
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	LAD	COL	1621.78941694243	1457.78440550233	0.7469183746749881	0.2530816253250119	1621.48760276158	1452.47218580393	nan	nan	0.7545417649231183	0.2454582350768817
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	SEA	DET	1531.67592438253	1455.87015518001	0.6398073736653546	0.3601926263346454	1520.32065132225	1456.3230349035	nan	nan	0.6357388468664339	0.3642611531335661
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	SDP	SFG	1508.21402202625	1503.75597149719	0.5408630833779413	0.4591369166220587	1520.48320890515	1496.66808598245	nan	nan	0.5759488978885657	0.4240511021114342
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	NYM	WSN	1557.27214503017	1425.70497867776	0.7100272909663965	0.2899727090336035	1562.07253158096	1431.86624822624	nan	nan	0.7150249026239485	0.2849750973760515
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	MIL	ARI	1520.36734828581	1487.6775456901	0.5808668083865055	0.4191331916134945	1529.28718005286	1479.68256130265	nan	nan	0.6052320636953417	0.3947679363046583
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	HOU	PHI	1574.44200303013	1528.14480974289	0.5998075202342467	0.4001924797657533	1566.64333639911	1534.54191237887	nan	nan	0.5968524760597451	0.4031475239402549
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	FLA	ATL	1461.883879285	1577.75271328014	0.3707875924084873	0.6292124075915126	1472.75268562561	1575.16466489173	nan	nan	0.3877894741789681	0.612210525821032
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	CLE	KCR	1520.10305194181	1454.56238813525	0.6260802824632953	0.3739197175367047	1513.29981216198	1453.61124615503	nan	nan	0.6197419256062247	0.3802580743937753
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	CIN	CHC	1465.40024968871	1465.9907716763	0.533638059204601	0.466361940795399	1469.1047778478	1469.22570993365	nan	nan	0.5265298949294659	0.4734701050705341
Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	nan	CHW	MIN	1497.97831611861	1507.30675224852	0.5211015362787633	0.4788984637212367	1508.15645069856	1512.53608665343	nan	nan	0.5230994950411655	0.4769005049588345


CREATE TABLE mlb_elo (
  "date" TIMESTAMP,
  "season" BIGINT,
  "neutral" BIGINT,
  "playoff" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "elo1_pre" DOUBLE,
  "elo2_pre" DOUBLE,
  "elo_prob1" DOUBLE,
  "elo_prob2" DOUBLE,
  "elo1_post" DOUBLE,
  "elo2_post" DOUBLE,
  "rating1_pre" DOUBLE,
  "rating2_pre" DOUBLE,
  "pitcher1" VARCHAR,
  "pitcher2" VARCHAR,
  "pitcher1_rgs" DOUBLE,
  "pitcher2_rgs" DOUBLE,
  "pitcher1_adj" DOUBLE,
  "pitcher2_adj" DOUBLE,
  "rating_prob1" DOUBLE,
  "rating_prob2" DOUBLE,
  "rating1_post" DOUBLE,
  "rating2_post" DOUBLE,
  "score1" DOUBLE,
  "score2" DOUBLE
);