了解MultiIndex

我自己想通了。

df = read_csv("data/Workbook1.csv")df     name team      date  score0    John    A    3/9/12    1001    John    B    3/9/12     992    Jane    B    4/9/12    1023   Peter    A    9/9/12    1034   Josie    C   11/9/12    1115  Rachel    A  30/10/12     986    Kate    B  31/10/12    1037   David    C   1/11/12    104df2 = df.pivot('team', 'name').stack()df2      date  scoreteam name        A    John      3/9/12    100     Peter     9/9/12    103     Rachel  30/10/12     98B    Jane      4/9/12    102     John      3/9/12     99     Kate    31/10/12    103C    David    1/11/12    104     Josie    11/9/12    111