Week-2 : Data Dive

library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.4     ✔ readr     2.1.4
## ✔ forcats   1.0.0     ✔ stringr   1.5.1
## ✔ ggplot2   3.4.4     ✔ tibble    3.2.1
## ✔ lubridate 1.9.3     ✔ tidyr     1.3.0
## ✔ purrr     1.0.2     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
Data_set <- "/Users/ba/Documents/IUPUI/Masters/First Sem/Statistics/Dataset/PitchingPost.csv"
Pitching_Data <- read.csv(Data_set)
summary(Pitching_Data)
##    playerID             yearID        round              teamID         
##  Length:3750        Min.   :2000   Length:3750        Length:3750       
##  Class :character   1st Qu.:2006   Class :character   Class :character  
##  Mode  :character   Median :2013   Mode  :character   Mode  :character  
##                     Mean   :2012                                        
##                     3rd Qu.:2018                                        
##                     Max.   :2022                                        
##                                                                         
##      lgID                 W                L                G        
##  Length:3750        Min.   :0.0000   Min.   :0.0000   Min.   :1.000  
##  Class :character   1st Qu.:0.0000   1st Qu.:0.0000   1st Qu.:1.000  
##  Mode  :character   Median :0.0000   Median :0.0000   Median :2.000  
##                     Mean   :0.2155   Mean   :0.2155   Mean   :1.935  
##                     3rd Qu.:0.0000   3rd Qu.:0.0000   3rd Qu.:3.000  
##                     Max.   :3.0000   Max.   :2.0000   Max.   :7.000  
##                                                                      
##        GS               CG                SHO                 SV        
##  Min.   :0.0000   Min.   :0.000000   Min.   :0.000000   Min.   :0.0000  
##  1st Qu.:0.0000   1st Qu.:0.000000   1st Qu.:0.000000   1st Qu.:0.0000  
##  Median :0.0000   Median :0.000000   Median :0.000000   Median :0.0000  
##  Mean   :0.4309   Mean   :0.009867   Mean   :0.005333   Mean   :0.1008  
##  3rd Qu.:1.0000   3rd Qu.:0.000000   3rd Qu.:0.000000   3rd Qu.:0.0000  
##  Max.   :3.0000   Max.   :2.000000   Max.   :1.000000   Max.   :4.0000  
##                                                                         
##      IPouts            H                ER               HR        
##  Min.   : 0.00   Min.   : 0.000   Min.   : 0.000   Min.   :0.0000  
##  1st Qu.: 5.00   1st Qu.: 1.000   1st Qu.: 0.000   1st Qu.:0.0000  
##  Median : 9.00   Median : 3.000   Median : 1.000   Median :0.0000  
##  Mean   :11.62   Mean   : 3.482   Mean   : 1.662   Mean   :0.4787  
##  3rd Qu.:16.00   3rd Qu.: 5.000   3rd Qu.: 3.000   3rd Qu.:1.0000  
##  Max.   :64.00   Max.   :17.000   Max.   :13.000   Max.   :5.0000  
##                                                                    
##        BB              SO             BAOpp             ERA      
##  Min.   : 0.00   Min.   : 0.000   Min.   :0.0000   Min.   :0.00  
##  1st Qu.: 0.00   1st Qu.: 1.000   1st Qu.:0.1360   1st Qu.:0.00  
##  Median : 1.00   Median : 3.000   Median :0.2310   Median :2.57  
##  Mean   : 1.41   Mean   : 3.562   Mean   :0.2412   Mean   : Inf  
##  3rd Qu.: 2.00   3rd Qu.: 5.000   3rd Qu.:0.3330   3rd Qu.:6.75  
##  Max.   :11.00   Max.   :26.000   Max.   :1.0000   Max.   : Inf  
##                                   NA's   :11       NA's   :22    
##       IBB               WP              HBP               BK        
##  Min.   :0.0000   Min.   :0.0000   Min.   :0.0000   Min.   :0.0000  
##  1st Qu.:0.0000   1st Qu.:0.0000   1st Qu.:0.0000   1st Qu.:0.0000  
##  Median :0.0000   Median :0.0000   Median :0.0000   Median :0.0000  
##  Mean   :0.1435   Mean   :0.1419   Mean   :0.1701   Mean   :0.0064  
##  3rd Qu.:0.0000   3rd Qu.:0.0000   3rd Qu.:0.0000   3rd Qu.:0.0000  
##  Max.   :4.0000   Max.   :5.0000   Max.   :4.0000   Max.   :1.0000  
##                                                                     
##       BFP              GF               R                SH        
##  Min.   : 0.00   Min.   :0.0000   Min.   : 0.000   Min.   :0.0000  
##  1st Qu.: 7.00   1st Qu.:0.0000   1st Qu.: 0.000   1st Qu.:0.0000  
##  Median :13.00   Median :0.0000   Median : 1.000   Median :0.0000  
##  Mean   :16.39   Mean   :0.4211   Mean   : 1.791   Mean   :0.1299  
##  3rd Qu.:22.00   3rd Qu.:1.0000   3rd Qu.: 3.000   3rd Qu.:0.0000  
##  Max.   :78.00   Max.   :5.0000   Max.   :13.000   Max.   :3.0000  
##                                                                    
##        SF               GIDP       
##  Min.   :0.00000   Min.   :0.0000  
##  1st Qu.:0.00000   1st Qu.:0.0000  
##  Median :0.00000   Median :0.0000  
##  Mean   :0.09467   Mean   :0.2968  
##  3rd Qu.:0.00000   3rd Qu.:0.0000  
##  Max.   :3.00000   Max.   :6.0000  
## 
view(Pitching_Data)
summary(Pitching_Data$W)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##  0.0000  0.0000  0.0000  0.2155  0.0000  3.0000
summary(Pitching_Data$ERA)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max.    NA's 
##    0.00    0.00    2.57     Inf    6.75     Inf      22
table(Pitching_Data$teamID)
## 
## ANA ARI ATL BAL BOS CHA CHN CIN CLE COL DET FLO HOU KCA LAA LAN MIA MIL MIN NYA 
##  36  80 199  42 226  67 133  36 117  66 108  29 262  68  64 288  17  76  97 347 
## NYN OAK PHI PIT SDN SEA SFN SLN TBA TEX TOR WAS 
##  94 113 142  25  82  60 179 315 150  91  65  76
table(Pitching_Data$lgID)
## 
##   AL   NL 
## 1854 1896

QUESTION-1: Lets find out which league (AL,NL) has best post IPouts from 2000-2022.

k <-
  Pitching_Data |>
  group_by(yearID,lgID) |>
  summarise(mean_IPouts = mean(IPouts),.groups = 'keep')

k |>
  ggplot(aes(x=yearID,y=mean_IPouts,group=lgID,color=lgID))+
  geom_point()+
  geom_smooth(se=FALSE)+
  theme_classic()
## `geom_smooth()` using method = 'loess' and formula = 'y ~ x'

OBSERVATION: Here we can see that until the year 2013 American League has the best post IPouts and after that National League took the first place.

  1. Question 2: Lets find out the players with less than 4.00 ERA (Earned Runs Average) - represents the number of earned runs a pitcher allows per nine innings
Pitching_Data |>
  filter(ERA < 4.00 & ERA > 0.00 )|>
  select(playerID,yearID,teamID,lgID,ERA)|>
  arrange(ERA)
##      playerID yearID teamID lgID  ERA
## 1   bumgama01   2014    SFN   NL 0.43
## 2   schilcu01   2001    ARI   NL 0.50
## 3   verlaju01   2017    HOU   AL 0.56
## 4   verlaju01   2012    DET   AL 0.56
## 5   pettian01   2003    NYA   AL 0.57
## 6    colege01   2019    HOU   AL 0.57
## 7   lestejo01   2013    BOS   AL 0.59
## 8   suppaje01   2006    SLN   NL 0.60
## 9    webblo01   2021    SFN   NL 0.61
## 10  kershcl01   2013    LAN   NL 0.69
## 11  hendrky01   2016    CHN   NL 0.71
## 12  buehlwa01   2019    LAN   NL 0.71
## 13  santajo01   2004    MIN   AL 0.75
## 14  buehlwa01   2020    LAN   NL 0.82
## 15  mcculla02   2021    HOU   AL 0.84
## 16  hollade01   2011    TEX   AL 0.87
## 17  moorema02   2011    TBA   AL 0.90
## 18  mcculla02   2017    HOU   AL 0.90
## 19   lowede01   2003    BOS   AL 0.93
## 20  hudsoti01   2001    OAK   AL 0.93
## 21  sabatcc01   2017    NYA   AL 0.96
## 22  schilcu01   2001    ARI   NL 1.00
## 23  priorma01   2003    CHN   NL 1.00
## 24  pavanca01   2003    FLO   NL 1.00
## 25  hendrky01   2016    CHN   NL 1.00
## 26  cuetojo01   2015    KCA   AL 1.00
## 27  carmofa01   2007    CLE   AL 1.00
## 28  buehrma01   2005    CHA   AL 1.00
## 29  zimmejo02   2014    WAS   NL 1.04
## 30  johnsra05   2001    ARI   NL 1.04
## 31  verlaju01   2012    DET   AL 1.08
## 32  estrama01   2016    TOR   AL 1.08
## 33    leecl02   2009    PHI   NL 1.10
## 34  beckejo02   2003    FLO   NL 1.10
## 35  wainwad01   2013    SLN   NL 1.12
## 36  wainwad01   2009    SLN   NL 1.12
## 37  uriasju01   2020    LAN   NL 1.12
## 38  scherma01   2021    LAN   NL 1.12
## 39  scherma01   2019    WAS   NL 1.12
## 40  moorema02   2016    SFN   NL 1.12
## 41  johnsra05   2001    ARI   NL 1.12
## 42  cuetojo01   2016    SFN   NL 1.12
## 43   zitoba01   2006    OAK   AL 1.12
## 44   zitoba01   2001    OAK   AL 1.12
## 45  verlaju01   2013    DET   AL 1.12
## 46  sabatcc01   2009    NYA   AL 1.12
## 47  riverma01   2003    NYA   AL 1.12
## 48    leecl02   2010    TEX   AL 1.12
## 49  eovalna01   2018    BOS   AL 1.12
## 50   woodal02   2017    LAN   NL 1.17
## 51  schmija01   2002    SFN   NL 1.17
## 52  hernali01   2000    SFN   NL 1.17
## 53  wellsda01   2003    NYA   AL 1.17
## 54  ogandal01   2011    TEX   AL 1.17
## 55  biebesh01   2022    CLE   AL 1.17
## 56  morrima01   2001    SLN   NL 1.20
## 57  wachami01   2013    SLN   NL 1.23
## 58  sanchjo01   2010    SFN   NL 1.23
## 59  hudsoti01   2014    SFN   NL 1.23
## 60  weaveje02   2009    LAA   AL 1.23
## 61   seleaa01   2000    SEA   AL 1.23
## 62  scherma01   2011    DET   AL 1.23
## 63  williwo02   2001    SLN   NL 1.29
## 64   webbbr01   2007    ARI   NL 1.29
## 65  wainwad01   2012    SLN   NL 1.29
## 66  vogelry01   2012    SFN   NL 1.29
## 67  sorokmi01   2019    ATL   NL 1.29
## 68  smoltjo01   2005    ATL   NL 1.29
## 69  schilcu01   2002    ARI   NL 1.29
## 70  oswalro01   2005    HOU   NL 1.29
## 71  morrima01   2002    SLN   NL 1.29
## 72  lohseky01   2012    SLN   NL 1.29
## 73  liriafr01   2013    PIT   NL 1.29
## 74  lackejo01   2014    SLN   NL 1.29
## 75  knebeco01   2018    MIL   NL 1.29
## 76  gallayo01   2011    MIL   NL 1.29
## 77  darviyu01   2022    SDN   NL 1.29
## 78  collmjo01   2011    ARI   NL 1.29
## 79  beckejo02   2003    FLO   NL 1.29
## 80  baileho02   2012    CIN   NL 1.29
## 81  washbja01   2002    ANA   AL 1.29
## 82  ventuyo01   2014    KCA   AL 1.29
## 83  riverma01   2009    NYA   AL 1.29
## 84  riverma01   2004    NYA   AL 1.29
## 85  pettian01   2003    NYA   AL 1.29
## 86  mussimi01   2003    NYA   AL 1.29
## 87  gonzami03   2012    BAL   AL 1.29
## 88  giolilu01   2020    CHA   AL 1.29
## 89  escobke01   2005    LAA   AL 1.29
## 90  eovalna01   2018    BOS   AL 1.29
## 91   colege01   2018    HOU   AL 1.29
## 92  clemero02   2003    NYA   AL 1.29
## 93  beckejo02   2007    BOS   AL 1.29
## 94  bassich01   2020    OAK   AL 1.29
## 95  muldema01   2005    SLN   NL 1.35
## 96  madsory01   2010    PHI   NL 1.35
## 97  francje01   2007    COL   NL 1.35
## 98  billich01   2008    LAN   NL 1.35
## 99  arrieja01   2017    CHN   NL 1.35
## 100 alcansa01   2020    MIA   NL 1.35
## 101  wangch01   2005    NYA   AL 1.35
## 102 sabatcc01   2009    NYA   AL 1.35
## 103 hugheph01   2012    NYA   AL 1.35
## 104 clemero02   2001    NYA   AL 1.35
## 105 wheelza01   2022    PHI   NL 1.38
## 106 lestejo01   2016    CHN   NL 1.38
## 107 degroja01   2015    NYN   NL 1.38
## 108 tanakma01   2017    NYA   AL 1.38
## 109 garzama01   2008    TBA   AL 1.38
## 110 reamebr01   2000    SLN   NL 1.42
## 111 minormi01   2013    ATL   NL 1.42
## 112 linceti01   2012    SFN   NL 1.42
## 113 jimenub01   2007    COL   NL 1.42
## 114  hillri01   2018    LAN   NL 1.42
## 115 darviyu01   2017    LAN   NL 1.42
## 116 riverma01   2001    NYA   AL 1.42
## 117 richacl01   2008    CHA   AL 1.42
## 118 pettian01   2009    NYA   AL 1.42
## 119 pettian01   2001    NYA   AL 1.42
## 120 loaizes01   2004    NYA   AL 1.42
## 121 hollade01   2011    TEX   AL 1.42
## 122 hernaor01   2001    NYA   AL 1.42
## 123 estrama01   2015    TOR   AL 1.42
## 124  chenwe02   2012    BAL   AL 1.42
## 125 ventuyo01   2014    KCA   AL 1.46
## 126 valdefr01   2022    HOU   AL 1.46
## 127 zambrca01   2007    CHN   NL 1.50
## 128 wilsobr02   2020    ATL   NL 1.50
## 129 salasfe01   2011    SLN   NL 1.50
## 130   ryuhy01   2014    LAN   NL 1.50
## 131 moyerja01   2007    PHI   NL 1.50
## 132 mikolmi01   2019    SLN   NL 1.50
## 133 mikolmi01   2019    SLN   NL 1.50
## 134 lestejo01   2018    CHN   NL 1.50
## 135  hillri01   2018    LAN   NL 1.50
## 136 hernali01   2007    ARI   NL 1.50
## 137 glavito02   2001    ATL   NL 1.50
## 138  foggjo01   2007    COL   NL 1.50
## 139 flaheja01   2020    SLN   NL 1.50
## 140 buehlwa01   2020    LAN   NL 1.50
## 141 blantjo01   2008    PHI   NL 1.50
## 142 anderty01   2018    COL   NL 1.50
## 143  woodke02   2010    NYA   AL 1.50
## 144 verlaju01   2022    HOU   AL 1.50
## 145 shoemma01   2014    LAA   AL 1.50
## 146  shawbr01   2017    CLE   AL 1.50
## 147 sanchaa01   2016    TOR   AL 1.50
## 148 perezra01   2007    CLE   AL 1.50
## 149 moyerja01   2001    SEA   AL 1.50
## 150 miltoer01   2002    MIN   AL 1.50
## 151 milonto01   2012    OAK   AL 1.50
## 152 lewisco01   2011    TEX   AL 1.50
## 153 garzama01   2010    TBA   AL 1.50
## 154 fistedo01   2013    DET   AL 1.50
## 155 fistedo01   2012    DET   AL 1.50
## 156 diekmja01   2015    TEX   AL 1.50
## 157 burneaj01   2009    NYA   AL 1.50
## 158 brownke01   2004    NYA   AL 1.50
## 159 baldwja01   2000    CHA   AL 1.50
## 160 sabatcc01   2012    NYA   AL 1.53
## 161 radkebr01   2002    MIN   AL 1.54
## 162 garcifr02   2000    SEA   AL 1.54
## 163  zitoba01   2012    SFN   NL 1.59
## 164 wrighky01   2021    ATL   NL 1.59
## 165 vogelry01   2014    SFN   NL 1.59
## 166 syndeno01   2015    NYN   NL 1.59
## 167 suarera01   2022    PHI   NL 1.59
## 168 maedake01   2017    LAN   NL 1.59
## 169 borowjo01   2003    CHN   NL 1.59
## 170 backebr01   2005    HOU   NL 1.59
## 171  zitoba01   2000    OAK   AL 1.59
## 172 tomlijo01   2016    CLE   AL 1.59
## 173 scherma01   2012    DET   AL 1.59
## 174 saundjo01   2012    BAL   AL 1.59
## 175 saundjo01   2012    BAL   AL 1.59
## 176 santaer01   2009    LAA   AL 1.59
## 177 porceri01   2018    BOS   AL 1.59
## 178 peavyja01   2013    BOS   AL 1.59
## 179 masteju01   2008    BOS   AL 1.59
## 180 klubeco01   2016    CLE   AL 1.59
## 181 keuchda01   2017    HOU   AL 1.59
## 182 kahnlto01   2019    NYA   AL 1.59
## 183 hugheph01   2007    NYA   AL 1.59
## 184 gonzami03   2014    BAL   AL 1.59
## 185 burneaj01   2011    NYA   AL 1.59
## 186 blackni01   2009    MIN   AL 1.59
## 187 abbotpa01   2000    SEA   AL 1.59
## 188 wainwad01   2021    SLN   NL 1.69
## 189 wainwad01   2015    SLN   NL 1.69
## 190 snellbl01   2022    SDN   NL 1.69
## 191 schilcu01   2001    ARI   NL 1.69
## 192 quallch01   2005    HOU   NL 1.69
## 193 ortizru01   2000    SFN   NL 1.69
## 194 montgmi01   2016    CHN   NL 1.69
## 195 matzety01   2021    ATL   NL 1.69
## 196 matzety01   2020    ATL   NL 1.69
## 197 corpama01   2007    COL   NL 1.69
## 198 castilu02   2020    CIN   NL 1.69
## 199  bushda01   2008    MIL   NL 1.69
## 200 arroybr01   2010    CIN   NL 1.69
## 201 vargaja01   2014    KCA   AL 1.69
## 202 snellbl01   2019    TBA   AL 1.69
## 203 schilcu01   2007    BOS   AL 1.69
## 204 mendora01   2001    NYA   AL 1.69
## 205 eovalna01   2021    BOS   AL 1.69
## 206 allenco01   2017    CLE   AL 1.69
## 207 bumgama01   2014    SFN   NL 1.72
## 208 mortoch02   2017    HOU   AL 1.74
## 209  woodke02   2003    CHN   NL 1.76
## 210 vogelry01   2012    SFN   NL 1.80
## 211 suppaje01   2005    SLN   NL 1.80
## 212 strasst01   2014    WAS   NL 1.80
## 213 smithbu02   2001    SLN   NL 1.80
## 214 sanchan01   2019    WAS   NL 1.80
## 215 mileywa01   2018    MIL   NL 1.80
## 216 martich02   2020    ATL   NL 1.80
## 217 madsory01   2018    LAN   NL 1.80
## 218 jimenub01   2007    COL   NL 1.80
## 219  hillri01   2017    LAN   NL 1.80
## 220 garcija02   2011    SLN   NL 1.80
## 221   foxch02   2003    FLO   NL 1.80
## 222 familje01   2015    NYN   NL 1.80
## 223 davisdo02   2007    ARI   NL 1.80
## 224 darviyu01   2017    LAN   NL 1.80
## 225 cuetojo01   2010    CIN   NL 1.80
## 226 tanakma01   2019    NYA   AL 1.80
## 227 tanakma01   2018    NYA   AL 1.80
## 228 pivetni01   2021    BOS   AL 1.80
## 229 mortoch02   2020    TBA   AL 1.80
## 230 mortoch02   2019    TBA   AL 1.80
## 231 millean01   2017    CLE   AL 1.80
## 232  happja01   2016    TOR   AL 1.80
## 233 guthrje01   2014    KCA   AL 1.80
## 234  grayso01   2017    NYA   AL 1.80
## 235 foulkke01   2004    BOS   AL 1.80
## 236 clevimi01   2018    CLE   AL 1.80
## 237 berrijo01   2020    MIN   AL 1.80
## 238 oswalro01   2010    PHI   NL 1.84
## 239 colonba01   2001    CLE   AL 1.84
## 240 lestejo01   2017    CHN   NL 1.86
## 241 solissa01   2016    WAS   NL 1.93
## 242 rzepcma01   2011    SLN   NL 1.93
## 243 rodrife01   2002    SFN   NL 1.93
## 244 newcose01   2018    ATL   NL 1.93
## 245 montgmi01   2016    CHN   NL 1.93
## 246  matzst01   2015    NYN   NL 1.93
## 247 lestejo01   2017    CHN   NL 1.93
## 248 hudsoda02   2019    SLN   NL 1.93
## 249 hamelco01   2008    PHI   NL 1.93
## 250 guerrju02   2018    MIL   NL 1.93
## 251 greensh02   2020    ATL   NL 1.93
## 252 teperry01   2021    CHA   AL 1.93
## 253 stephtr01   2022    CLE   AL 1.93
## 254 soriara01   2011    NYA   AL 1.93
## 255 roberda08   2017    NYA   AL 1.93
## 256 riverma01   2001    NYA   AL 1.93
## 257 riverma01   2000    NYA   AL 1.93
## 258 porceri01   2018    BOS   AL 1.93
## 259 doubrfe01   2013    BOS   AL 1.93
## 260 dickera01   2015    TOR   AL 1.93
## 261 beckejo02   2007    BOS   AL 1.93
## 262 anderni01   2020    TBA   AL 1.93
## 263 priceda01   2018    BOS   AL 1.98
## 264 pettian01   2000    NYA   AL 1.98
## 265 lewisco01   2010    TEX   AL 1.98
## 266 uriasju01   2021    LAN   NL 2.00
## 267 garlajo01   2005    CHA   AL 2.00
## 268 garcifr02   2005    CHA   AL 2.00
## 269 carpech01   2006    SLN   NL 2.02
## 270  maysjo01   2002    MIN   AL 2.02
## 271  colege01   2022    NYA   AL 2.02
## 272 worreti01   2002    SFN   NL 2.08
## 273 withrch01   2013    LAN   NL 2.08
## 274 wheelda01   2005    HOU   NL 2.08
## 275 scherma01   2021    LAN   NL 2.08
## 276  romose01   2012    SFN   NL 2.08
## 277 mainejo01   2006    NYN   NL 2.08
## 278 madsory01   2011    PHI   NL 2.08
## 279 madsory01   2009    PHI   NL 2.08
## 280 lopezja02   2010    SFN   NL 2.08
## 281 lidgebr01   2004    HOU   NL 2.08
## 282 klinest02   2001    SLN   NL 2.08
## 283 kimbrcr01   2010    ATL   NL 2.08
## 284 karsast01   2001    ATL   NL 2.08
## 285  hillri01   2017    LAN   NL 2.08
## 286 gryboke01   2004    ATL   NL 2.08
## 287 gratebr01   2021    LAN   NL 2.08
## 288 urquijo01   2020    HOU   AL 2.08
## 289 taillja01   2022    NYA   AL 2.08
## 290 stantmi02   2000    NYA   AL 2.08
## 291 stanery01   2021    HOU   AL 2.08
## 292 rodrifr03   2002    ANA   AL 2.08
## 293 pocheco01   2019    TBA   AL 2.08
## 294 muldema01   2002    OAK   AL 2.08
## 295 matusbr01   2012    BAL   AL 2.08
## 296 loaisjo01   2022    NYA   AL 2.08
## 297  grayso01   2013    OAK   AL 2.08
## 298 fairbpe01   2020    TBA   AL 2.08
## 299 escobke01   2005    LAA   AL 2.08
## 300 curtijo02   2020    TBA   AL 2.08
## 301 barnema01   2018    BOS   AL 2.08
## 302 anderni01   2019    TBA   AL 2.08
## 303 adamsmi03   2011    TEX   AL 2.08
## 304 paxtoja01   2019    NYA   AL 2.16
## 305 kurodhi01   2012    NYA   AL 2.16
## 306 bondeje01   2006    DET   AL 2.16
## 307 pennybr01   2003    FLO   NL 2.19
## 308 ortizru01   2002    SFN   NL 2.19
## 309  cainma01   2012    SFN   NL 2.19
## 310 woodrbr01   2019    MIL   NL 2.25
## 311 syndeno01   2022    PHI   NL 2.25
## 312 stammcr01   2014    WAS   NL 2.25
## 313 smoltjo01   2001    ATL   NL 2.25
## 314 ruschgl01   2000    NYN   NL 2.25
## 315 rodrife01   2003    SFN   NL 2.25
## 316 reyesan01   2006    SLN   NL 2.25
## 317 neshepa01   2014    SLN   NL 2.25
## 318 motteja01   2012    SLN   NL 2.25
## 319 moralfr01   2007    COL   NL 2.25
## 320 madsory01   2017    WAS   NL 2.25
## 321 madsory01   2008    PHI   NL 2.25
## 322 leiteal01   2000    NYN   NL 2.25
## 323   kuoho01   2009    LAN   NL 2.25
## 324 henrydo01   2000    SFN   NL 2.25
## 325 hallaro01   2011    PHI   NL 2.25
## 326 duensbr01   2017    CHN   NL 2.25
## 327 doteloc01   2011    SLN   NL 2.25
## 328 doolise01   2019    WAS   NL 2.25
## 329 dominse01   2022    PHI   NL 2.25
## 330 buehlwa01   2020    LAN   NL 2.25
## 331 benesan01   2000    SLN   NL 2.25
## 332 axforjo01   2011    MIL   NL 2.25
## 333 anderbr02   2001    ARI   NL 2.25
## 334 youngch03   2015    KCA   AL 2.25
## 335 whitlga01   2021    BOS   AL 2.25
## 336 valdefr01   2020    HOU   AL 2.25
## 337 shielsc01   2007    LAA   AL 2.25
## 338 santajo01   2006    MIN   AL 2.25
## 339 sanchan01   2013    DET   AL 2.25
## 340 proctsc01   2006    NYA   AL 2.25
## 341 priceda01   2014    DET   AL 2.25
## 342 montgjo01   2020    NYA   AL 2.25
## 343 montera01   2022    HOU   AL 2.25
## 344 masteju01   2008    BOS   AL 2.25
## 345 lewisco01   2011    TEX   AL 2.25
## 346 hollagr01   2014    KCA   AL 2.25
## 347 greinza01   2020    HOU   AL 2.25
## 348 graveke01   2021    HOU   AL 2.25
## 349 duchsju01   2006    OAK   AL 2.25
## 350 brittza01   2018    NYA   AL 2.25
## 351 berrijo01   2019    MIN   AL 2.25
## 352 albural01   2013    DET   AL 2.25
## 353  lowede01   2010    ATL   NL 2.31
## 354 kershcl01   2020    LAN   NL 2.31
## 355 lestejo01   2013    BOS   AL 2.31
## 356 pavanca01   2003    FLO   NL 2.35
## 357 harvema01   2015    NYN   NL 2.35
## 358 wellsda01   2003    NYA   AL 2.35
## 359 lewisco01   2010    TEX   AL 2.35
## 360 lestejo01   2013    BOS   AL 2.35
## 361 contrjo01   2005    CHA   AL 2.35
## 362 oswalro01   2004    HOU   NL 2.38
## 363 arrieja01   2016    CHN   NL 2.38
## 364 lackejo01   2005    LAA   AL 2.38
## 365 greinza01   2013    LAN   NL 2.40
## 366  woodtr01   2015    CHN   NL 2.45
## 367  wadeco01   2008    LAN   NL 2.45
## 368 treinbl01   2021    LAN   NL 2.45
## 369 stephga01   2000    SLN   NL 2.45
## 370 salasfe01   2011    SLN   NL 2.45
## 371 rodriwa01   2005    HOU   NL 2.45
## 372 neshepa01   2014    SLN   NL 2.45
## 373 morrobr01   2017    LAN   NL 2.45
## 374  lynnla01   2013    SLN   NL 2.45
## 375 kershcl01   2017    LAN   NL 2.45
## 376 johnsty01   2006    SLN   NL 2.45
## 377 howeljp01   2013    LAN   NL 2.45
## 378 hamptmi01   2004    ATL   NL 2.45
## 379 gonzavi02   2020    LAN   NL 2.45
## 380 glavito02   2006    NYN   NL 2.45
## 381 dovalca01   2021    SFN   NL 2.45
## 382  colege01   2013    PIT   NL 2.45
## 383 chacijh01   2018    MIL   NL 2.45
## 384 broxtjo01   2009    LAN   NL 2.45
## 385 ashbyan01   2000    ATL   NL 2.45
## 386 alvarjo03   2022    PHI   NL 2.45
## 387 taylobl01   2020    HOU   AL 2.45
## 388 tanakma01   2019    NYA   AL 2.45
## 389 smithjo05   2019    HOU   AL 2.45
## 390 peacobr01   2017    HOU   AL 2.45
## 391 muldema01   2001    OAK   AL 2.45
## 392 matonph01   2021    HOU   AL 2.45
## 393 jepseke01   2009    LAA   AL 2.45
## 394 hernaor01   2000    NYA   AL 2.45
## 395 greinza01   2019    HOU   AL 2.45
## 396 greench03   2018    NYA   AL 2.45
## 397 gausmke01   2014    BAL   AL 2.45
## 398 fistedo01   2011    DET   AL 2.45
## 399 feyerjo01   2021    TBA   AL 2.45
## 400 eovalna01   2018    BOS   AL 2.45
## 401 dysonsa01   2015    TEX   AL 2.45
## 402 choatra01   2001    NYA   AL 2.45
## 403 castidi01   2020    TBA   AL 2.45
## 404 benoijo01   2011    DET   AL 2.45
## 405  baezda01   2001    CLE   AL 2.45
## 406 strasst01   2019    WAS   NL 2.51
## 407 pettian01   2001    NYA   AL 2.51
## 408 valdefr01   2021    HOU   AL 2.53
## 409  wolfra02   2011    MIL   NL 2.57
## 410 wainwad01   2013    SLN   NL 2.57
## 411 uriasju01   2020    LAN   NL 2.57
## 412 urbinug01   2003    FLO   NL 2.57
## 413 suppaje01   2004    SLN   NL 2.57
## 414 myersbr01   2008    PHI   NL 2.57
## 415 millewa04   2001    HOU   NL 2.57
## 416  kileda01   2000    SLN   NL 2.57
## 417 degroja01   2015    NYN   NL 2.57
## 418 bumgama01   2014    SFN   NL 2.57
## 419 anderia01   2020    ATL   NL 2.57
## 420 youngch03   2015    KCA   AL 2.57
## 421 weaveje02   2014    LAA   AL 2.57
## 422 wakefti01   2003    BOS   AL 2.57
## 423 valdefr01   2020    HOU   AL 2.57
## 424 urquijo01   2020    HOU   AL 2.57
## 425 sanchan01   2012    DET   AL 2.57
## 426 pettian01   2010    NYA   AL 2.57
## 427 pettian01   2010    NYA   AL 2.57
## 428 pavanca01   2009    MIN   AL 2.57
## 429 mussimi01   2004    NYA   AL 2.57
## 430 moyerja01   2001    SEA   AL 2.57
## 431 miltoer01   2002    MIN   AL 2.57
## 432 mcclash01   2022    TBA   AL 2.57
## 433 lackejo01   2013    BOS   AL 2.57
## 434 garlajo01   2005    CHA   AL 2.57
## 435 fistedo01   2012    DET   AL 2.57
## 436 estrama01   2016    TOR   AL 2.57
## 437  colege01   2020    NYA   AL 2.57
## 438 kershcl01   2015    LAN   NL 2.63
## 439 lackejo01   2008    LAA   AL 2.63
## 440  woodtr01   2016    CHN   NL 2.70
## 441  woodal02   2018    LAN   NL 2.70
## 442 uriasju01   2018    LAN   NL 2.70
## 443 treinbl01   2021    LAN   NL 2.70
## 444 suarera01   2022    PHI   NL 2.70
## 445 stroppe01   2017    CHN   NL 2.70
## 446 smoltjo01   2002    ATL   NL 2.70
## 447 siegrke01   2013    SLN   NL 2.70
## 448 rueteki01   2002    SFN   NL 2.70
## 449 reyesal02   2020    SLN   NL 2.70
## 450 remlimi01   2003    CHN   NL 2.70
## 451 remlimi01   2000    ATL   NL 2.70
## 452   nenro01   2002    SFN   NL 2.70
## 453 mchugco01   2022    ATL   NL 2.70
## 454   maydu01   2019    LAN   NL 2.70
## 455 marshse01   2008    CHN   NL 2.70
## 456 kershcl01   2009    LAN   NL 2.70
## 457 garcija01   2012    SFN   NL 2.70
## 458 doolise01   2019    WAS   NL 2.70
## 459 darviyu01   2020    CHN   NL 2.70
## 460 chapmar01   2016    CHN   NL 2.70
## 461 batismi01   2001    ARI   NL 2.70
## 462  baezpe01   2020    LAN   NL 2.70
## 463 anderbr02   2001    ARI   NL 2.70
## 464 wellsda01   2005    BOS   AL 2.70
## 465 sturtta01   2004    NYA   AL 2.70
## 466 snellbl01   2020    TBA   AL 2.70
## 467  shawbr01   2016    CLE   AL 2.70
## 468 schilcu01   2004    BOS   AL 2.70
## 469 scherma01   2013    DET   AL 2.70
## 470 rodrifr03   2005    LAA   AL 2.70
## 471 raleybr01   2021    HOU   AL 2.70
## 472 radkebr01   2002    MIN   AL 2.70
## 473 priceda01   2008    TBA   AL 2.70
## 474 pettian01   2012    NYA   AL 2.70
## 475 pettian01   2000    NYA   AL 2.70
## 476 oteroda01   2016    CLE   AL 2.70
## 477 matonph01   2020    CLE   AL 2.70
## 478 herreke01   2014    KCA   AL 2.70
## 479 hamelco01   2015    TEX   AL 2.70
## 480 felizne01   2011    TEX   AL 2.70
## 481 daviswa01   2014    KCA   AL 2.70
## 482 darviyu01   2012    TEX   AL 2.70
## 483 curtijo02   2020    TBA   AL 2.70
## 484 cortene01   2022    NYA   AL 2.70
## 485  cokeph01   2012    DET   AL 2.70
## 486  cokeph01   2011    DET   AL 2.70
## 487 chambjo03   2010    NYA   AL 2.70
## 488 betande01   2018    NYA   AL 2.70
## 489 arroybr01   2003    BOS   AL 2.70
## 490 williwo02   2004    SLN   NL 2.77
## 491 weaveje01   2006    SLN   NL 2.77
## 492 hamelco01   2008    PHI   NL 2.77
## 493 flaheja01   2019    SLN   NL 2.77
## 494 darviyu01   2022    SDN   NL 2.77
## 495 estrama01   2015    TOR   AL 2.77
## 496   leecl02   2009    PHI   NL 2.81
## 497 klubeco01   2016    CLE   AL 2.81
## 498 medlekr01   2012    ATL   NL 2.84
## 499 hernali01   2002    SFN   NL 2.84
## 500 friedma01   2020    ATL   NL 2.84
## 501 carpech01   2011    SLN   NL 2.84
## 502 burkejo03   2001    ATL   NL 2.84
## 503 backebr01   2004    HOU   NL 2.84
## 504 sanchan01   2012    DET   AL 2.84
## 505  salech01   2018    BOS   AL 2.84
## 506 radkebr01   2003    MIN   AL 2.84
## 507 pettian01   2009    NYA   AL 2.84
## 508 mcculla02   2015    HOU   AL 2.84
## 509 hernaor01   2002    NYA   AL 2.84
## 510 chacosh01   2005    NYA   AL 2.84
## 511 leiteal01   2000    NYN   NL 2.87
## 512 woodrbr01   2018    MIL   NL 2.89
## 513 mainejo01   2006    NYN   NL 2.89
## 514 halamjo01   2000    SEA   AL 2.89
## 515 wilsocj01   2011    TEX   AL 2.92
## 516 zerbech01   2002    SFN   NL 3.00
## 517  woodke02   2007    CHN   NL 3.00
## 518 williwo02   2004    SLN   NL 3.00
## 519 wainwad01   2019    SLN   NL 3.00
## 520 wagnebi02   2006    NYN   NL 3.00
## 521 veresda01   2003    CHN   NL 3.00
## 522 uriasju01   2018    LAN   NL 3.00
## 523 urbinug01   2003    FLO   NL 3.00
## 524 tavarju01   2004    SLN   NL 3.00
## 525 suppaje01   2004    SLN   NL 3.00
## 526 strasst01   2019    WAS   NL 3.00
## 527 rosentr01   2014    SLN   NL 3.00
## 528 rodrifr03   2011    MIL   NL 3.00
## 529  reedri01   2000    NYN   NL 3.00
## 530  reedri01   2000    NYN   NL 3.00
## 531 redmama01   2003    FLO   NL 3.00
## 532 pettian01   2005    HOU   NL 3.00
## 533 musgrjo01   2022    SDN   NL 3.00
## 534 mujiced01   2012    SLN   NL 3.00
## 535 motteja01   2012    SLN   NL 3.00
## 536  mossda01   2002    ATL   NL 3.00
## 537 morrima01   2005    SLN   NL 3.00
## 538 matzety01   2021    ATL   NL 3.00
## 539 maedake01   2018    LAN   NL 3.00
## 540 maddugr01   2003    ATL   NL 3.00
## 541 maddugr01   2002    ATL   NL 3.00
## 542 maddugr01   2001    ATL   NL 3.00
## 543  lynnla01   2014    SLN   NL 3.00
## 544  lowede01   2008    LAN   NL 3.00
## 545 liriafr01   2013    PIT   NL 3.00
## 546 lidgebr01   2008    PHI   NL 3.00
## 547 kurodhi01   2008    LAN   NL 3.00
## 548   kuoho01   2008    LAN   NL 3.00
## 549  kileda01   2001    SLN   NL 3.00
## 550 kershcl01   2016    LAN   NL 3.00
## 551 jacksed01   2011    SLN   NL 3.00
## 552 isrinja01   2005    SLN   NL 3.00
## 553 heilmaa01   2006    NYN   NL 3.00
## 554 heanean01   2022    LAN   NL 3.00
## 555  happja01   2008    PHI   NL 3.00
## 556 hamelco01   2010    PHI   NL 3.00
## 557 guerrja01   2019    WAS   NL 3.00
## 558 gryboke01   2003    ATL   NL 3.00
## 559 greinza01   2013    LAN   NL 3.00
## 560 garcifr02   2013    ATL   NL 3.00
## 561 francje01   2007    COL   NL 3.00
## 562 felicpe01   2006    NYN   NL 3.00
## 563 dominse01   2022    PHI   NL 3.00
## 564 degroja01   2022    NYN   NL 3.00
## 565 clippty01   2012    WAS   NL 3.00
## 566 clemero02   2005    HOU   NL 3.00
## 567 clemero02   2004    HOU   NL 3.00
## 568 cingrto01   2017    LAN   NL 3.00
## 569 chapmar01   2012    CIN   NL 3.00
## 570 carpech01   2011    SLN   NL 3.00
## 571 carpech01   2005    SLN   NL 3.00
## 572 bumgama01   2010    SFN   NL 3.00
## 573 brazoyh01   2004    LAN   NL 3.00
## 574 blantjo01   2008    PHI   NL 3.00
## 575 benitar01   2000    NYN   NL 3.00
## 576 backebr01   2004    HOU   NL 3.00
## 577 arrieja01   2016    CHN   NL 3.00
## 578 zumayjo01   2006    DET   AL 3.00
## 579 wilsocj01   2010    TEX   AL 3.00
## 580 willisc01   2003    BOS   AL 3.00
## 581 volqued01   2015    KCA   AL 3.00
## 582 vargaja01   2014    KCA   AL 3.00
## 583 urquijo01   2021    HOU   AL 3.00
## 584 ueharko01   2013    BOS   AL 3.00
## 585 stromma01   2016    TOR   AL 3.00
## 586 streehu01   2006    OAK   AL 3.00
## 587 snellbl01   2020    TBA   AL 3.00
## 588 shielja02   2014    KCA   AL 3.00
## 589 scruban01   2020    HOU   AL 3.00
## 590 scherma01   2013    DET   AL 3.00
## 591 sabatcc01   2001    CLE   AL 3.00
## 592 riverma01   2005    NYA   AL 3.00
## 593 riverma01   2000    NYA   AL 3.00
## 594 rincoju01   2006    MIN   AL 3.00
## 595   rayro02   2020    TOR   AL 3.00
## 596 raleybr01   2021    HOU   AL 3.00
## 597 pressry01   2021    HOU   AL 3.00
## 598 percitr01   2002    ANA   AL 3.00
## 599 peralwa01   2022    NYA   AL 3.00
## 600 peacobr01   2019    HOU   AL 3.00
## 601 ottavad01   2021    BOS   AL 3.00
## 602 mussimi01   2001    NYA   AL 3.00
## 603 mulhote01   2004    MIN   AL 3.00
## 604 mcculla02   2018    HOU   AL 3.00
## 605 lewisco01   2015    TEX   AL 3.00
## 606 kellyjo05   2018    BOS   AL 3.00
## 607  kelake01   2015    TEX   AL 3.00
## 608 jamesjo02   2020    HOU   AL 3.00
## 609 hugheph01   2012    NYA   AL 3.00
## 610 houckta01   2021    BOS   AL 3.00
## 611 herreke01   2015    KCA   AL 3.00
## 612 harenda01   2006    OAK   AL 3.00
## 613 greinza01   2020    HOU   AL 3.00
## 614 gregelu01   2015    HOU   AL 3.00
## 615 graveke01   2021    HOU   AL 3.00
## 616 glasnty01   2020    TBA   AL 3.00
## 617 fuentbr01   2009    LAA   AL 3.00
## 618 fairbpe01   2020    TBA   AL 3.00
## 619 chambjo03   2009    NYA   AL 3.00
## 620 bradfch01   2008    TBA   AL 3.00
## 621 bonsebo01   2006    MIN   AL 3.00
## 622 betande01   2017    NYA   AL 3.00
## 623 balfogr01   2008    TBA   AL 3.00
## 624 arroybr01   2004    BOS   AL 3.00
## 625 weaveje01   2006    SLN   NL 3.09
## 626 wainwad01   2014    SLN   NL 3.09
## 627 muldema01   2005    SLN   NL 3.09
## 628 keuchda01   2017    HOU   AL 3.09
## 629 janseke01   2017    LAN   NL 3.12
## 630 verlaju01   2017    HOU   AL 3.12
## 631 pivetni01   2021    BOS   AL 3.12
## 632 contrjo01   2005    CHA   AL 3.12
## 633 priorma01   2003    CHN   NL 3.14
## 634 linceti01   2010    SFN   NL 3.14
## 635 liebejo01   2004    NYA   AL 3.14
## 636 worreti01   2002    SFN   NL 3.18
## 637 mortoch02   2013    PIT   NL 3.18
## 638 millesh01   2014    SLN   NL 3.18
## 639  lynnla01   2014    SLN   NL 3.18
## 640 lohseky01   2012    SLN   NL 3.18
## 641 valdefr01   2022    HOU   AL 3.18
## 642 stantmi02   2001    NYA   AL 3.18
## 643 sonnaan01   2008    TBA   AL 3.18
## 644 rodrifr03   2002    ANA   AL 3.18
## 645  lowede01   2004    BOS   AL 3.18
## 646 hernaor01   2001    NYA   AL 3.18
## 647 hammeja01   2012    BAL   AL 3.18
## 648  colege01   2020    NYA   AL 3.18
## 649 biebesh01   2022    CLE   AL 3.18
## 650 harvema01   2015    NYN   NL 3.21
## 651 hernali01   2002    SFN   NL 3.24
## 652 beckejo02   2003    FLO   NL 3.26
## 653 millwke01   2002    ATL   NL 3.27
## 654 hendrky01   2017    CHN   NL 3.27
## 655 linceti01   2010    SFN   NL 3.29
## 656 greinza01   2015    LAN   NL 3.29
## 657 sabatcc01   2009    NYA   AL 3.29
## 658  woodal02   2020    LAN   NL 3.38
## 659 wilsoju10   2013    PIT   NL 3.38
## 660 stroppe01   2015    CHN   NL 3.38
## 661 roberda08   2022    PHI   NL 3.38
## 662 roarkta01   2014    WAS   NL 3.38
## 663 ottavad01   2018    COL   NL 3.38
## 664 martini01   2022    SDN   NL 3.38
## 665 marquja01   2005    SLN   NL 3.38
## 666 madsory01   2009    PHI   NL 3.38
## 667   leedy01   2022    ATL   NL 3.38
## 668 kellyjo05   2013    SLN   NL 3.38
## 669 kellyjo05   2013    SLN   NL 3.38
## 670 johnsra05   2001    ARI   NL 3.38
## 671  hillri01   2019    LAN   NL 3.38
## 672  happja01   2009    PHI   NL 3.38
## 673 greensh02   2019    ATL   NL 3.38
## 674 garcilu03   2022    SDN   NL 3.38
## 675 garcich02   2012    WAS   NL 3.38
## 676 cahiltr01   2015    CHN   NL 3.38
## 677 cahiltr01   2015    CHN   NL 3.38
## 678 buehlwa01   2021    LAN   NL 3.38
## 679 boggsmi01   2011    SLN   NL 3.38
## 680 benesan01   2002    SLN   NL 3.38
## 681 bellaan01   2022    PHI   NL 3.38
## 682 anderbr02   2001    ARI   NL 3.38
## 683 affelje01   2010    SFN   NL 3.38
## 684 wellsda01   2003    NYA   AL 3.38
## 685 weberbe01   2002    ANA   AL 3.38
## 686 verlaju01   2019    HOU   AL 3.38
## 687 verlaju01   2018    HOU   AL 3.38
## 688 ventuyo01   2015    KCA   AL 3.38
## 689 urquijo01   2019    HOU   AL 3.38
## 690 tazawju01   2013    BOS   AL 3.38
## 691  salech01   2021    BOS   AL 3.38
## 692 robleha01   2021    BOS   AL 3.38
## 693 priceda01   2018    BOS   AL 3.38
## 694 pressry01   2018    HOU   AL 3.38
## 695 petityu01   2019    OAK   AL 3.38
## 696 peralwa01   2022    NYA   AL 3.38
## 697 peacobr01   2019    HOU   AL 3.38
## 698 osunaro01   2019    HOU   AL 3.38
## 699 oliveda02   2010    TEX   AL 3.38
## 700 nerishe01   2022    HOU   AL 3.38
## 701 mcculla02   2020    HOU   AL 3.38
## 702 matsuda01   2007    BOS   AL 3.38
## 703 marshev01   2020    CHA   AL 3.38
## 704 ledezwi01   2006    DET   AL 3.38
## 705 kazmisc01   2008    TBA   AL 3.38
## 706 hugheph01   2009    NYA   AL 3.38
## 707 hudsoti01   2000    OAK   AL 3.38
## 708 howrybo01   2000    CHA   AL 3.38
## 709 howeljp01   2008    TBA   AL 3.38
## 710 heredfe01   2003    NYA   AL 3.38
## 711  happja01   2019    NYA   AL 3.38
## 712 fairbpe01   2021    TBA   AL 3.38
## 713 doolise01   2012    OAK   AL 3.38
## 714  chenwe02   2014    BAL   AL 3.38
## 715 chapmar01   2020    NYA   AL 3.38
## 716 castidi01   2020    TBA   AL 3.38
## 717 carraca01   2018    CLE   AL 3.38
## 718  byrdpa01   2005    LAA   AL 3.38
## 719 brunebr01   2006    NYA   AL 3.38
## 720 bondeje01   2006    DET   AL 3.38
## 721 anderni01   2020    TBA   AL 3.38
## 722  zitoba01   2003    OAK   AL 3.46
## 723 stromma01   2015    TOR   AL 3.46
## 724 shielja02   2008    TBA   AL 3.46
## 725  lowede01   2008    LAN   NL 3.48
## 726 lackejo01   2015    SLN   NL 3.48
## 727 greinza01   2019    HOU   AL 3.48
## 728 appieke01   2002    ANA   AL 3.48
## 729 appieke01   2000    OAK   AL 3.48
## 730 clemema01   2003    CHN   NL 3.52
## 731 chapmar01   2016    CHN   NL 3.52
## 732 wakefti01   2003    BOS   AL 3.52
## 733 millean01   2016    CLE   AL 3.52
## 734 mcculla02   2017    HOU   AL 3.52
## 735 kurodhi01   2012    NYA   AL 3.52
## 736 hudsoti01   2003    OAK   AL 3.52
## 737 westbja01   2007    CLE   AL 3.55
## 738 wellsda01   2006    SDN   NL 3.60
## 739 senzaan01   2018    COL   NL 3.60
## 740 scherma01   2019    WAS   NL 3.60
## 741   ryuhy01   2019    LAN   NL 3.60
## 742 rueteki01   2003    SFN   NL 3.60
## 743 mortoch02   2021    ATL   NL 3.60
## 744  matzst01   2015    NYN   NL 3.60
## 745 marquge01   2018    COL   NL 3.60
## 746 lopezpa01   2020    MIA   NL 3.60
## 747 lackejo01   2016    CHN   NL 3.60
## 748 hernada01   2011    ARI   NL 3.60
## 749 harvema01   2015    NYN   NL 3.60
## 750 godleza01   2017    ARI   NL 3.60
## 751 corbipa01   2019    WAS   NL 3.60
## 752 burneco01   2018    MIL   NL 3.60
## 753 yarbrry01   2020    TBA   AL 3.60
## 754 yarbrry01   2020    TBA   AL 3.60
## 755 weaveje02   2007    LAA   AL 3.60
## 756 tomlijo01   2016    CLE   AL 3.60
## 757 tillmch01   2014    BAL   AL 3.60
## 758 tanakma01   2015    NYA   AL 3.60
## 759 shielsc01   2005    LAA   AL 3.60
## 760  seleaa01   2001    SEA   AL 3.60
## 761 roberna01   2006    DET   AL 3.60
## 762 osunaro01   2019    HOU   AL 3.60
## 763 odorija01   2019    MIN   AL 3.60
## 764 nathajo01   2004    MIN   AL 3.60
## 765 medlekr01   2015    KCA   AL 3.60
## 766 loaizes01   2006    OAK   AL 3.60
## 767 keuchda01   2018    HOU   AL 3.60
## 768 keuchda01   2018    HOU   AL 3.60
## 769 jenksbo01   2005    CHA   AL 3.60
## 770 harrima01   2011    TEX   AL 3.60
## 771  happja01   2016    TOR   AL 3.60
## 772 griffaj01   2012    OAK   AL 3.60
## 773 gallayo01   2015    TEX   AL 3.60
## 774 foulkke01   2003    OAK   AL 3.60
## 775 eovalna01   2021    BOS   AL 3.60
## 776 daviswa01   2010    TBA   AL 3.60
## 777 colliti01   2014    KCA   AL 3.60
## 778  cobbal01   2013    TBA   AL 3.60
## 779  byrdpa01   2007    CLE   AL 3.60
## 780  byrdpa01   2007    CLE   AL 3.60
## 781 buchhcl01   2009    BOS   AL 3.60
## 782 lackejo01   2009    LAA   AL 3.65
## 783 woodrbr01   2021    MIL   NL 3.68
## 784 syndeno01   2015    NYN   NL 3.68
## 785 scherma01   2017    WAS   NL 3.68
## 786 oswalro01   2005    HOU   NL 3.68
## 787 lestejo01   2016    CHN   NL 3.68
## 788 lestejo01   2015    CHN   NL 3.68
## 789 sonnaan01   2008    TBA   AL 3.68
## 790 garcifr02   2001    SEA   AL 3.68
## 791 sabatcc01   2017    NYA   AL 3.72
## 792 scherma01   2016    WAS   NL 3.75
## 793 washbja01   2002    ANA   AL 3.75
## 794 verlaju01   2017    HOU   AL 3.75
## 795 thornma01   2014    WAS   NL 3.86
## 796 sprinru01   2005    HOU   NL 3.86
## 797 sherrge01   2009    LAN   NL 3.86
## 798 salasfe01   2012    SLN   NL 3.86
## 799 rondohe01   2016    CHN   NL 3.86
## 800   rayro02   2017    ARI   NL 3.86
## 801  putzjj01   2011    ARI   NL 3.86
## 802 pettian01   2005    HOU   NL 3.86
## 803 myersbr01   2008    PHI   NL 3.86
## 804 mortoch02   2021    ATL   NL 3.86
## 805   maydu01   2020    LAN   NL 3.86
## 806 marquja01   2004    SLN   NL 3.86
## 807 manesse01   2013    SLN   NL 3.86
## 808 madsory01   2018    LAN   NL 3.86
## 809 loopebr01   2006    SLN   NL 3.86
## 810 leiteal01   2000    NYN   NL 3.86
## 811   lawde01   2016    SFN   NL 3.86
## 812 jimenub01   2007    COL   NL 3.86
## 813 henslcl01   2005    SDN   NL 3.86
## 814 garcija02   2011    SLN   NL 3.86
## 815 gallegi01   2019    SLN   NL 3.86
## 816 fultzaa01   2002    SFN   NL 3.86
## 817 friedma01   2018    ATL   NL 3.86
## 818 florody01   2020    LAN   NL 3.86
## 819 chapmar01   2016    CHN   NL 3.86
## 820 calerki01   2004    SLN   NL 3.86
## 821  cainma01   2012    SFN   NL 3.86
## 822 buehlwa01   2018    LAN   NL 3.86
## 823 broxtjo01   2015    SLN   NL 3.86
## 824 broxtjo01   2008    LAN   NL 3.86
## 825 betanra01   2009    COL   NL 3.86
## 826  baezpe01   2018    LAN   NL 3.86
## 827 anderia01   2021    ATL   NL 3.86
## 828 youngch03   2015    KCA   AL 3.86
## 829 yarbrry01   2020    TBA   AL 3.86
## 830  shawbr01   2016    CLE   AL 3.86
## 831 severlu01   2017    NYA   AL 3.86
## 832 rodrifr03   2004    ANA   AL 3.86
## 833 politcl01   2005    CHA   AL 3.86
## 834 pettian01   2012    NYA   AL 3.86
## 835 oteroda01   2016    CLE   AL 3.86
## 836 osunaro01   2019    HOU   AL 3.86
## 837 neaglde01   2000    NYA   AL 3.86
## 838 mussimi01   2007    NYA   AL 3.86
## 839 mussimi01   2003    NYA   AL 3.86
## 840 martipe02   2004    BOS   AL 3.86
## 841 martipe02   2003    BOS   AL 3.86
## 842 kahnlto01   2019    NYA   AL 3.86
## 843 gordoto01   2005    NYA   AL 3.86
## 844 garcifr02   2001    SEA   AL 3.86
## 845 frasoja01   2014    KCA   AL 3.86
## 846 finnebr01   2014    KCA   AL 3.86
## 847 embreal01   2004    BOS   AL 3.86
## 848 duffyda01   2015    KCA   AL 3.86
## 849 cuetojo01   2015    KCA   AL 3.86
## 850 contrjo01   2005    CHA   AL 3.86
## 851  colege01   2019    HOU   AL 3.86
## 852 clemero02   2003    NYA   AL 3.86
## 853 castilu02   2022    SEA   AL 3.86
## 854 bulgeja01   2009    LAA   AL 3.86
## 855 brittza01   2019    NYA   AL 3.86
## 856 brittza01   2014    BAL   AL 3.86
## 857 brittza01   2014    BAL   AL 3.86
## 858 bakersc02   2010    MIN   AL 3.86
## 859 verlaju01   2019    HOU   AL 3.95
## 860 pettian01   2000    NYA   AL 3.97

Bumgama01 has the best ERA from NL in 2000-2022 period - 0.43.

Question 3: Lets find the strike outs per season for last two decades.

overall_avg_so = mean(Pitching_Data$SO)
data <- Pitching_Data|>
  group_by(yearID)|>
  summarise(mean_SO = mean(SO))|>
  ggplot()+
  geom_line(aes(x=yearID,y=mean_SO))+
  ggtitle("Average strike outs for last two decades")+
  geom_hline(yintercept = overall_avg_so,color='red')+
  annotate("text",x=2004,y=3.4,label="Overall Average Strike Outs")+
  theme_classic()

data

OBSERVATION: Here we can see the mean of strikeouts per season for the last two decades, the red line indicates the average of the mean of strikeouts per season. we can see that from the year 2003 - 2006 the mean strikeout rate has dropped drastically, which also falls far from the average mean strikeout rate.

QUESTION-4: Lets find the ERA (Earned Run Average) for different leagues

Pitching_Data|>
  mutate(year=as.factor(yearID),League=as.factor(lgID))|>
  ggplot()+
  geom_boxplot(mapping = aes(x = lgID, y = ERA, color = League)) +
  labs(title = "ERA in different leagues",
       x = "Leagues",
       y = "ERA") +
  scale_color_brewer(palette = "Dark2") +
  theme_minimal()
## Warning: Removed 45 rows containing non-finite values (`stat_boxplot()`).

OBSERVATION: We can see that both the leagues have similar ERA with just a few outliers