This Data is about MLB predictions The probability of each team making the playoffs.
library(RCurl)## Warning: package 'RCurl' was built under R version 3.6.3library(readr)## Warning: package 'readr' was built under R version 3.6.3library(dplyr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionlibrary(plyr)## ------------------------------------------------------------------------------## You have loaded plyr after dplyr - this is likely to cause problems.
## If you need functions from both plyr and dplyr, please load plyr first, then dplyr:
## library(plyr); library(dplyr)## ------------------------------------------------------------------------------##
## Attaching package: 'plyr'## The following objects are masked from 'package:dplyr':
##
## arrange, count, desc, failwith, id, mutate, rename, summarise,
## summarizedata <- read.csv("https://raw.githubusercontent.com/Angelogallardo05/Assignment01/04b528e1d5327aeb112672e39a6eb3a75a3bd4a5/mlb_elo_latest.csv", header = TRUE, sep = ",")
data$playoff <- NULL
head(data)## date season neutral team1 team2 elo1_pre elo2_pre elo_prob1 elo_prob2
## 1 2023-10-01 2023 0 STL CIN 1499.568 1485.123 0.5551010 0.4448990
## 2 2023-10-01 2023 0 SEA TEX 1516.278 1535.226 0.5072694 0.4927306
## 3 2023-10-01 2023 0 NYM PHI 1506.248 1523.132 0.5102396 0.4897604
## 4 2023-10-01 2023 0 MIL CHC 1502.094 1498.789 0.5392139 0.4607861
## 5 2023-10-01 2023 0 KCR NYY 1423.430 1541.893 0.3673099 0.6326901
## 6 2023-10-01 2023 0 DET CLE 1459.732 1508.918 0.4638176 0.5361824
## elo1_post elo2_post rating1_pre rating2_pre pitcher1 pitcher2 pitcher1_rgs
## 1 NA NA 1501.464 1472.552 NA
## 2 NA NA 1512.066 1536.372 NA
## 3 NA NA 1524.665 1523.687 NA
## 4 NA NA 1515.024 1494.281 NA
## 5 NA NA 1420.958 1555.329 NA
## 6 NA NA 1449.863 1516.012 NA
## pitcher2_rgs pitcher1_adj pitcher2_adj rating_prob1 rating_prob2 rating1_post
## 1 NA NA NA 0.5758205 0.4241795 NA
## 2 NA NA NA 0.5046097 0.4953903 NA
## 3 NA NA NA 0.5386678 0.4613322 NA
## 4 NA NA NA 0.5574756 0.4425244 NA
## 5 NA NA NA 0.3475025 0.6524975 NA
## 6 NA NA NA 0.4300340 0.5699660 NA
## rating2_post score1 score2
## 1 NA NA NA
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA#Rename column headers
head(rename(data,c("date"="d","season"="s","neutral"="n","team1"="t1","team2"="t2")))## d s n t1 t2 elo1_pre elo2_pre elo_prob1 elo_prob2 elo1_post
## 1 2023-10-01 2023 0 STL CIN 1499.568 1485.123 0.5551010 0.4448990 NA
## 2 2023-10-01 2023 0 SEA TEX 1516.278 1535.226 0.5072694 0.4927306 NA
## 3 2023-10-01 2023 0 NYM PHI 1506.248 1523.132 0.5102396 0.4897604 NA
## 4 2023-10-01 2023 0 MIL CHC 1502.094 1498.789 0.5392139 0.4607861 NA
## 5 2023-10-01 2023 0 KCR NYY 1423.430 1541.893 0.3673099 0.6326901 NA
## 6 2023-10-01 2023 0 DET CLE 1459.732 1508.918 0.4638176 0.5361824 NA
## elo2_post rating1_pre rating2_pre pitcher1 pitcher2 pitcher1_rgs pitcher2_rgs
## 1 NA 1501.464 1472.552 NA NA
## 2 NA 1512.066 1536.372 NA NA
## 3 NA 1524.665 1523.687 NA NA
## 4 NA 1515.024 1494.281 NA NA
## 5 NA 1420.958 1555.329 NA NA
## 6 NA 1449.863 1516.012 NA NA
## pitcher1_adj pitcher2_adj rating_prob1 rating_prob2 rating1_post rating2_post
## 1 NA NA 0.5758205 0.4241795 NA NA
## 2 NA NA 0.5046097 0.4953903 NA NA
## 3 NA NA 0.5386678 0.4613322 NA NA
## 4 NA NA 0.5574756 0.4425244 NA NA
## 5 NA NA 0.3475025 0.6524975 NA NA
## 6 NA NA 0.4300340 0.5699660 NA NA
## score1 score2
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NAHwinprob <- subset(data, elo_prob1 > .5 & team1 == "NYY" )
Hwinprob## date season neutral team1 team2 elo1_pre elo2_pre elo_prob1
## 102 2023-09-24 2023 0 NYY ARI 1541.893 1516.471 0.5706490
## 120 2023-09-23 2023 0 NYY ARI 1541.893 1516.471 0.5706490
## 131 2023-09-22 2023 0 NYY ARI 1541.893 1516.471 0.5706490
## 142 2023-09-21 2023 0 NYY TOR 1541.893 1531.645 0.5491282
## 148 2023-09-20 2023 0 NYY TOR 1541.893 1531.645 0.5491282
## 171 2023-09-19 2023 0 NYY TOR 1541.893 1531.645 0.5491282
## 293 2023-09-10 2023 0 NYY MIL 1541.893 1502.094 0.5907967
## 313 2023-09-09 2023 0 NYY MIL 1541.893 1502.094 0.5907967
## 324 2023-09-08 2023 0 NYY MIL 1541.893 1502.094 0.5907967
## 332 2023-09-07 2023 0 NYY DET 1541.893 1459.732 0.6481952
## 340 2023-09-06 2023 0 NYY DET 1541.893 1459.732 0.6481952
## 359 2023-09-05 2023 0 NYY DET 1541.893 1459.732 0.6481952
## 523 2023-08-24 2023 0 NYY WSN 1541.893 1446.744 0.6650489
## 527 2023-08-23 2023 0 NYY WSN 1541.893 1446.744 0.6650489
## 549 2023-08-22 2023 0 NYY WSN 1541.893 1446.744 0.6650489
## 575 2023-08-20 2023 0 NYY BOS 1541.893 1521.429 0.5636420
## 592 2023-08-19 2023 0 NYY BOS 1541.893 1521.429 0.5636420
## 605 2023-08-18 2023 0 NYY BOS 1541.893 1521.429 0.5636420
## 759 2023-08-06 2023 0 NYY HOU 1541.893 1547.762 0.5260698
## 777 2023-08-05 2023 0 NYY HOU 1541.893 1547.762 0.5260698
## 787 2023-08-04 2023 0 NYY HOU 1541.893 1547.762 0.5260698
## 796 2023-08-03 2023 0 NYY HOU 1541.893 1547.762 0.5260698
## 896 2023-07-26 2023 0 NYY NYM 1541.893 1506.248 0.5850024
## 918 2023-07-25 2023 0 NYY NYM 1541.893 1506.248 0.5850024
## 944 2023-07-23 2023 0 NYY KCR 1541.893 1423.430 0.6942544
## 961 2023-07-22 2023 0 NYY KCR 1541.893 1423.430 0.6942544
## 972 2023-07-21 2023 0 NYY KCR 1541.893 1423.430 0.6942544
## 1084 2023-07-09 2023 0 NYY CHC 1541.893 1498.789 0.5953876
## 1101 2023-07-08 2023 0 NYY CHC 1541.893 1498.789 0.5953876
## 1113 2023-07-07 2023 0 NYY CHC 1541.893 1498.789 0.5953876
## 1123 2023-07-06 2023 0 NYY BAL 1541.893 1524.497 0.5592932
## 1139 2023-07-05 2023 0 NYY BAL 1541.893 1524.497 0.5592932
## 1157 2023-07-04 2023 0 NYY BAL 1541.893 1524.497 0.5592932
## 1164 2023-07-03 2023 0 NYY BAL 1541.893 1524.497 0.5592932
## 1274 2023-06-25 2023 0 NYY TEX 1541.893 1535.226 0.5440188
## 1289 2023-06-24 2023 0 NYY TEX 1541.893 1535.226 0.5440188
## 1300 2023-06-23 2023 0 NYY TEX 1541.893 1535.226 0.5440188
## 1306 2023-06-22 2023 0 NYY SEA 1541.893 1516.278 0.5709205
## 1318 2023-06-21 2023 0 NYY SEA 1541.893 1516.278 0.5709205
## 1338 2023-06-20 2023 0 NYY SEA 1540.413 1517.758 0.5667404
## 1446 2023-06-11 2023 0 NYY BOS 1551.988 1505.193 0.6004959
## 1463 2023-06-10 2023 0 NYY BOS 1550.643 1506.537 0.5967765
## 1487 2023-06-09 2023 0 NYY BOS 1552.362 1504.819 0.6015271
## 1492 2023-06-08 2023 0 NYY CHW 1550.859 1487.148 0.6236123
## 1497 2023-06-08 2023 0 NYY CHW 1552.678 1485.329 0.6285137
## 1526 2023-06-06 2023 0 NYY CHW 1554.515 1483.491 0.6334396
## 1642 2023-05-28 2023 0 NYY SDP 1543.638 1514.873 0.5753563
## 1659 2023-05-27 2023 0 NYY SDP 1542.522 1515.990 0.5722130
## 1670 2023-05-26 2023 0 NYY SDP 1545.610 1512.901 0.5808932
## 1679 2023-05-25 2023 0 NYY BAL 1547.683 1525.914 0.5654881
## 1692 2023-05-24 2023 0 NYY BAL 1550.272 1523.326 0.5727960
## 1709 2023-05-23 2023 0 NYY BAL 1549.146 1524.451 0.5696227
## 1867 2023-05-11 2023 0 NYY TBD 1540.924 1564.163 0.5010951
## 1885 2023-05-10 2023 0 NYY OAK 1538.944 1421.128 0.6934620
## 1895 2023-05-09 2023 0 NYY OAK 1537.430 1422.642 0.6897457
## 1908 2023-05-08 2023 0 NYY OAK 1535.889 1424.183 0.6859352
## 1974 2023-05-03 2023 0 NYY CLE 1535.365 1511.996 0.5677506
## 1994 2023-05-02 2023 0 NYY CLE 1533.871 1513.491 0.5635222
## 2002 2023-05-01 2023 0 NYY CLE 1535.469 1511.892 0.5680445
## 2110 2023-04-23 2023 0 NYY TOR 1549.186 1530.648 0.5609142
## 2129 2023-04-22 2023 0 NYY TOR 1548.020 1531.815 0.5576028
## 2139 2023-04-21 2023 0 NYY TOR 1551.432 1528.402 0.5672719
## 2149 2023-04-20 2023 0 NYY ANA 1549.036 1499.452 0.6043407
## 2154 2023-04-19 2023 0 NYY ANA 1548.021 1500.466 0.6015443
## 2177 2023-04-18 2023 0 NYY ANA 1550.819 1497.668 0.6092398
## 2206 2023-04-16 2023 0 NYY MIN 1549.453 1508.895 0.5918514
## 2222 2023-04-15 2023 0 NYY MIN 1547.164 1511.183 0.5854716
## 2234 2023-04-14 2023 0 NYY MIN 1548.841 1509.506 0.5901497
## 2241 2023-04-13 2023 0 NYY MIN 1554.150 1504.198 0.6048474
## 2350 2023-04-05 2023 0 NYY PHI 1546.243 1520.932 0.5704912
## 2361 2023-04-04 2023 0 NYY PHI 1548.860 1518.315 0.5778580
## 2375 2023-04-03 2023 0 NYY PHI 1545.910 1521.265 0.5695514
## 2392 2023-04-02 2023 0 NYY SFG 1543.277 1514.179 0.5758244
## 2406 2023-04-01 2023 0 NYY SFG 1545.425 1512.031 0.5818538
## 2429 2023-03-30 2023 0 NYY SFG 1543.061 1514.396 0.5752159
## elo_prob2 elo1_post elo2_post rating1_pre rating2_pre pitcher1
## 102 0.4293510 NA NA 1555.329 1504.542
## 120 0.4293510 NA NA 1555.329 1504.542
## 131 0.4293510 NA NA 1555.329 1504.542
## 142 0.4508718 NA NA 1555.329 1537.984
## 148 0.4508718 NA NA 1555.329 1537.984
## 171 0.4508718 NA NA 1555.329 1537.984
## 293 0.4092033 NA NA 1555.329 1515.024
## 313 0.4092033 NA NA 1555.329 1515.024
## 324 0.4092033 NA NA 1555.329 1515.024
## 332 0.3518048 NA NA 1555.329 1449.863
## 340 0.3518048 NA NA 1555.329 1449.863
## 359 0.3518048 NA NA 1555.329 1449.863
## 523 0.3349511 NA NA 1555.329 1433.413
## 527 0.3349511 NA NA 1555.329 1433.413
## 549 0.3349511 NA NA 1555.329 1433.413
## 575 0.4363580 NA NA 1555.329 1524.182
## 592 0.4363580 NA NA 1555.329 1524.182
## 605 0.4363580 NA NA 1555.329 1524.182
## 759 0.4739302 NA NA 1555.329 1548.487
## 777 0.4739302 NA NA 1555.329 1548.487
## 787 0.4739302 NA NA 1555.329 1548.487
## 796 0.4739302 NA NA 1555.329 1548.487
## 896 0.4149976 NA NA 1555.329 1524.665
## 918 0.4149976 NA NA 1555.329 1524.665
## 944 0.3057456 NA NA 1555.329 1420.958
## 961 0.3057456 NA NA 1555.329 1420.958
## 972 0.3057456 NA NA 1555.329 1420.958
## 1084 0.4046124 NA NA 1555.329 1494.281
## 1101 0.4046124 NA NA 1555.329 1494.281
## 1113 0.4046124 NA NA 1555.329 1494.281
## 1123 0.4407068 NA NA 1555.329 1510.257
## 1139 0.4407068 NA NA 1555.329 1510.257
## 1157 0.4407068 NA NA 1555.329 1510.257
## 1164 0.4407068 NA NA 1555.329 1510.257
## 1274 0.4559812 NA NA 1555.329 1536.372
## 1289 0.4559812 NA NA 1555.329 1536.372
## 1300 0.4559812 NA NA 1555.329 1536.372
## 1306 0.4290795 NA NA 1555.329 1512.066
## 1318 0.4290795 NA NA 1555.329 1512.066 Jhony Brito
## 1338 0.4332596 1541.893 1516.278 1554.392 1513.003 Gerrit Cole
## 1446 0.3995041 1550.274 1506.907 1562.793 1511.930 Clarke Schmidt
## 1463 0.4032235 1551.988 1505.193 1561.769 1512.954 Domingo German
## 1487 0.3984729 1550.643 1506.537 1563.192 1511.531 Gerrit Cole
## 1492 0.3763877 1552.362 1485.645 1561.994 1486.924 Randy Vasquez
## 1497 0.3714863 1550.859 1487.148 1563.466 1485.452 Luis Severino
## 1526 0.3665604 1552.678 1485.329 1564.768 1484.151 Clarke Schmidt
## 1642 0.4246437 1545.409 1513.102 1557.463 1534.648 Gerrit Cole
## 1659 0.4277870 1543.638 1514.873 1556.624 1535.487 Luis Severino
## 1670 0.4191068 1542.522 1515.990 1558.628 1533.483 Randy Vasquez
## 1679 0.4345119 1545.610 1527.988 1560.158 1509.208 Clarke Schmidt
## 1692 0.4272040 1547.683 1525.914 1562.184 1507.182 Nestor Cortes
## 1709 0.4303773 1550.272 1523.326 1561.503 1507.863 Gerrit Cole
## 1867 0.4989049 1537.661 1567.426 1555.499 1559.709 Domingo German
## 1885 0.3065380 1540.924 1419.149 1553.949 1407.435 Jhony Brito
## 1895 0.3102543 1538.944 1421.128 1552.748 1408.636 Clarke Schmidt
## 1908 0.3140648 1537.430 1422.642 1551.756 1409.628 Nestor Cortes
## 1974 0.4322494 1536.497 1510.864 1551.327 1519.848 Clarke Schmidt
## 1994 0.4364778 1535.365 1511.996 1550.501 1520.674 Gerrit Cole
## 2002 0.4319555 1533.871 1513.491 1551.701 1519.474 Domingo German
## 2110 0.4390858 1546.230 1533.604 1560.759 1539.943 Clarke Schmidt
## 2129 0.4423972 1549.186 1530.648 1559.927 1540.775 Gerrit Cole
## 2139 0.4327281 1548.020 1531.815 1562.646 1538.057 Domingo German
## 2149 0.3956593 1551.432 1497.055 1560.873 1516.789 Nestor Cortes
## 2154 0.3984557 1549.036 1499.452 1560.014 1517.647 Jhony Brito
## 2177 0.3907602 1548.021 1500.466 1561.930 1515.732 Clarke Schmidt
## 2206 0.4081486 1550.819 1507.528 1560.927 1529.049 Gerrit Cole
## 2222 0.4145284 1549.453 1508.895 1559.056 1530.920 Domingo German
## 2234 0.4098503 1547.164 1511.183 1560.431 1529.545 Nestor Cortes
## 2241 0.3951526 1548.841 1509.506 1563.880 1526.096 Jhony Brito
## 2350 0.4295088 1547.706 1519.469 1558.656 1525.036 Gerrit Cole
## 2361 0.4221420 1546.243 1520.932 1560.758 1522.934 Domingo German
## 2375 0.4304486 1548.860 1518.315 1558.890 1524.803 Nestor Cortes
## 2392 0.4241756 1545.910 1511.547 1556.584 1506.379 Jhony Brito
## 2406 0.4181462 1543.277 1514.179 1558.040 1504.923 Clarke Schmidt
## 2429 0.4247841 1545.425 1512.031 1556.417 1506.545 Gerrit Cole
## pitcher2 pitcher1_rgs pitcher2_rgs pitcher1_adj pitcher2_adj
## 102 NA NA NA NA
## 120 NA NA NA NA
## 131 NA NA NA NA
## 142 NA NA NA NA
## 148 NA NA NA NA
## 171 NA NA NA NA
## 293 NA NA NA NA
## 313 NA NA NA NA
## 324 NA NA NA NA
## 332 NA NA NA NA
## 340 NA NA NA NA
## 359 NA NA NA NA
## 523 NA NA NA NA
## 527 NA NA NA NA
## 549 NA NA NA NA
## 575 NA NA NA NA
## 592 NA NA NA NA
## 605 NA NA NA NA
## 759 NA NA NA NA
## 777 NA NA NA NA
## 787 NA NA NA NA
## 796 NA NA NA NA
## 896 NA NA NA NA
## 918 NA NA NA NA
## 944 NA NA NA NA
## 961 NA NA NA NA
## 972 NA NA NA NA
## 1084 NA NA NA NA
## 1101 NA NA NA NA
## 1113 NA NA NA NA
## 1123 NA NA NA NA
## 1139 NA NA NA NA
## 1157 NA NA NA NA
## 1164 NA NA NA NA
## 1274 NA NA NA NA
## 1289 NA NA NA NA
## 1300 NA NA NA NA
## 1306 NA NA NA NA
## 1318 Luis Castillo 45.90548 58.46784 -40.740899 26.538667
## 1338 George Kirby 59.69269 54.83809 25.162340 9.557444
## 1446 Brayan Bello 49.01692 50.43791 -27.363409 -3.856792
## 1463 Tanner Houck 55.50691 53.61791 3.332766 11.476885
## 1487 Garrett Whitlock 59.21661 49.46868 20.870275 -7.749960
## 1492 Mike Clevinger 47.92486 50.62489 -31.441274 -7.560999
## 1497 Lance Lynn 56.20151 50.28071 6.605287 -10.057129
## 1526 Lucas Giolito 49.13026 52.43393 -26.995441 1.205307
## 1642 Yu Darvish 59.49076 56.87948 20.753255 22.764010
## 1659 Michael Wacha 57.82548 53.77961 13.523099 8.744287
## 1670 Joe Musgrove 47.40000 52.54847 -35.535975 3.712361
## 1679 Kyle Gibson 47.06503 49.40975 -36.953670 -2.690763
## 1692 Tyler Wells 56.10212 54.15871 5.130406 19.054135
## 1709 Kyle Bradish 60.93710 52.32024 26.762883 9.825696
## 1867 Drew Rasmussen 54.61968 56.91283 -4.255150 6.907312
## 1885 Kyle Muller 47.02669 44.36253 -40.603618 -4.672732
## 1895 Drew Rucinski 46.29771 44.42459 -43.959675 -5.131026
## 1908 JP Sears 57.35275 48.46259 7.808498 13.438802
## 1974 Shane Bieber 46.02552 60.43512 -47.881732 32.638665
## 1994 Tanner Bibee 63.07408 48.83648 32.469615 -21.599115
## 2002 Cal Quantrill 52.96271 51.88467 -13.792455 -6.989835
## 2110 Kevin Gausman 45.44748 55.91042 -52.426512 15.137650
## 2129 Alek Manoah 62.49824 56.56328 28.256349 19.519994
## 2139 Yusei Kikuchi 53.92532 46.02709 -12.368064 -29.596361
## 2149 Patrick Sandoval 59.29871 54.49081 13.183845 4.845945
## 2154 Griffin Canning 47.12124 48.68151 -44.009740 -22.442566
## 2177 Jose Suarez 45.64476 48.49472 -51.576192 -23.878879
## 2206 Pablo Lopez 60.90327 56.54636 21.856644 8.521934
## 2222 Tyler Mahle 52.60041 53.99465 -16.082226 -4.163676
## 2234 Louie Varland 59.09072 49.69516 14.765383 -24.619036
## 2241 Joe Ryan 50.28232 56.10201 -28.703962 6.608208
## 2350 Aaron Nola 60.21210 57.98235 16.971411 16.652266
## 2361 Matt Strahm 53.26106 47.53669 -15.935739 -31.848923
## 2375 Taijuan Walker 59.09030 51.89246 11.585085 -11.845698
## 2392 Ross Stripling 47.40000 55.44908 -42.634356 16.245461
## 2406 Alex Cobb 47.27965 53.67868 -43.968626 7.940516
## 2429 Logan Webb 59.29949 56.09121 13.517660 19.512170
## rating_prob1 rating_prob2 rating1_post rating2_post score1 score2
## 102 0.6004544 0.3995456 NA NA NA NA
## 120 0.6004544 0.3995456 NA NA NA NA
## 131 0.6027996 0.3972004 NA NA NA NA
## 142 0.5559077 0.4440923 NA NA NA NA
## 148 0.5559077 0.4440923 NA NA NA NA
## 171 0.5559690 0.4440310 NA NA NA NA
## 293 0.5926822 0.4073178 NA NA NA NA
## 313 0.5926822 0.4073178 NA NA NA NA
## 324 0.5924356 0.4075644 NA NA NA NA
## 332 0.6804325 0.3195675 NA NA NA NA
## 340 0.6804325 0.3195675 NA NA NA NA
## 359 0.6795357 0.3204643 NA NA NA NA
## 523 0.6946523 0.3053477 NA NA NA NA
## 527 0.6946523 0.3053477 NA NA NA NA
## 549 0.6969046 0.3030954 NA NA NA NA
## 575 0.5747974 0.4252026 NA NA NA NA
## 592 0.5747974 0.4252026 NA NA NA NA
## 605 0.5766614 0.4233386 NA NA NA NA
## 759 0.5414612 0.4585388 NA NA NA NA
## 777 0.5414612 0.4585388 NA NA NA NA
## 787 0.5414612 0.4585388 NA NA NA NA
## 796 0.5464438 0.4535562 NA NA NA NA
## 896 0.5706402 0.4293598 NA NA NA NA
## 918 0.5698648 0.4301352 NA NA NA NA
## 944 0.7122518 0.2877482 NA NA NA NA
## 961 0.7122518 0.2877482 NA NA NA NA
## 972 0.7138078 0.2861922 NA NA NA NA
## 1084 0.6148706 0.3851294 NA NA NA NA
## 1101 0.6148706 0.3851294 NA NA NA NA
## 1113 0.6186840 0.3813160 NA NA NA NA
## 1123 0.5923310 0.4076690 NA NA NA NA
## 1139 0.5923310 0.4076690 NA NA NA NA
## 1157 0.5923310 0.4076690 NA NA NA NA
## 1164 0.5906276 0.4093724 NA NA NA NA
## 1274 0.5624541 0.4375459 NA NA NA NA
## 1289 0.5624541 0.4375459 NA NA NA NA
## 1300 0.5631245 0.4368755 NA NA NA NA
## 1306 0.5916628 0.4083372 NA NA NA NA
## 1318 0.4999766 0.5000234 NA NA NA NA
## 1338 0.6177677 0.3822323 1555.329 1512.066 3 1
## 1446 0.5733750 0.4266250 1561.580 1513.143 2 3
## 1463 0.5920078 0.4079922 1562.793 1511.930 3 1
## 1487 0.6487427 0.3512573 1561.769 1512.954 2 3
## 1492 0.6065475 0.3934525 1563.192 1485.726 3 0
## 1497 0.6644424 0.3355576 1561.994 1486.924 5 6
## 1526 0.6062990 0.3937010 1563.466 1485.452 2 3
## 1642 0.5641245 0.4358755 1558.839 1533.272 10 7
## 1659 0.5713439 0.4286561 1557.463 1534.648 3 2
## 1670 0.5168951 0.4831049 1556.624 1535.487 1 5
## 1679 0.5582872 0.4417128 1558.628 1510.738 1 3
## 1692 0.5925744 0.4074256 1560.158 1509.208 6 9
## 1709 0.6322937 0.3677063 1562.184 1507.182 6 5
## 1867 0.5149211 0.4850789 1552.967 1562.241 2 8
## 1885 0.6845413 0.3154587 1555.499 1405.885 11 3
## 1895 0.6779178 0.3220822 1553.949 1407.435 10 5
## 1908 0.7159160 0.2840840 1552.748 1408.636 7 2
## 1974 0.4640235 0.5359765 1552.442 1518.733 4 3
## 1994 0.6504686 0.3495314 1551.327 1519.848 4 2
## 2002 0.5682339 0.4317661 1550.501 1520.674 2 3
## 2110 0.4673102 0.5326898 1558.995 1541.708 1 5
## 2129 0.5741228 0.4258772 1560.759 1539.943 3 2
## 2139 0.5952521 0.4047479 1559.927 1540.775 1 6
## 2149 0.6082400 0.3917600 1562.646 1515.016 9 3
## 2154 0.5641178 0.4358822 1560.873 1516.789 3 2
## 2177 0.5665944 0.4334056 1560.014 1517.647 2 5
## 2206 0.5983068 0.4016932 1561.930 1528.046 2 0
## 2222 0.5576191 0.4423809 1560.927 1529.049 6 1
## 2234 0.6324312 0.3675688 1559.056 1530.920 3 4
## 2241 0.5392004 0.4607996 1560.431 1529.545 2 11
## 2350 0.5826166 0.4173834 1559.713 1523.980 4 2
## 2361 0.6100427 0.3899573 1558.656 1525.036 1 4
## 2375 0.6199152 0.3800848 1560.758 1522.934 8 1
## 2392 0.5220410 0.4779590 1558.890 1504.073 6 0
## 2406 0.5362136 0.4637864 1556.584 1506.379 5 7
## 2429 0.6023312 0.3976688 1558.040 1504.923 5 0summary(Hwinprob)## date season neutral team1 team2
## 2023-06-08: 2 Min. :2023 Min. :0 NYY :75 BAL : 7
## 2023-03-30: 1 1st Qu.:2023 1st Qu.:0 ANA : 0 BOS : 6
## 2023-04-01: 1 Median :2023 Median :0 ARI : 0 TOR : 6
## 2023-04-02: 1 Mean :2023 Mean :0 ATL : 0 HOU : 4
## 2023-04-03: 1 3rd Qu.:2023 3rd Qu.:0 BAL : 0 MIN : 4
## 2023-04-04: 1 Max. :2023 Max. :0 BOS : 0 ANA : 3
## (Other) :68 (Other): 0 (Other):45
## elo1_pre elo2_pre elo_prob1 elo_prob2 elo1_post
## Min. :1534 Min. :1421 Min. :0.5011 Min. :0.3057 Min. :1534
## 1st Qu.:1542 1st Qu.:1499 1st Qu.:0.5636 1st Qu.:0.3985 1st Qu.:1543
## Median :1542 Median :1513 Median :0.5754 Median :0.4246 Median :1547
## Mean :1544 Mean :1505 Mean :0.5893 Mean :0.4107 Mean :1546
## 3rd Qu.:1547 3rd Qu.:1524 3rd Qu.:0.6015 3rd Qu.:0.4364 3rd Qu.:1550
## Max. :1555 Max. :1564 Max. :0.6943 Max. :0.4989 Max. :1553
## NA's :39
## elo2_post rating1_pre rating2_pre pitcher1
## Min. :1419 Min. :1551 Min. :1407 :38
## 1st Qu.:1504 1st Qu.:1555 1st Qu.:1505 Gerrit Cole : 9
## Median :1512 Median :1555 Median :1515 Clarke Schmidt: 8
## Mean :1506 Mean :1557 Mean :1506 Domingo German: 6
## 3rd Qu.:1519 3rd Qu.:1559 3rd Qu.:1529 Jhony Brito : 5
## Max. :1567 Max. :1565 Max. :1560 Nestor Cortes : 5
## NA's :39 (Other) : 4
## pitcher2 pitcher1_rgs pitcher2_rgs pitcher1_adj
## :38 Min. :45.45 Min. :44.36 Min. :-52.43
## Aaron Nola : 1 1st Qu.:47.40 1st Qu.:49.47 1st Qu.:-36.95
## Alek Manoah : 1 Median :53.93 Median :52.55 Median :-12.37
## Alex Cobb : 1 Mean :53.57 Mean :52.53 Mean :-10.13
## Brayan Bello : 1 3rd Qu.:59.22 3rd Qu.:55.91 3rd Qu.: 13.52
## Cal Quantrill: 1 Max. :63.07 Max. :60.44 Max. : 32.47
## (Other) :32 NA's :38 NA's :38 NA's :38
## pitcher2_adj rating_prob1 rating_prob2 rating1_post
## Min. :-31.849 Min. :0.4640 Min. :0.2841 Min. :1551
## 1st Qu.: -7.561 1st Qu.:0.5628 1st Qu.:0.3818 1st Qu.:1557
## Median : 4.846 Median :0.5923 Median :0.4077 Median :1559
## Mean : 1.680 Mean :0.5966 Mean :0.4034 Mean :1559
## 3rd Qu.: 13.439 3rd Qu.:0.6182 3rd Qu.:0.4372 3rd Qu.:1561
## Max. : 32.639 Max. :0.7159 Max. :0.5360 Max. :1563
## NA's :38 NA's :39
## rating2_post score1 score2
## Min. :1406 Min. : 1.000 Min. : 0.000
## 1st Qu.:1507 1st Qu.: 2.000 1st Qu.: 2.000
## Median :1517 Median : 3.000 Median : 3.000
## Mean :1510 Mean : 4.111 Mean : 3.528
## 3rd Qu.:1529 3rd Qu.: 6.000 3rd Qu.: 5.000
## Max. :1562 Max. :11.000 Max. :11.000
## NA's :39 NA's :39 NA's :39Yankees <- subset(data, team1 == "NYY", select = c("date", "season", "team1", "elo1_pre", "rating1_pre", "rating2_pre"))
Yankees## date season team1 elo1_pre rating1_pre rating2_pre
## 102 2023-09-24 2023 NYY 1541.893 1555.329 1504.542
## 120 2023-09-23 2023 NYY 1541.893 1555.329 1504.542
## 131 2023-09-22 2023 NYY 1541.893 1555.329 1504.542
## 142 2023-09-21 2023 NYY 1541.893 1555.329 1537.984
## 148 2023-09-20 2023 NYY 1541.893 1555.329 1537.984
## 171 2023-09-19 2023 NYY 1541.893 1555.329 1537.984
## 293 2023-09-10 2023 NYY 1541.893 1555.329 1515.024
## 313 2023-09-09 2023 NYY 1541.893 1555.329 1515.024
## 324 2023-09-08 2023 NYY 1541.893 1555.329 1515.024
## 332 2023-09-07 2023 NYY 1541.893 1555.329 1449.863
## 340 2023-09-06 2023 NYY 1541.893 1555.329 1449.863
## 359 2023-09-05 2023 NYY 1541.893 1555.329 1449.863
## 523 2023-08-24 2023 NYY 1541.893 1555.329 1433.413
## 527 2023-08-23 2023 NYY 1541.893 1555.329 1433.413
## 549 2023-08-22 2023 NYY 1541.893 1555.329 1433.413
## 575 2023-08-20 2023 NYY 1541.893 1555.329 1524.182
## 592 2023-08-19 2023 NYY 1541.893 1555.329 1524.182
## 605 2023-08-18 2023 NYY 1541.893 1555.329 1524.182
## 759 2023-08-06 2023 NYY 1541.893 1555.329 1548.487
## 777 2023-08-05 2023 NYY 1541.893 1555.329 1548.487
## 787 2023-08-04 2023 NYY 1541.893 1555.329 1548.487
## 796 2023-08-03 2023 NYY 1541.893 1555.329 1548.487
## 810 2023-08-02 2023 NYY 1541.893 1555.329 1565.842
## 831 2023-08-01 2023 NYY 1541.893 1555.329 1565.842
## 841 2023-07-31 2023 NYY 1541.893 1555.329 1565.842
## 896 2023-07-26 2023 NYY 1541.893 1555.329 1524.665
## 918 2023-07-25 2023 NYY 1541.893 1555.329 1524.665
## 944 2023-07-23 2023 NYY 1541.893 1555.329 1420.958
## 961 2023-07-22 2023 NYY 1541.893 1555.329 1420.958
## 972 2023-07-21 2023 NYY 1541.893 1555.329 1420.958
## 1084 2023-07-09 2023 NYY 1541.893 1555.329 1494.281
## 1101 2023-07-08 2023 NYY 1541.893 1555.329 1494.281
## 1113 2023-07-07 2023 NYY 1541.893 1555.329 1494.281
## 1123 2023-07-06 2023 NYY 1541.893 1555.329 1510.257
## 1139 2023-07-05 2023 NYY 1541.893 1555.329 1510.257
## 1157 2023-07-04 2023 NYY 1541.893 1555.329 1510.257
## 1164 2023-07-03 2023 NYY 1541.893 1555.329 1510.257
## 1274 2023-06-25 2023 NYY 1541.893 1555.329 1536.372
## 1289 2023-06-24 2023 NYY 1541.893 1555.329 1536.372
## 1300 2023-06-23 2023 NYY 1541.893 1555.329 1536.372
## 1306 2023-06-22 2023 NYY 1541.893 1555.329 1512.066
## 1318 2023-06-21 2023 NYY 1541.893 1555.329 1512.066
## 1338 2023-06-20 2023 NYY 1540.413 1554.392 1513.003
## 1446 2023-06-11 2023 NYY 1551.988 1562.793 1511.930
## 1463 2023-06-10 2023 NYY 1550.643 1561.769 1512.954
## 1487 2023-06-09 2023 NYY 1552.362 1563.192 1511.531
## 1492 2023-06-08 2023 NYY 1550.859 1561.994 1486.924
## 1497 2023-06-08 2023 NYY 1552.678 1563.466 1485.452
## 1526 2023-06-06 2023 NYY 1554.515 1564.768 1484.151
## 1642 2023-05-28 2023 NYY 1543.638 1557.463 1534.648
## 1659 2023-05-27 2023 NYY 1542.522 1556.624 1535.487
## 1670 2023-05-26 2023 NYY 1545.610 1558.628 1533.483
## 1679 2023-05-25 2023 NYY 1547.683 1560.158 1509.208
## 1692 2023-05-24 2023 NYY 1550.272 1562.184 1507.182
## 1709 2023-05-23 2023 NYY 1549.146 1561.503 1507.863
## 1832 2023-05-14 2023 NYY 1540.433 1554.688 1560.520
## 1849 2023-05-13 2023 NYY 1539.054 1553.695 1561.514
## 1861 2023-05-12 2023 NYY 1537.661 1552.967 1562.241
## 1867 2023-05-11 2023 NYY 1540.924 1555.499 1559.709
## 1885 2023-05-10 2023 NYY 1538.944 1553.949 1407.435
## 1895 2023-05-09 2023 NYY 1537.430 1552.748 1408.636
## 1908 2023-05-08 2023 NYY 1535.889 1551.756 1409.628
## 1974 2023-05-03 2023 NYY 1535.365 1551.327 1519.848
## 1994 2023-05-02 2023 NYY 1533.871 1550.501 1520.674
## 2002 2023-05-01 2023 NYY 1535.469 1551.701 1519.474
## 2110 2023-04-23 2023 NYY 1549.186 1560.759 1539.943
## 2129 2023-04-22 2023 NYY 1548.020 1559.927 1540.775
## 2139 2023-04-21 2023 NYY 1551.432 1562.646 1538.057
## 2149 2023-04-20 2023 NYY 1549.036 1560.873 1516.789
## 2154 2023-04-19 2023 NYY 1548.021 1560.014 1517.647
## 2177 2023-04-18 2023 NYY 1550.819 1561.930 1515.732
## 2206 2023-04-16 2023 NYY 1549.453 1560.927 1529.049
## 2222 2023-04-15 2023 NYY 1547.164 1559.056 1530.920
## 2234 2023-04-14 2023 NYY 1548.841 1560.431 1529.545
## 2241 2023-04-13 2023 NYY 1554.150 1563.880 1526.096
## 2350 2023-04-05 2023 NYY 1546.243 1558.656 1525.036
## 2361 2023-04-04 2023 NYY 1548.860 1560.758 1522.934
## 2375 2023-04-03 2023 NYY 1545.910 1558.890 1524.803
## 2392 2023-04-02 2023 NYY 1543.277 1556.584 1506.379
## 2406 2023-04-01 2023 NYY 1545.425 1558.040 1504.923
## 2429 2023-03-30 2023 NYY 1543.061 1556.417 1506.545I was successfully pulled in the data