python/table-with-schema.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false,
    "inputHidden": false,
    "outputHidden": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd.options.display.html.table_schema = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false,
    "inputHidden": false,
    "outputHidden": false
   },
   "outputs": [],
   "source": [
    "baseball_file = \"https://raw.githubusercontent.com/pandas-dev/pandas/master/doc/data/baseball.csv\"\n",
    "df = pd.read_csv(baseball_file).set_index(['id', 'player'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false,
    "inputHidden": false,
    "outputHidden": false
   },
   "outputs": [
    {
     "data": {
      "application/vnd.dataresource+json": {
       "data": [
        {
         "X2b": 1,
         "X3b": 0,
         "ab": 50,
         "bb": 4,
         "cs": 1,
         "g": 19,
         "gidp": 0,
         "h": 14,
         "hbp": 0,
         "hr": 1,
         "ibb": 0,
         "id": 88641,
         "lg": "NL",
         "player": "womacto01",
         "r": 6,
         "rbi": 2,
         "sb": 1,
         "sf": 0,
         "sh": 3,
         "so": 4,
         "stint": 2,
         "team": "CHN",
         "year": 2006
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 2,
         "bb": 0,
         "cs": 0,
         "g": 31,
         "gidp": 0,
         "h": 1,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 88643,
         "lg": "AL",
         "player": "schilcu01",
         "r": 0,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 1,
         "stint": 1,
         "team": "BOS",
         "year": 2006
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 0,
         "bb": 0,
         "cs": 0,
         "g": 62,
         "gidp": 0,
         "h": 0,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 88645,
         "lg": "AL",
         "player": "myersmi01",
         "r": 0,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 0,
         "stint": 1,
         "team": "NYA",
         "year": 2006
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 3,
         "bb": 0,
         "cs": 0,
         "g": 20,
         "gidp": 0,
         "h": 0,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 88649,
         "lg": "NL",
         "player": "helliri01",
         "r": 0,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 2,
         "stint": 1,
         "team": "MIL",
         "year": 2006
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 6,
         "bb": 0,
         "cs": 0,
         "g": 33,
         "gidp": 0,
         "h": 1,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 88650,
         "lg": "AL",
         "player": "johnsra05",
         "r": 0,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 4,
         "stint": 1,
         "team": "NYA",
         "year": 2006
        },
        {
         "X2b": 21,
         "X3b": 12,
         "ab": 426,
         "bb": 46,
         "cs": 0,
         "g": 139,
         "gidp": 6,
         "h": 105,
         "hbp": 2,
         "hr": 6,
         "ibb": 2,
         "id": 88652,
         "lg": "NL",
         "player": "finlest01",
         "r": 66,
         "rbi": 40,
         "sb": 7,
         "sf": 4,
         "sh": 3,
         "so": 55,
         "stint": 1,
         "team": "SFN",
         "year": 2006
        },
        {
         "X2b": 52,
         "X3b": 2,
         "ab": 586,
         "bb": 69,
         "cs": 1,
         "g": 153,
         "gidp": 14,
         "h": 159,
         "hbp": 7,
         "hr": 15,
         "ibb": 10,
         "id": 88653,
         "lg": "NL",
         "player": "gonzalu01",
         "r": 93,
         "rbi": 73,
         "sb": 0,
         "sf": 6,
         "sh": 0,
         "so": 58,
         "stint": 1,
         "team": "ARI",
         "year": 2006
        },
        {
         "X2b": 1,
         "X3b": 0,
         "ab": 26,
         "bb": 1,
         "cs": 0,
         "g": 28,
         "gidp": 1,
         "h": 5,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 88662,
         "lg": "NL",
         "player": "seleaa01",
         "r": 2,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 6,
         "so": 7,
         "stint": 1,
         "team": "LAN",
         "year": 2006
        },
        {
         "X2b": 3,
         "X3b": 0,
         "ab": 40,
         "bb": 4,
         "cs": 0,
         "g": 15,
         "gidp": 1,
         "h": 10,
         "hbp": 0,
         "hr": 0,
         "ibb": 1,
         "id": 89177,
         "lg": "NL",
         "player": "francju01",
         "r": 1,
         "rbi": 8,
         "sb": 0,
         "sf": 1,
         "sh": 0,
         "so": 10,
         "stint": 2,
         "team": "ATL",
         "year": 2007
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 50,
         "bb": 10,
         "cs": 1,
         "g": 40,
         "gidp": 1,
         "h": 10,
         "hbp": 0,
         "hr": 1,
         "ibb": 0,
         "id": 89178,
         "lg": "NL",
         "player": "francju01",
         "r": 7,
         "rbi": 8,
         "sb": 2,
         "sf": 1,
         "sh": 0,
         "so": 13,
         "stint": 1,
         "team": "NYN",
         "year": 2007
        },
        {
         "X2b": 24,
         "X3b": 1,
         "ab": 331,
         "bb": 51,
         "cs": 0,
         "g": 110,
         "gidp": 9,
         "h": 80,
         "hbp": 2,
         "hr": 10,
         "ibb": 8,
         "id": 89330,
         "lg": "AL",
         "player": "zaungr01",
         "r": 43,
         "rbi": 52,
         "sb": 0,
         "sf": 6,
         "sh": 1,
         "so": 55,
         "stint": 1,
         "team": "TOR",
         "year": 2007
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 0,
         "bb": 0,
         "cs": 0,
         "g": 3,
         "gidp": 0,
         "h": 0,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 89333,
         "lg": "AL",
         "player": "witasja01",
         "r": 0,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 0,
         "stint": 1,
         "team": "TBA",
         "year": 2007
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 59,
         "bb": 0,
         "cs": 0,
         "g": 33,
         "gidp": 1,
         "h": 6,
         "hbp": 0,
         "hr": 1,
         "ibb": 0,
         "id": 89334,
         "lg": "NL",
         "player": "williwo02",
         "r": 3,
         "rbi": 2,
         "sb": 0,
         "sf": 0,
         "sh": 5,
         "so": 25,
         "stint": 1,
         "team": "HOU",
         "year": 2007
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 0,
         "bb": 0,
         "cs": 0,
         "g": 8,
         "gidp": 0,
         "h": 0,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 89335,
         "lg": "NL",
         "player": "wickmbo01",
         "r": 0,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 0,
         "stint": 2,
         "team": "ARI",
         "year": 2007
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 0,
         "bb": 0,
         "cs": 0,
         "g": 47,
         "gidp": 0,
         "h": 0,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 89336,
         "lg": "NL",
         "player": "wickmbo01",
         "r": 0,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 0,
         "stint": 1,
         "team": "ATL",
         "year": 2007
        },
        {
         "X2b": 4,
         "X3b": 0,
         "ab": 109,
         "bb": 6,
         "cs": 0,
         "g": 38,
         "gidp": 2,
         "h": 19,
         "hbp": 3,
         "hr": 4,
         "ibb": 0,
         "id": 89337,
         "lg": "AL",
         "player": "whitero02",
         "r": 8,
         "rbi": 20,
         "sb": 0,
         "sf": 1,
         "sh": 0,
         "so": 19,
         "stint": 1,
         "team": "MIN",
         "year": 2007
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 1,
         "bb": 0,
         "cs": 0,
         "g": 20,
         "gidp": 0,
         "h": 0,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 89338,
         "lg": "NL",
         "player": "whiteri01",
         "r": 0,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 1,
         "stint": 1,
         "team": "HOU",
         "year": 2007
        },
        {
         "X2b": 1,
         "X3b": 0,
         "ab": 15,
         "bb": 0,
         "cs": 0,
         "g": 7,
         "gidp": 0,
         "h": 4,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 89339,
         "lg": "NL",
         "player": "wellsda01",
         "r": 2,
         "rbi": 1,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 6,
         "stint": 2,
         "team": "LAN",
         "year": 2007
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 38,
         "bb": 0,
         "cs": 0,
         "g": 22,
         "gidp": 0,
         "h": 4,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 89340,
         "lg": "NL",
         "player": "wellsda01",
         "r": 1,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 4,
         "so": 12,
         "stint": 1,
         "team": "SDN",
         "year": 2007
        },
        {
         "X2b": 0,
         "X3b": 0,
         "ab": 0,
         "bb": 0,
         "cs": 0,
         "g": 67,
         "gidp": 0,
         "h": 0,
         "hbp": 0,
         "hr": 0,
         "ibb": 0,
         "id": 89341,
         "lg": "NL",
         "player": "weathda01",
         "r": 0,
         "rbi": 0,
         "sb": 0,
         "sf": 0,
         "sh": 0,
         "so": 0,
         "stint": 1,
         "team": "CIN",
         "year": 2007
        }
       ],
       "schema": {
        "fields": [
         {
          "name": "id",
          "type": "integer"
         },
         {
          "name": "player",
          "type": "string"
         },
         {
          "name": "year",
          "type": "integer"
         },
         {
          "name": "stint",
          "type": "integer"
         },
         {
          "name": "team",
          "type": "string"
         },
         {
          "name": "lg",
          "type": "string"
         },
         {
          "name": "g",
          "type": "integer"
         },
         {
          "name": "ab",
          "type": "integer"
         },
         {
          "name": "r",
          "type": "integer"
         },
         {
          "name": "h",
          "type": "integer"
         },
         {
          "name": "X2b",
          "type": "integer"
         },
         {
          "name": "X3b",
          "type": "integer"
         },
         {
          "name": "hr",
          "type": "integer"
         },
         {
          "name": "rbi",
          "type": "number"
         },
         {
          "name": "sb",
          "type": "number"
         },
         {
          "name": "cs",
          "type": "number"
         },
         {
          "name": "bb",
          "type": "integer"
         },
         {
          "name": "so",
          "type": "number"
         },
         {
          "name": "ibb",
          "type": "number"
         },
         {
          "name": "hbp",
          "type": "number"
         },
         {
          "name": "sh",
          "type": "number"
         },
         {
          "name": "sf",
          "type": "number"
         },
         {
          "name": "gidp",
          "type": "number"
         }
        ],
        "pandas_version": "0.20.0",
        "primaryKey": [
         "id",
         "player"
        ]
       }
      },
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>stint</th>\n",
       "      <th>team</th>\n",
       "      <th>lg</th>\n",
       "      <th>g</th>\n",
       "      <th>ab</th>\n",
       "      <th>r</th>\n",
       "      <th>h</th>\n",
       "      <th>X2b</th>\n",
       "      <th>X3b</th>\n",
       "      <th>...</th>\n",
       "      <th>rbi</th>\n",
       "      <th>sb</th>\n",
       "      <th>cs</th>\n",
       "      <th>bb</th>\n",
       "      <th>so</th>\n",
       "      <th>ibb</th>\n",
       "      <th>hbp</th>\n",
       "      <th>sh</th>\n",
       "      <th>sf</th>\n",
       "      <th>gidp</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th>player</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>88641</th>\n",
       "      <th>womacto01</th>\n",
       "      <td>2006</td>\n",
       "      <td>2</td>\n",
       "      <td>CHN</td>\n",
       "      <td>NL</td>\n",
       "      <td>19</td>\n",
       "      <td>50</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88643</th>\n",
       "      <th>schilcu01</th>\n",
       "      <td>2006</td>\n",
       "      <td>1</td>\n",
       "      <td>BOS</td>\n",
       "      <td>AL</td>\n",
       "      <td>31</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88645</th>\n",
       "      <th>myersmi01</th>\n",
       "      <td>2006</td>\n",
       "      <td>1</td>\n",
       "      <td>NYA</td>\n",
       "      <td>AL</td>\n",
       "      <td>62</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88649</th>\n",
       "      <th>helliri01</th>\n",
       "      <td>2006</td>\n",
       "      <td>1</td>\n",
       "      <td>MIL</td>\n",
       "      <td>NL</td>\n",
       "      <td>20</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88650</th>\n",
       "      <th>johnsra05</th>\n",
       "      <td>2006</td>\n",
       "      <td>1</td>\n",
       "      <td>NYA</td>\n",
       "      <td>AL</td>\n",
       "      <td>33</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88652</th>\n",
       "      <th>finlest01</th>\n",
       "      <td>2006</td>\n",
       "      <td>1</td>\n",
       "      <td>SFN</td>\n",
       "      <td>NL</td>\n",
       "      <td>139</td>\n",
       "      <td>426</td>\n",
       "      <td>66</td>\n",
       "      <td>105</td>\n",
       "      <td>21</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>46</td>\n",
       "      <td>55.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88653</th>\n",
       "      <th>gonzalu01</th>\n",
       "      <td>2006</td>\n",
       "      <td>1</td>\n",
       "      <td>ARI</td>\n",
       "      <td>NL</td>\n",
       "      <td>153</td>\n",
       "      <td>586</td>\n",
       "      <td>93</td>\n",
       "      <td>159</td>\n",
       "      <td>52</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>73.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>69</td>\n",
       "      <td>58.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88662</th>\n",
       "      <th>seleaa01</th>\n",
       "      <td>2006</td>\n",
       "      <td>1</td>\n",
       "      <td>LAN</td>\n",
       "      <td>NL</td>\n",
       "      <td>28</td>\n",
       "      <td>26</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89177</th>\n",
       "      <th>francju01</th>\n",
       "      <td>2007</td>\n",
       "      <td>2</td>\n",
       "      <td>ATL</td>\n",
       "      <td>NL</td>\n",
       "      <td>15</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89178</th>\n",
       "      <th>francju01</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>NYN</td>\n",
       "      <td>NL</td>\n",
       "      <td>40</td>\n",
       "      <td>50</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89330</th>\n",
       "      <th>zaungr01</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>TOR</td>\n",
       "      <td>AL</td>\n",
       "      <td>110</td>\n",
       "      <td>331</td>\n",
       "      <td>43</td>\n",
       "      <td>80</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51</td>\n",
       "      <td>55.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89333</th>\n",
       "      <th>witasja01</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>TBA</td>\n",
       "      <td>AL</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89334</th>\n",
       "      <th>williwo02</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>HOU</td>\n",
       "      <td>NL</td>\n",
       "      <td>33</td>\n",
       "      <td>59</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89335</th>\n",
       "      <th>wickmbo01</th>\n",
       "      <td>2007</td>\n",
       "      <td>2</td>\n",
       "      <td>ARI</td>\n",
       "      <td>NL</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89336</th>\n",
       "      <th>wickmbo01</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>ATL</td>\n",
       "      <td>NL</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89337</th>\n",
       "      <th>whitero02</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>MIN</td>\n",
       "      <td>AL</td>\n",
       "      <td>38</td>\n",
       "      <td>109</td>\n",
       "      <td>8</td>\n",
       "      <td>19</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89338</th>\n",
       "      <th>whiteri01</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>HOU</td>\n",
       "      <td>NL</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89339</th>\n",
       "      <th>wellsda01</th>\n",
       "      <td>2007</td>\n",
       "      <td>2</td>\n",
       "      <td>LAN</td>\n",
       "      <td>NL</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89340</th>\n",
       "      <th>wellsda01</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>SDN</td>\n",
       "      <td>NL</td>\n",
       "      <td>22</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89341</th>\n",
       "      <th>weathda01</th>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>CIN</td>\n",
       "      <td>NL</td>\n",
       "      <td>67</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 year  stint team  lg    g   ab   r    h  X2b  X3b  ...   \\\n",
       "id    player                                                        ...    \n",
       "88641 womacto01  2006      2  CHN  NL   19   50   6   14    1    0  ...    \n",
       "88643 schilcu01  2006      1  BOS  AL   31    2   0    1    0    0  ...    \n",
       "88645 myersmi01  2006      1  NYA  AL   62    0   0    0    0    0  ...    \n",
       "88649 helliri01  2006      1  MIL  NL   20    3   0    0    0    0  ...    \n",
       "88650 johnsra05  2006      1  NYA  AL   33    6   0    1    0    0  ...    \n",
       "88652 finlest01  2006      1  SFN  NL  139  426  66  105   21   12  ...    \n",
       "88653 gonzalu01  2006      1  ARI  NL  153  586  93  159   52    2  ...    \n",
       "88662 seleaa01   2006      1  LAN  NL   28   26   2    5    1    0  ...    \n",
       "89177 francju01  2007      2  ATL  NL   15   40   1   10    3    0  ...    \n",
       "89178 francju01  2007      1  NYN  NL   40   50   7   10    0    0  ...    \n",
       "89330 zaungr01   2007      1  TOR  AL  110  331  43   80   24    1  ...    \n",
       "89333 witasja01  2007      1  TBA  AL    3    0   0    0    0    0  ...    \n",
       "89334 williwo02  2007      1  HOU  NL   33   59   3    6    0    0  ...    \n",
       "89335 wickmbo01  2007      2  ARI  NL    8    0   0    0    0    0  ...    \n",
       "89336 wickmbo01  2007      1  ATL  NL   47    0   0    0    0    0  ...    \n",
       "89337 whitero02  2007      1  MIN  AL   38  109   8   19    4    0  ...    \n",
       "89338 whiteri01  2007      1  HOU  NL   20    1   0    0    0    0  ...    \n",
       "89339 wellsda01  2007      2  LAN  NL    7   15   2    4    1    0  ...    \n",
       "89340 wellsda01  2007      1  SDN  NL   22   38   1    4    0    0  ...    \n",
       "89341 weathda01  2007      1  CIN  NL   67    0   0    0    0    0  ...    \n",
       "\n",
       "                  rbi   sb   cs  bb    so   ibb  hbp   sh   sf  gidp  \n",
       "id    player                                                          \n",
       "88641 womacto01   2.0  1.0  1.0   4   4.0   0.0  0.0  3.0  0.0   0.0  \n",
       "88643 schilcu01   0.0  0.0  0.0   0   1.0   0.0  0.0  0.0  0.0   0.0  \n",
       "88645 myersmi01   0.0  0.0  0.0   0   0.0   0.0  0.0  0.0  0.0   0.0  \n",
       "88649 helliri01   0.0  0.0  0.0   0   2.0   0.0  0.0  0.0  0.0   0.0  \n",
       "88650 johnsra05   0.0  0.0  0.0   0   4.0   0.0  0.0  0.0  0.0   0.0  \n",
       "88652 finlest01  40.0  7.0  0.0  46  55.0   2.0  2.0  3.0  4.0   6.0  \n",
       "88653 gonzalu01  73.0  0.0  1.0  69  58.0  10.0  7.0  0.0  6.0  14.0  \n",
       "88662 seleaa01    0.0  0.0  0.0   1   7.0   0.0  0.0  6.0  0.0   1.0  \n",
       "89177 francju01   8.0  0.0  0.0   4  10.0   1.0  0.0  0.0  1.0   1.0  \n",
       "89178 francju01   8.0  2.0  1.0  10  13.0   0.0  0.0  0.0  1.0   1.0  \n",
       "89330 zaungr01   52.0  0.0  0.0  51  55.0   8.0  2.0  1.0  6.0   9.0  \n",
       "89333 witasja01   0.0  0.0  0.0   0   0.0   0.0  0.0  0.0  0.0   0.0  \n",
       "89334 williwo02   2.0  0.0  0.0   0  25.0   0.0  0.0  5.0  0.0   1.0  \n",
       "89335 wickmbo01   0.0  0.0  0.0   0   0.0   0.0  0.0  0.0  0.0   0.0  \n",
       "89336 wickmbo01   0.0  0.0  0.0   0   0.0   0.0  0.0  0.0  0.0   0.0  \n",
       "89337 whitero02  20.0  0.0  0.0   6  19.0   0.0  3.0  0.0  1.0   2.0  \n",
       "89338 whiteri01   0.0  0.0  0.0   0   1.0   0.0  0.0  0.0  0.0   0.0  \n",
       "89339 wellsda01   1.0  0.0  0.0   0   6.0   0.0  0.0  0.0  0.0   0.0  \n",
       "89340 wellsda01   0.0  0.0  0.0   0  12.0   0.0  0.0  4.0  0.0   0.0  \n",
       "89341 weathda01   0.0  0.0  0.0   0   0.0   0.0  0.0  0.0  0.0   0.0  \n",
       "\n[20 rows x 21 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(n=20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "inputHidden": false,
    "outputHidden": false
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernel_info": {
   "name": "python3"
  },
  "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.2"
  },
  "nteract": {
   "version": "nteract-on-jupyter@2.0.4"
  },
  "title": "Pandas Table Schema Advancements"
 },
 "nbformat": 4,
 "nbformat_minor": 4
}