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')
/home/yanghao3/result.csv