In [1]:

import pandas as pd
pd.options.display.html.table_schema = True

In [2]:

baseball_file = "https://raw.githubusercontent.com/pandas-dev/pandas/master/doc/data/baseball.csv"
df = pd.read_csv(baseball_file).set_index(['id', 'player'])

In [3]:

df.head(n=20)

Out[3]:

		year	stint	team	lg	g	ab	r	h	X2b	X3b	...	rbi	sb	cs	bb	so	ibb	hbp	sh	sf	gidp
id	player
88641	womacto01	2006	2	CHN	NL	19	50	6	14	1	0	...	2.0	1.0	1.0	4	4.0	0.0	0.0	3.0	0.0	0.0
88643	schilcu01	2006	1	BOS	AL	31	2	0	1	0	0	...	0.0	0.0	0.0	0	1.0	0.0	0.0	0.0	0.0	0.0
88645	myersmi01	2006	1	NYA	AL	62	0	0	0	0	0	...	0.0	0.0	0.0	0	0.0	0.0	0.0	0.0	0.0	0.0
88649	helliri01	2006	1	MIL	NL	20	3	0	0	0	0	...	0.0	0.0	0.0	0	2.0	0.0	0.0	0.0	0.0	0.0
88650	johnsra05	2006	1	NYA	AL	33	6	0	1	0	0	...	0.0	0.0	0.0	0	4.0	0.0	0.0	0.0	0.0	0.0
88652	finlest01	2006	1	SFN	NL	139	426	66	105	21	12	...	40.0	7.0	0.0	46	55.0	2.0	2.0	3.0	4.0	6.0
88653	gonzalu01	2006	1	ARI	NL	153	586	93	159	52	2	...	73.0	0.0	1.0	69	58.0	10.0	7.0	0.0	6.0	14.0
88662	seleaa01	2006	1	LAN	NL	28	26	2	5	1	0	...	0.0	0.0	0.0	1	7.0	0.0	0.0	6.0	0.0	1.0
89177	francju01	2007	2	ATL	NL	15	40	1	10	3	0	...	8.0	0.0	0.0	4	10.0	1.0	0.0	0.0	1.0	1.0
89178	francju01	2007	1	NYN	NL	40	50	7	10	0	0	...	8.0	2.0	1.0	10	13.0	0.0	0.0	0.0	1.0	1.0
89330	zaungr01	2007	1	TOR	AL	110	331	43	80	24	1	...	52.0	0.0	0.0	51	55.0	8.0	2.0	1.0	6.0	9.0
89333	witasja01	2007	1	TBA	AL	3	0	0	0	0	0	...	0.0	0.0	0.0	0	0.0	0.0	0.0	0.0	0.0	0.0
89334	williwo02	2007	1	HOU	NL	33	59	3	6	0	0	...	2.0	0.0	0.0	0	25.0	0.0	0.0	5.0	0.0	1.0
89335	wickmbo01	2007	2	ARI	NL	8	0	0	0	0	0	...	0.0	0.0	0.0	0	0.0	0.0	0.0	0.0	0.0	0.0
89336	wickmbo01	2007	1	ATL	NL	47	0	0	0	0	0	...	0.0	0.0	0.0	0	0.0	0.0	0.0	0.0	0.0	0.0
89337	whitero02	2007	1	MIN	AL	38	109	8	19	4	0	...	20.0	0.0	0.0	6	19.0	0.0	3.0	0.0	1.0	2.0
89338	whiteri01	2007	1	HOU	NL	20	1	0	0	0	0	...	0.0	0.0	0.0	0	1.0	0.0	0.0	0.0	0.0	0.0
89339	wellsda01	2007	2	LAN	NL	7	15	2	4	1	0	...	1.0	0.0	0.0	0	6.0	0.0	0.0	0.0	0.0	0.0
89340	wellsda01	2007	1	SDN	NL	22	38	1	4	0	0	...	0.0	0.0	0.0	0	12.0	0.0	0.0	4.0	0.0	0.0
89341	weathda01	2007	1	CIN	NL	67	0	0	0	0	0	...	0.0	0.0	0.0	0	0.0	0.0	0.0	0.0	0.0	0.0

20 rows × 21 columns

In [4]: