new_year_by_year_batting.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1980':                           Name    H   AB     BA    OPS\n",
       " 0       Glenn Adams*\\adamsgl01   75  262  0.286  0.732\n",
       " 1        Luis Aguayo\\aguaylu01   13   47  0.277  0.747\n",
       " 2     Willie Aikens*\\aikenwi01  151  543  0.278  0.789\n",
       " 3        Danny Ainge\\aingeda01   27  111  0.243  0.578\n",
       " 4    Doyle Alexander\\alexado01   15   83  0.181  0.426\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 755          Ned Yost\\yostne01    5   31  0.161  0.323\n",
       " 756  Joel Youngblood\\youngjo02  142  514  0.276  0.721\n",
       " 757      Robin Yount\\yountro01  179  611  0.293  0.840\n",
       " 758       Pat Zachry\\zachrpa01    2   46  0.043  0.125\n",
       " 759       Richie Zisk\\ziskri01  130  448  0.290  0.804\n",
       " \n",
       " [760 rows x 5 columns],\n",
       " '1981':                           Name    H   AB     BA    OPS\n",
       " 0       Glenn Adams*\\adamsgl01   46  220  0.209  0.555\n",
       " 1        Luis Aguayo\\aguaylu01   18   84  0.214  0.580\n",
       " 2     Willie Aikens*\\aikenwi01   93  349  0.266  0.836\n",
       " 3        Danny Ainge\\aingeda01   46  246  0.187  0.486\n",
       " 4    Doyle Alexander\\alexado01    9   51  0.176  0.459\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 724          Ned Yost\\yostne01    6   27  0.222  0.856\n",
       " 725  Joel Youngblood\\youngjo02   50  143  0.350  0.929\n",
       " 726      Robin Yount\\yountro01  103  377  0.273  0.731\n",
       " 727       Pat Zachry\\zachrpa01    6   38  0.158  0.372\n",
       " 728       Richie Zisk\\ziskri01  111  357  0.311  0.851\n",
       " \n",
       " [729 rows x 5 columns],\n",
       " '1982':                           Name    H   AB     BA    OPS\n",
       " 0       Glenn Adams*\\adamsgl01   17   66  0.258  0.651\n",
       " 1        Ricky Adams\\adamsri02    2   14  0.143  0.343\n",
       " 2        Luis Aguayo\\aguaylu01   15   56  0.268  0.857\n",
       " 3     Willie Aikens*\\aikenwi01  131  466  0.281  0.802\n",
       " 4         Neil Allen\\allenne01    1    6  0.167  0.542\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 738  Joel Youngblood\\youngjo02   70  292  0.240  0.617\n",
       " 739      Robin Yount\\yountro01  210  635  0.331  0.957\n",
       " 740       Pat Zachry\\zachrpa01    3   38  0.079  0.182\n",
       " 741       Richie Zisk\\ziskri01  147  503  0.292  0.831\n",
       " 742     Paul Zuvella\\zuvelpa01    0    1  0.000  0.000\n",
       " \n",
       " [743 rows x 5 columns],\n",
       " '1983':                           Name    H   AB     BA    OPS\n",
       " 0        Ricky Adams\\adamsri02   28  112  0.250  0.621\n",
       " 1        Jim Adduci*\\adducji01    1   20  0.050  0.145\n",
       " 2       Juan Agosto*\\agostju01    0    0    NaN    NaN\n",
       " 3        Luis Aguayo\\aguaylu01    1    4  0.250  0.650\n",
       " 4     Willie Aikens*\\aikenwi01  124  410  0.302  0.912\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 777  Joel Youngblood\\youngjo02  109  373  0.292  0.855\n",
       " 778      Robin Yount\\yountro01  178  578  0.308  0.886\n",
       " 779       Pat Zachry\\zachrpa01    2    4  0.500  1.000\n",
       " 780       Richie Zisk\\ziskri01   69  285  0.242  0.722\n",
       " 781     Paul Zuvella\\zuvelpa01    0    5  0.000  0.375\n",
       " \n",
       " [782 rows x 5 columns],\n",
       " '1984':                           Name    H   AB     BA    OPS\n",
       " 0       Glenn Abbott\\abbotgl01    0    0    NaN    NaN\n",
       " 1       Juan Agosto*\\agostju01    0    0    NaN    NaN\n",
       " 2        Luis Aguayo\\aguaylu01   20   72  0.278  0.808\n",
       " 3     Willie Aikens*\\aikenwi01   48  234  0.205  0.674\n",
       " 4         Neil Allen\\allenne01    6   25  0.240  0.560\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 757  Joel Youngblood\\youngjo02  119  469  0.254  0.686\n",
       " 758      Robin Yount\\yountro01  186  624  0.298  0.803\n",
       " 759       Pat Zachry\\zachrpa01    2    6  0.333  0.667\n",
       " 760       Jeff Zaske\\zaskeje01    0    0    NaN    NaN\n",
       " 761     Paul Zuvella\\zuvelpa01    5   25  0.200  0.499\n",
       " \n",
       " [762 rows x 5 columns],\n",
       " '1985':                           Name    H   AB     BA    OPS\n",
       " 0      Johnny Abrego\\abregjo01    0    9  0.000  0.000\n",
       " 1        Ricky Adams\\adamsri02   23  121  0.190  0.509\n",
       " 2       Juan Agosto*\\agostju01    0    0    NaN    NaN\n",
       " 3        Luis Aguayo\\aguaylu01   46  165  0.279  0.844\n",
       " 4      Rick Aguilera\\aguilri01   10   36  0.278  0.631\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 745      Mike Young#\\youngmi01  123  450  0.273  0.861\n",
       " 746  Joel Youngblood\\youngjo02   62  230  0.270  0.703\n",
       " 747      Robin Yount\\yountro01  129  466  0.277  0.784\n",
       " 748       Pat Zachry\\zachrpa01    0    1  0.000  0.000\n",
       " 749     Paul Zuvella\\zuvelpa01   48  190  0.253  0.616\n",
       " \n",
       " [750 rows x 5 columns],\n",
       " '1986':                            Name    H   AB     BA    OPS\n",
       " 0           Jim Acker\\ackerji01    3   28  0.107  0.250\n",
       " 1         Jim Adduci*\\adducji01    1   11  0.091  0.348\n",
       " 2         Luis Aguayo\\aguaylu01   28  133  0.211  0.628\n",
       " 3       Rick Aguilera\\aguilri01    8   51  0.157  0.478\n",
       " 4    Darrel Akerfelds\\akerfda01    0    0    NaN    NaN\n",
       " ..                          ...  ...  ...    ...    ...\n",
       " 766       Matt Young*\\youngma01    0    0    NaN    NaN\n",
       " 767       Mike Young#\\youngmi01   93  369  0.252  0.713\n",
       " 768   Joel Youngblood\\youngjo02   47  184  0.255  0.723\n",
       " 769       Robin Yount\\yountro01  163  522  0.312  0.838\n",
       " 770      Paul Zuvella\\zuvelpa01    4   48  0.083  0.274\n",
       " \n",
       " [771 rows x 5 columns],\n",
       " '1987':                           Name    H   AB     BA    OPS\n",
       " 0        Shawn Abner\\abnersh01   13   47  0.277  0.817\n",
       " 1          Jim Acker\\ackerji01    3   14  0.214  0.481\n",
       " 2        Troy Afenir\\afenitr01    6   20  0.300  0.650\n",
       " 3       Juan Agosto*\\agostju01    0    1  0.000  0.000\n",
       " 4        Luis Aguayo\\aguaylu01   43  209  0.206  0.703\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 791      Mike Young#\\youngmi01   87  363  0.240  0.733\n",
       " 792  Joel Youngblood\\youngjo02   23   91  0.253  0.681\n",
       " 793      Robin Yount\\yountro01  198  635  0.312  0.862\n",
       " 794        Steve Ziem\\ziemst01    0    0    NaN    NaN\n",
       " 795     Paul Zuvella\\zuvelpa01    6   34  0.176  0.353\n",
       " \n",
       " [796 rows x 5 columns],\n",
       " '1988':                           Name    H   AB     BA    OPS\n",
       " 0        Shawn Abner\\abnersh01   15   83  0.181  0.514\n",
       " 1          Jim Acker\\ackerji01    2    5  0.400  0.900\n",
       " 2        Jim Adduci*\\adducji01   25   94  0.266  0.641\n",
       " 3       Juan Agosto*\\agostju01    0    5  0.000  0.000\n",
       " 4        Luis Aguayo\\aguaylu01   59  237  0.249  0.663\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 764    Gerald Young#\\youngge02  148  576  0.257  0.658\n",
       " 765      Mike Young#\\youngmi01   33  160  0.206  0.641\n",
       " 766  Joel Youngblood\\youngjo02   31  123  0.252  0.591\n",
       " 767      Robin Yount\\yountro01  190  621  0.306  0.834\n",
       " 768     Paul Zuvella\\zuvelpa01   30  130  0.231  0.560\n",
       " \n",
       " [769 rows x 5 columns],\n",
       " '1989':                           Name    H   AB     BA    OPS\n",
       " 0            Don Aase\\aasedo01    0    5  0.000  0.000\n",
       " 1        Shawn Abner\\abnersh01   18  102  0.176  0.487\n",
       " 2          Jim Acker\\ackerji01    1    7  0.143  0.286\n",
       " 3        Jim Adduci*\\adducji01    7   19  0.368  0.789\n",
       " 4       Juan Agosto*\\agostju01    1    5  0.200  0.400\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 792      Mike Young#\\youngmi01   11   59  0.186  0.510\n",
       " 793  Joel Youngblood\\youngjo02   25  118  0.212  0.629\n",
       " 794      Robin Yount\\yountro01  195  614  0.318  0.896\n",
       " 795       Todd Zeile\\zeileto01   21   82  0.256  0.680\n",
       " 796     Paul Zuvella\\zuvelpa01   16   58  0.276  0.714\n",
       " \n",
       " [797 rows x 5 columns],\n",
       " '1990':                         Name    H   AB     BA    OPS\n",
       " 0          Don Aase\\aasedo01    0    0    NaN    NaN\n",
       " 1      Shawn Abner\\abnersh01   45  184  0.245  0.595\n",
       " 2      Troy Afenir\\afenitr01    2   14  0.143  0.276\n",
       " 3     Juan Agosto*\\agostju01    0    2  0.000  0.000\n",
       " 4    Rick Aguilera\\aguilri01    0    0    NaN    NaN\n",
       " ..                       ...  ...  ...    ...    ...\n",
       " 804       Mike York\\yorkmi01    1    3  0.333  0.667\n",
       " 805     Curt Young\\youngcu01    0    0    NaN    NaN\n",
       " 806  Gerald Young#\\youngge02   27  154  0.175  0.502\n",
       " 807    Robin Yount\\yountro01  145  587  0.247  0.717\n",
       " 808     Todd Zeile\\zeileto01  121  495  0.244  0.731\n",
       " \n",
       " [809 rows x 5 columns],\n",
       " '1991':                         Name    H   AB     BA    OPS\n",
       " 0      Paul Abbott\\abbotpa01    0    0    NaN    NaN\n",
       " 1      Shawn Abner\\abnersh01   42  216  0.194  0.537\n",
       " 2      Troy Afenir\\afenitr01    1   11  0.091  0.182\n",
       " 3     Juan Agosto*\\agostju01    1    3  0.333  0.833\n",
       " 4    Rick Aguilera\\aguilri01    0    0    NaN    NaN\n",
       " ..                       ...  ...  ...    ...    ...\n",
       " 811    Robin Yount\\yountro01  131  503  0.260  0.707\n",
       " 812     Todd Zeile\\zeileto01  158  565  0.280  0.765\n",
       " 813    Eddie Zosky\\zoskyed01    4   27  0.148  0.407\n",
       " 814     Bob Zupcic\\zupcibo01    4   25  0.160  0.472\n",
       " 815   Paul Zuvella\\zuvelpa01    0    0    NaN    NaN\n",
       " \n",
       " [816 rows x 5 columns],\n",
       " '1992':                        Name    H   AB     BA    OPS\n",
       " 0    Kyle Abbott*\\abbotky01    2   29  0.069  0.203\n",
       " 1     Shawn Abner\\abnersh01   58  208  0.279  0.674\n",
       " 2       Jim Acker\\ackerji01    0    0    NaN    NaN\n",
       " 3     Troy Afenir\\afenitr01    6   34  0.176  0.606\n",
       " 4    Juan Agosto*\\agostju01    0    4  0.000  0.000\n",
       " ..                      ...  ...  ...    ...    ...\n",
       " 801    Pete Young\\youngpe02    0    0    NaN    NaN\n",
       " 802   Robin Yount\\yountro01  147  557  0.264  0.714\n",
       " 803    Todd Zeile\\zeileto01  113  439  0.257  0.717\n",
       " 804   Eddie Zosky\\zoskyed01    2    7  0.286  0.821\n",
       " 805    Bob Zupcic\\zupcibo01  108  392  0.276  0.674\n",
       " \n",
       " [806 rows x 5 columns],\n",
       " '1993':                          Name    H   AB     BA    OPS\n",
       " 0       Kurt Abbott\\abbotku01   15   61  0.246  0.691\n",
       " 1      Juan Agosto*\\agostju01    0    0    NaN    NaN\n",
       " 2     Rick Aguilera\\aguilri01    0    0    NaN    NaN\n",
       " 3     Scott Aldred*\\aldresc01    0    0    NaN    NaN\n",
       " 4     Mike Aldrete*\\aldremi01   68  255  0.267  0.796\n",
       " ..                        ...  ...  ...    ...    ...\n",
       " 895      Pete Young\\youngpe02    0    1  0.000  0.000\n",
       " 896     Robin Yount\\yountro01  117  454  0.258  0.705\n",
       " 897  Eddie Zambrano\\zambred01    5   17  0.294  0.627\n",
       " 898      Todd Zeile\\zeileto01  158  571  0.277  0.785\n",
       " 899      Bob Zupcic\\zupcibo01   69  286  0.241  0.668\n",
       " \n",
       " [900 rows x 5 columns],\n",
       " '1994':                           Name    H   AB     BA    OPS\n",
       " 0        Kurt Abbott\\abbotku01   86  345  0.249  0.685\n",
       " 1           Mark Acre\\acrema01    0    0    NaN    NaN\n",
       " 2      Mike Aldrete*\\aldremi01   43  178  0.242  0.651\n",
       " 3       Luis Alicea#\\alicelu01   57  205  0.278  0.832\n",
       " 4    Roberto Alomar#\\alomaro01  120  392  0.306  0.838\n",
       " ..                         ...  ...  ...    ...    ...\n",
       " 777    Gerald Young#\\youngge02   13   41  0.317  0.851\n",
       " 778      Kevin Young\\youngke01   25  122  0.205  0.577\n",
       " 779   Eddie Zambrano\\zambred01   30  116  0.259  0.828\n",
       " 780       Todd Zeile\\zeileto01  111  415  0.267  0.818\n",
       " 781       Bob Zupcic\\zupcibo01   18   92  0.196  0.520\n",
       " \n",
       " [782 rows x 5 columns],\n",
       " '1995':                        Name    H   AB     BA    OPS\n",
       " 0     Kurt Abbott\\abbotku01  107  420  0.255  0.770\n",
       " 1    Kyle Abbott*\\abbotky01    1    2  0.500  1.000\n",
       " 2    Juan Acevedo\\aceveju01    1   18  0.056  0.161\n",
       " 3        Mark Acre\\acrema01    0    0    NaN    NaN\n",
       " 4     Terry Adams\\adamste01    0    0    NaN    NaN\n",
       " ..                      ...  ...  ...    ...    ...\n",
       " 896   Ernie Young\\younger02   10   50  0.200  0.690\n",
       " 897   Kevin Young\\youngke01   42  181  0.232  0.649\n",
       " 898    Gregg Zaun#\\zaungr01   27  104  0.260  0.753\n",
       " 899    Todd Zeile\\zeileto01  105  426  0.246  0.702\n",
       " 900   Eddie Zosky\\zoskyed01    1    5  0.200  0.400\n",
       " \n",
       " [901 rows x 5 columns],\n",
       " '1996':                         Name    H   AB     BA    OPS\n",
       " 0      Kurt Abbott\\abbotku01   81  320  0.253  0.735\n",
       " 1     Bobby Abreu*\\abreubo01    5   22  0.227  0.564\n",
       " 2      Terry Adams\\adamste01    0    6  0.000  0.143\n",
       " 3    Joel Adamson*\\adamsjo02    0    0    NaN    NaN\n",
       " 4    Mike Aldrete*\\aldremi01   23  108  0.213  0.736\n",
       " ..                       ...  ...  ...    ...    ...\n",
       " 900    Ernie Young\\younger02  112  462  0.242  0.750\n",
       " 901    Kevin Young\\youngke01   32  132  0.242  0.770\n",
       " 902     Gregg Zaun#\\zaungr01   34  139  0.245  0.685\n",
       " 903     Todd Zeile\\zeileto01  162  617  0.263  0.784\n",
       " 904     Jon Zuber*\\zuberjo01   23   91  0.253  0.626\n",
       " \n",
       " [905 rows x 5 columns],\n",
       " '1997':                           Name    H   AB     BA    OPS\n",
       " 0        Jeff Abbott\\abbotje01   10   38  0.263  0.632\n",
       " 1        Kurt Abbott\\abbotku01   69  252  0.274  0.747\n",
       " 2       Bobby Abreu*\\abreubo01   47  188  0.250  0.701\n",
       " 3       Juan Acevedo\\aceveju01    0    6  0.000  0.000\n",
       " 4        Terry Adams\\adamste01    0    2  0.000  0.000\n",
       " ...                        ...  ...  ...    ...    ...\n",
       " 1046  Eric Young Sr.\\younger01  174  622  0.280  0.756\n",
       " 1047     Ernie Young\\younger02   39  175  0.223  0.652\n",
       " 1048     Kevin Young\\youngke01  100  333  0.300  0.867\n",
       " 1049      Gregg Zaun#\\zaungr01   43  143  0.301  0.856\n",
       " 1050      Todd Zeile\\zeileto01  154  575  0.268  0.824\n",
       " \n",
       " [1051 rows x 5 columns],\n",
       " '1998':                         Name    H   AB     BA    OPS\n",
       " 0      Jeff Abbott\\abbotje01   68  244  0.279  0.790\n",
       " 1      Kurt Abbott\\abbotku01   51  194  0.263  0.726\n",
       " 2     Bobby Abreu*\\abreubo01  155  497  0.312  0.906\n",
       " 3     Juan Acevedo\\aceveju01    3   17  0.176  0.458\n",
       " 4      Terry Adams\\adamste01    0    1  0.000  0.000\n",
       " ...                      ...  ...  ...    ...    ...\n",
       " 1092   Kevin Young\\youngke01  160  592  0.270  0.809\n",
       " 1093    Tim Young*\\youngti01    0    0    NaN    NaN\n",
       " 1094    Gregg Zaun#\\zaungr01   56  298  0.188  0.566\n",
       " 1095    Todd Zeile\\zeileto01  155  572  0.271  0.787\n",
       " 1096    Jon Zuber*\\zuberjo01   11   45  0.244  0.835\n",
       " \n",
       " [1097 rows x 5 columns],\n",
       " '1999':                             Name    H   AB     BA    OPS\n",
       " 0          Jeff Abbott\\abbotje01    9   57  0.158  0.485\n",
       " 1          Jim Abbott*\\abbotji01    2   21  0.095  0.190\n",
       " 2          Kurt Abbott\\abbotku01   78  286  0.273  0.740\n",
       " 3          Paul Abbott\\abbotpa01    0    0    NaN    NaN\n",
       " 4         Bobby Abreu*\\abreubo01  183  546  0.335  0.995\n",
       " ...                          ...  ...  ...    ...    ...\n",
       " 1111        Gregg Zaun#\\zaungr01   23   93  0.247  0.637\n",
       " 1112        Todd Zeile\\zeileto01  172  588  0.293  0.842\n",
       " 1113    Jeff Zimmerman\\zimmeje02    0    0    NaN    NaN\n",
       " 1114  Jordan Zimmerman\\zimmejo01    0    0    NaN    NaN\n",
       " 1115       Eddie Zosky\\zoskyed01    1    7  0.143  0.393\n",
       " \n",
       " [1116 rows x 5 columns],\n",
       " '2000':                           Name    H   AB     BA    OPS\n",
       " 0        Jeff Abbott\\abbotje01   59  215  0.274  0.738\n",
       " 1        Kurt Abbott\\abbotku01   34  157  0.217  0.672\n",
       " 2        Paul Abbott\\abbotpa01    2    5  0.400  1.000\n",
       " 3       Bobby Abreu*\\abreubo01  182  576  0.316  0.970\n",
       " 4       Juan Acevedo\\aceveju01    0    1  0.000  0.500\n",
       " ...                        ...  ...  ...    ...    ...\n",
       " 1127      Todd Zeile\\zeileto01  146  544  0.268  0.823\n",
       " 1128     Chad Zerbe*\\zerbech01    0    0    NaN    NaN\n",
       " 1129  Jeff Zimmerman\\zimmeje02    0    0    NaN    NaN\n",
       " 1130     Eddie Zosky\\zoskyed01    0    4  0.000  0.000\n",
       " 1131    Julio Zuleta\\zuletju01   20   68  0.294  0.887\n",
       " \n",
       " [1132 rows x 5 columns],\n",
       " '2001':                            Name    H   AB     BA    OPS\n",
       " 0           Andy Abad*\\abadan01    0    1  0.000  0.000\n",
       " 1         Jeff Abbott\\abbotje01   11   42  0.262  0.659\n",
       " 2         Kurt Abbott\\abbotku01    2    9  0.222  0.444\n",
       " 3         Paul Abbott\\abbotpa01    1    4  0.250  0.500\n",
       " 4     Brent Abernathy\\abernbr01   82  304  0.270  0.710\n",
       " ...                         ...  ...  ...    ...    ...\n",
       " 1132       Todd Zeile\\zeileto01  141  531  0.266  0.732\n",
       " 1133      Chad Zerbe*\\zerbech01    2    9  0.222  0.444\n",
       " 1134   Jeff Zimmerman\\zimmeje02    0    0    NaN    NaN\n",
       " 1135       Barry Zito*\\zitoba01    0    5  0.000  0.000\n",
       " 1136     Julio Zuleta\\zuletju01   23  106  0.217  0.703\n",
       " \n",
       " [1137 rows x 5 columns],\n",
       " '2002':                            Name    H   AB     BA    OPS\n",
       " 0     Brent Abernathy\\abernbr01  112  463  0.242  0.599\n",
       " 1        Bobby Abreu*\\abreubo01  176  572  0.308  0.934\n",
       " 2        Jose Acevedo\\acevejo01    1    7  0.143  0.536\n",
       " 3        Juan Acevedo\\aceveju01    0    0    NaN    NaN\n",
       " 4         Terry Adams\\adamste01    2   25  0.080  0.259\n",
       " ...                         ...  ...  ...    ...    ...\n",
       " 1096       Gregg Zaun#\\zaungr01   41  185  0.222  0.594\n",
       " 1097       Todd Zeile\\zeileto01  138  506  0.273  0.778\n",
       " 1098      Chad Zerbe*\\zerbech01    1    6  0.167  0.333\n",
       " 1099     Alan Zinter#\\zinteal01    6   44  0.136  0.455\n",
       " 1100       Barry Zito*\\zitoba01    0    4  0.000  0.000\n",
       " \n",
       " [1101 rows x 5 columns],\n",
       " '2003':                              Name    H   AB     BA    OPS\n",
       " 0             Andy Abad*\\abadan01    2   17  0.118  0.328\n",
       " 1       Brent Abernathy\\abernbr01    2   34  0.059  0.145\n",
       " 2          Bobby Abreu*\\abreubo01  173  577  0.300  0.877\n",
       " 3          Jose Acevedo\\acevejo01    0    9  0.000  0.000\n",
       " 4          Juan Acevedo\\aceveju01    0    0    NaN    NaN\n",
       " ...                           ...  ...  ...    ...    ...\n",
       " 1129         Gregg Zaun#\\zaungr01   38  166  0.229  0.658\n",
       " 1130         Todd Zeile\\zeileto01   68  299  0.227  0.693\n",
       " 1131        Chad Zerbe*\\zerbech01    0    5  0.000  0.000\n",
       " 1132         Barry Zito*\\zitoba01    0    6  0.000  0.000\n",
       " 1133  Peter Zoccolillo*\\zoccope01    4   37  0.108  0.289\n",
       " \n",
       " [1134 rows x 5 columns],\n",
       " '2004':                             Name    H   AB     BA    OPS\n",
       " 0        David Aardsma\\aardsda01    0    0    NaN    NaN\n",
       " 1          Paul Abbott\\abbotpa01    2   11  0.182  0.364\n",
       " 2         Bobby Abreu*\\abreubo01  173  574  0.301  0.971\n",
       " 3         Jose Acevedo\\acevejo01    2   43  0.047  0.153\n",
       " 4           Mike Adams\\adamsmi03    0    0    NaN    NaN\n",
       " ...                          ...  ...  ...    ...    ...\n",
       " 1131  Victor Zambrano#\\zambrvi01    2   11  0.182  0.455\n",
       " 1132        Gregg Zaun#\\zaungr01   91  338  0.269  0.761\n",
       " 1133        Todd Zeile\\zeileto01   81  348  0.233  0.675\n",
       " 1134      Alan Zinter#\\zinteal01    7   34  0.206  0.653\n",
       " 1135        Barry Zito*\\zitoba01    0    4  0.000  0.000\n",
       " \n",
       " [1136 rows x 5 columns],\n",
       " '2005':                             Name    H   AB     BA    OPS\n",
       " 0      Brent Abernathy\\abernbr01   16   67  0.239  0.614\n",
       " 1         Bobby Abreu*\\abreubo01  168  588  0.286  0.879\n",
       " 2       Jeremy Accardo\\accarje01    1    2  0.500  1.000\n",
       " 3         Jose Acevedo\\acevejo01    1    8  0.125  0.425\n",
       " 4           Mike Adams\\adamsmi03    0    0    NaN    NaN\n",
       " ...                          ...  ...  ...    ...    ...\n",
       " 1136  Carlos Zambrano#\\zambrca01   24   80  0.300  0.763\n",
       " 1137  Victor Zambrano#\\zambrvi01    7   53  0.132  0.302\n",
       " 1138        Gregg Zaun#\\zaungr01  109  434  0.251  0.729\n",
       " 1139    Ryan Zimmerman\\zimmery01   23   58  0.397  0.988\n",
       " 1140        Barry Zito*\\zitoba01    1    7  0.143  0.286\n",
       " \n",
       " [1141 rows x 5 columns],\n",
       " '2006':                               Name    H   AB     BA    OPS\n",
       " 0          David Aardsma\\aardsda01    0    2  0.000  0.000\n",
       " 1              Andy Abad*\\abadan01    0    3  0.000  0.400\n",
       " 2     Reggie Abercrombie\\abercre01   54  255  0.212  0.604\n",
       " 3           Bobby Abreu*\\abreubo01  163  548  0.297  0.886\n",
       " 4         Jeremy Accardo\\accarje01    0    5  0.000  0.000\n",
       " ...                            ...  ...  ...    ...    ...\n",
       " 1129          Gregg Zaun#\\zaungr01   79  290  0.272  0.825\n",
       " 1130      Ryan Zimmerman\\zimmery01  176  614  0.287  0.822\n",
       " 1131          Barry Zito*\\zitoba01    0    3  0.000  0.000\n",
       " 1132        Ben Zobrist#\\zobribe01   41  183  0.224  0.572\n",
       " 1133         Joel Zumaya\\zumayjo01    0    0    NaN    NaN\n",
       " \n",
       " [1134 rows x 5 columns],\n",
       " '2007':                               Name    H   AB     BA    OPS\n",
       " 0          David Aardsma\\aardsda01    0    0    NaN    NaN\n",
       " 1     Reggie Abercrombie\\abercre01   15   76  0.197  0.553\n",
       " 2           Bobby Abreu*\\abreubo01  171  605  0.283  0.814\n",
       " 3            Tony Abreu#\\abreuto01   45  166  0.271  0.713\n",
       " 4          Winston Abreu\\abreuwi01    0    2  0.000  0.000\n",
       " ...                            ...  ...  ...    ...    ...\n",
       " 1168        Mauro Zarate\\zaratma01    0    0    NaN    NaN\n",
       " 1169          Gregg Zaun#\\zaungr01   80  331  0.242  0.752\n",
       " 1170      Ryan Zimmerman\\zimmery01  174  653  0.266  0.788\n",
       " 1171          Barry Zito*\\zitoba01    7   62  0.113  0.254\n",
       " 1172        Ben Zobrist#\\zobribe01   15   97  0.155  0.391\n",
       " \n",
       " [1173 rows x 5 columns],\n",
       " '2008':                               Name    H   AB     BA    OPS\n",
       " 0          David Aardsma\\aardsda01    0    1  0.000  0.000\n",
       " 1     Reggie Abercrombie\\abercre01   17   55  0.309  0.848\n",
       " 2           Bobby Abreu*\\abreubo01  180  609  0.296  0.843\n",
       " 3           Manny Acosta\\acostma01    0    5  0.000  0.000\n",
       " 4             Mike Adams\\adamsmi03    0    2  0.000  0.000\n",
       " ...                            ...  ...  ...    ...    ...\n",
       " 1183        Brad Ziegler\\zieglbr01    0    0    NaN    NaN\n",
       " 1184      Ryan Zimmerman\\zimmery01  121  428  0.283  0.774\n",
       " 1185          Barry Zito*\\zitoba01    6   51  0.118  0.299\n",
       " 1186        Ben Zobrist#\\zobribe01   50  198  0.253  0.844\n",
       " 1187         Joel Zumaya\\zumayjo01    0    0    NaN    NaN\n",
       " \n",
       " [1188 rows x 5 columns],\n",
       " '2009':                              Name    H   AB     BA    OPS\n",
       " 0         David Aardsma\\aardsda01    0    0    NaN    NaN\n",
       " 1          Bobby Abreu*\\abreubo01  165  563  0.293  0.825\n",
       " 2           Tony Abreu#\\abreuto01    2    8  0.250  0.705\n",
       " 3         Winston Abreu\\abreuwi01    0    0    NaN    NaN\n",
       " 4        Jeremy Accardo\\accarje01    0    0    NaN    NaN\n",
       " ...                           ...  ...  ...    ...    ...\n",
       " 1151     Ryan Zimmerman\\zimmery01  178  610  0.292  0.888\n",
       " 1152  Jordan Zimmermann\\zimmejo02    4   27  0.148  0.327\n",
       " 1153         Barry Zito*\\zitoba01    6   51  0.118  0.299\n",
       " 1154       Ben Zobrist#\\zobribe01  149  501  0.297  0.948\n",
       " 1155        Joel Zumaya\\zumayjo01    0    0    NaN    NaN\n",
       " \n",
       " [1156 rows x 5 columns],\n",
       " '2010':                              Name    H   AB     BA    OPS\n",
       " 0         David Aardsma\\aardsda01    0    0    NaN    NaN\n",
       " 1         Fernando Abad*\\abadfe01    0    1  0.000  0.000\n",
       " 2          Bobby Abreu*\\abreubo01  146  573  0.255  0.787\n",
       " 3           Tony Abreu#\\abreuto01   45  193  0.233  0.560\n",
       " 4        Alfredo Aceves\\aceveal01    0    0    NaN    NaN\n",
       " ...                           ...  ...  ...    ...    ...\n",
       " 1152     Ryan Zimmerman\\zimmery01  161  525  0.307  0.899\n",
       " 1153  Jordan Zimmermann\\zimmejo02    2   10  0.200  0.400\n",
       " 1154         Barry Zito*\\zitoba01    6   51  0.118  0.252\n",
       " 1155       Ben Zobrist#\\zobribe01  129  541  0.238  0.699\n",
       " 1156        Joel Zumaya\\zumayjo01    0    0    NaN    NaN\n",
       " \n",
       " [1157 rows x 5 columns],\n",
       " '2011':                              Name    H   AB     BA    OPS\n",
       " 0         Fernando Abad*\\abadfe01    0    0    NaN    NaN\n",
       " 1          Bobby Abreu*\\abreubo01  127  502  0.253  0.717\n",
       " 2            Juan Abreu\\abreuju01    0    0    NaN    NaN\n",
       " 3        Jeremy Accardo\\accarje01    0    0    NaN    NaN\n",
       " 4        Alfredo Aceves\\aceveal01    0    0    NaN    NaN\n",
       " ...                           ...  ...  ...    ...    ...\n",
       " 1168       Brad Ziegler\\zieglbr01    0    0    NaN    NaN\n",
       " 1169     Ryan Zimmerman\\zimmery01  114  395  0.289  0.798\n",
       " 1170  Jordan Zimmermann\\zimmejo02    9   43  0.209  0.477\n",
       " 1171         Barry Zito*\\zitoba01    0   13  0.000  0.071\n",
       " 1172       Ben Zobrist#\\zobribe01  158  588  0.269  0.822\n",
       " \n",
       " [1173 rows x 5 columns],\n",
       " '2012':                              Name    H   AB     BA    OPS\n",
       " 0         Fernando Abad*\\abadfe01    1    7  0.143  0.286\n",
       " 1          Bobby Abreu*\\abreubo01   53  219  0.242  0.693\n",
       " 2           Tony Abreu#\\abreuto01   18   70  0.257  0.641\n",
       " 3        Jeremy Accardo\\accarje01    0    0    NaN    NaN\n",
       " 4        Alfredo Aceves\\aceveal01    0    0    NaN    NaN\n",
       " ...                           ...  ...  ...    ...    ...\n",
       " 1180       Brad Ziegler\\zieglbr01    1    4  0.250  0.500\n",
       " 1181     Ryan Zimmerman\\zimmery01  163  578  0.282  0.824\n",
       " 1182  Jordan Zimmermann\\zimmejo02   11   57  0.193  0.527\n",
       " 1183         Barry Zito*\\zitoba01    4   53  0.075  0.245\n",
       " 1184       Ben Zobrist#\\zobribe01  151  560  0.270  0.848\n",
       " \n",
       " [1185 rows x 5 columns],\n",
       " '2013':                              Name    H   AB     BA    OPS\n",
       " 0         David Aardsma\\aardsda01    0    0    NaN    NaN\n",
       " 1         Fernando Abad*\\abadfe01    0    0    NaN    NaN\n",
       " 2           Tony Abreu#\\abreuto01   37  138  0.268  0.743\n",
       " 3        Dustin Ackley*\\ackledu01   97  384  0.253  0.660\n",
       " 4           David Adams\\adamsda02   27  140  0.193  0.537\n",
       " ...                           ...  ...  ...    ...    ...\n",
       " 1197     Ryan Zimmerman\\zimmery01  156  568  0.275  0.809\n",
       " 1198  Jordan Zimmermann\\zimmejo02    8   65  0.123  0.273\n",
       " 1199         Barry Zito*\\zitoba01    5   34  0.147  0.294\n",
       " 1200       Ben Zobrist#\\zobribe01  168  612  0.275  0.756\n",
       " 1201        Mike Zunino\\zuninmi01   37  173  0.214  0.620\n",
       " \n",
       " [1202 rows x 5 columns],\n",
       " '2014':                              Name    H   AB     BA    OPS\n",
       " 0         Fernando Abad*\\abadfe01    0    0    NaN    NaN\n",
       " 1          Bobby Abreu*\\abreubo01   33  133  0.248  0.680\n",
       " 2            Jose Abreu\\abreujo02  176  556  0.317  0.964\n",
       " 3           Tony Abreu#\\abreuto01    0    4  0.000  0.000\n",
       " 4        Alfredo Aceves\\aceveal01    0    0    NaN    NaN\n",
       " ...                           ...  ...  ...    ...    ...\n",
       " 1207       Brad Ziegler\\zieglbr01    0    1  0.000  0.000\n",
       " 1208     Ryan Zimmerman\\zimmery01   60  214  0.280  0.790\n",
       " 1209  Jordan Zimmermann\\zimmejo02   10   55  0.182  0.407\n",
       " 1210       Ben Zobrist#\\zobribe01  155  570  0.272  0.749\n",
       " 1211        Mike Zunino\\zuninmi01   87  438  0.199  0.658\n",
       " \n",
       " [1212 rows x 5 columns],\n",
       " '2015':                              Name    H   AB     BA    OPS\n",
       " 0         David Aardsma\\aardsda01    0    1  0.000  0.000\n",
       " 1         Fernando Abad*\\abadfe01    0    0    NaN    NaN\n",
       " 2            Jose Abreu\\abreujo02  178  613  0.290  0.850\n",
       " 3           A.J. Achter\\achteaj01    0    0    NaN    NaN\n",
       " 4        Dustin Ackley*\\ackledu01   55  238  0.231  0.712\n",
       " ...                           ...  ...  ...    ...    ...\n",
       " 1247       Brad Ziegler\\zieglbr01    0    0    NaN    NaN\n",
       " 1248     Ryan Zimmerman\\zimmery01   86  346  0.249  0.773\n",
       " 1249  Jordan Zimmermann\\zimmejo02   10   63  0.159  0.333\n",
       " 1250       Ben Zobrist#\\zobribe01  129  467  0.276  0.809\n",
       " 1251        Mike Zunino\\zuninmi01   61  350  0.174  0.530\n",
       " \n",
       " [1252 rows x 5 columns],\n",
       " '2016':                              Name    H   AB     BA    OPS\n",
       " 0         Fernando Abad*\\abadfe01    0    1  0.000  0.000\n",
       " 1            Jose Abreu\\abreujo02  183  624  0.293  0.820\n",
       " 2           A.J. Achter\\achteaj01    0    0    NaN    NaN\n",
       " 3        Dustin Ackley*\\ackledu01    9   61  0.148  0.390\n",
       " 4     Cristhian Adames#\\adamecr01   49  225  0.218  0.607\n",
       " ...                           ...  ...  ...    ...    ...\n",
       " 1242       Brad Ziegler\\zieglbr01    0    0    NaN    NaN\n",
       " 1243     Ryan Zimmerman\\zimmery01   93  427  0.218  0.642\n",
       " 1244  Jordan Zimmermann\\zimmejo02    1    4  0.250  0.500\n",
       " 1245       Ben Zobrist#\\zobribe01  142  523  0.272  0.831\n",
       " 1246        Mike Zunino\\zuninmi01   34  164  0.207  0.787\n",
       " \n",
       " [1247 rows x 5 columns]}"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "seasons = {}\n",
    "for year in range(1980, 2017):\n",
    "    sheet = str(year)\n",
    "    df = pd.read_excel(\"MLB_batting_data_1980_2018_19_10_02.xlsx\", sheet_name=sheet)\n",
    "    seasons[sheet] = df[['Name', 'H', 'AB', 'BA', 'OPS']]\n",
    "seasons"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:8: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n"
     ]
    }
   ],
   "source": [
    "differences = {}\n",
    "\n",
    "for year in range(1980, 2016):\n",
    "    s_first = seasons[str(year)]\n",
    "    s_first['Name'] = s_first['Name'].apply(lambda x: x.strip(\"*\").strip(\"#\").split('\\\\')[0])\n",
    "    s_first = s_first.set_index('Name')\n",
    "    s_second = seasons[str(year + 1)]\n",
    "    s_second['Name'] = s_second['Name'].apply(lambda x: x.strip(\"*\").strip(\"#\").split('\\\\')[0])\n",
    "    s_second = s_second.set_index('Name')\n",
    "    intersection = list(set(s_first.index).intersection(set(s_second.index)))\n",
    "    s_first = s_first[(s_first['H'].notna()) & (s_first['AB'].notna())]\n",
    "    s_second = s_second[(s_second['H'].notna()) & (s_second['AB'].notna())]\n",
    "    \n",
    "    first_batting_hits = 0.0\n",
    "    first_batting_abs = 0.0\n",
    "    second_batting_hits = 0.0\n",
    "    second_batting_abs = 0.0\n",
    "    \n",
    "    total_counted = 0\n",
    "    for player in intersection:\n",
    "        try:\n",
    "            if type(s_first.at[player, 'H']) != np.int64 or type(s_second.at[player, 'H']) != np.int64 or type(s_first.at[player, 'AB']) != np.int64 or type(s_second.at[player, 'AB']) != np.int64:\n",
    "                continue\n",
    "        except:\n",
    "            continue\n",
    "        try:\n",
    "            first_batting_hits = first_batting_hits + s_first.at[player, 'H']\n",
    "            second_batting_hits = second_batting_hits + s_second.at[player, 'H']\n",
    "            first_batting_abs = first_batting_abs + s_first.at[player, 'AB']\n",
    "            second_batting_abs = second_batting_abs + s_second.at[player, 'AB']\n",
    "            total_counted += 1\n",
    "        except:\n",
    "            continue\n",
    "               \n",
    "    differences[str(year +1) + \"-\" + str(year)] = (second_batting_hits)/(second_batting_abs) - (first_batting_hits)/(first_batting_abs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1981-1980': -0.010343969624803717,\n",
       " '1982-1981': 0.004150956057552113,\n",
       " '1983-1982': -0.0026551634580648797,\n",
       " '1984-1983': -0.001618418289512924,\n",
       " '1985-1984': -0.00665458427979565,\n",
       " '1986-1985': 0.0013325133866162742,\n",
       " '1987-1986': 0.004039859348524966,\n",
       " '1988-1987': -0.01012827273683109,\n",
       " '1989-1988': -0.0006663367351106841,\n",
       " '1990-1989': 0.0003846961808752769,\n",
       " '1991-1990': -0.004622610882827061,\n",
       " '1992-1991': -0.00020893961677104222,\n",
       " '1993-1992': 0.009868101455288714,\n",
       " '1994-1993': 0.0011583596703642618,\n",
       " '1995-1994': -0.001628549056930273,\n",
       " '1996-1995': 0.002960826146023665,\n",
       " '1997-1996': -0.006517449742279746,\n",
       " '1998-1997': 0.0014838779315956563,\n",
       " '1999-1998': 0.005303016457582466,\n",
       " '2000-1999': -0.0005072385598036133,\n",
       " '2001-2000': -0.011216721466846158,\n",
       " '2002-2001': -0.00392777272860062,\n",
       " '2003-2002': 0.00343227366858323,\n",
       " '2004-2003': 0.0011022510457968648,\n",
       " '2005-2004': -0.004275256622041257,\n",
       " '2006-2005': 0.0033471999785917306,\n",
       " '2007-2006': -0.0023822644524887915,\n",
       " '2008-2007': -0.0079809403362322,\n",
       " '2009-2008': -0.001479340337823487,\n",
       " '2010-2009': -0.004389772493878508,\n",
       " '2011-2010': -0.006147963780138155,\n",
       " '2012-2011': 0.0009747452844537929,\n",
       " '2013-2012': -0.004753977715827473,\n",
       " '2014-2013': -0.0031546977098068085,\n",
       " '2015-2014': -0.002021261177357403,\n",
       " '2016-2015': 0.0025513525335670306}"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "differences"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "years = ['2000-1999', '2001-2000', '2002-2001', '2003-2002', '2004-2003', '2005-2004', '2006-2005', '2007-2006',\n",
    "        '2008-2007', '2009-2008', '2010-2009', '2011-2010',]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "-0.06502562021039757"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "diff = 0\n",
    "for year in years:\n",
    "    diff += differences[year]\n",
    "diff"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "-0.0551914726583555"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(differences.values())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.3348085273416445"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "0.390 + sum(differences.values())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}