pandas行转列

Year    Country medal   no of medals
1896    Afghanistan Gold    5
1896    Afghanistan Silver  4
1896    Afghanistan Bronze  3
1896    Algeria Gold    1
1896    Algeria Silver  2
1896    Algeria Bronze  3

Year    Country Gold    Silver  Bronze
1896    Afghanistan 5   4   3
1896    Algeria     1   2   3

df = pd.read_csv('/home/yanghao3/pandas.csv')
medals = df.pivot_table('no', ['Year', 'Country'], 'medal')
medals.reset_index(level=0,inplace=True)
medals.reset_index(level=0,inplace=True)
#改变列的顺序
medals = medals.reindex_axis(['Year', 'Country', 'Gold', 'Silver', 'Bronze'], axis = 1)
medals.to_csv('/home/yanghao3/result.csv')