{ "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
yearstintteamlggabrhX2bX3b...rbisbcsbbsoibbhbpshsfgidp
idplayer
88641womacto0120062CHNNL195061410...2.01.01.044.00.00.03.00.00.0
88643schilcu0120061BOSAL3120100...0.00.00.001.00.00.00.00.00.0
88645myersmi0120061NYAAL6200000...0.00.00.000.00.00.00.00.00.0
88649helliri0120061MILNL2030000...0.00.00.002.00.00.00.00.00.0
88650johnsra0520061NYAAL3360100...0.00.00.004.00.00.00.00.00.0
88652finlest0120061SFNNL139426661052112...40.07.00.04655.02.02.03.04.06.0
88653gonzalu0120061ARINL15358693159522...73.00.01.06958.010.07.00.06.014.0
88662seleaa0120061LANNL28262510...0.00.00.017.00.00.06.00.01.0
89177francju0120072ATLNL154011030...8.00.00.0410.01.00.00.01.01.0
89178francju0120071NYNNL405071000...8.02.01.01013.00.00.00.01.01.0
89330zaungr0120071TORAL1103314380241...52.00.00.05155.08.02.01.06.09.0
89333witasja0120071TBAAL300000...0.00.00.000.00.00.00.00.00.0
89334williwo0220071HOUNL33593600...2.00.00.0025.00.00.05.00.01.0
89335wickmbo0120072ARINL800000...0.00.00.000.00.00.00.00.00.0
89336wickmbo0120071ATLNL4700000...0.00.00.000.00.00.00.00.00.0
89337whitero0220071MINAL3810981940...20.00.00.0619.00.03.00.01.02.0
89338whiteri0120071HOUNL2010000...0.00.00.001.00.00.00.00.00.0
89339wellsda0120072LANNL7152410...1.00.00.006.00.00.00.00.00.0
89340wellsda0120071SDNNL22381400...0.00.00.0012.00.00.04.00.00.0
89341weathda0120071CINNL6700000...0.00.00.000.00.00.00.00.00.0
\n", "

20 rows × 21 columns

\n", "
" ], "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 }