I want to show a line chart With USA and URS that show only specific kinds of sports and count how many gold medals they got in them. Anyone knows what to do? THANKS ALOT!!!
urs = olympics[olympics['NOC']=='URS']
medal_sports_urs = urs[urs['Medal'] == 'Gold'].groupby(['Year', 'Sport', 'Event'])
medal_sports_urs = medal_sports_urs.first()
medal_sports_urs = medal_sports_urs.reset_index()
medal_sports_urs = medal_sports_urs[medal_sports_urs['Sport'] == "Swimming", "Gymnastics"].value_counts()
medal_sports_urs.plot.line()
plt.xticks(np.arange(len(medal_sports_urs.index)), medal_sports_urs.index)
usa = olympics[olympics['NOC']=='USA']
medal_sports_usa = usa[usa['Medal'] == 'Gold'].groupby(['Year', 'Sport', 'Event'])
medal_sports_usa = medal_sports_usa.first()
medal_sports_usa = medal_sports_usa.reset_index()
medal_sports_usa = medal_sports_usa[medal_sports_usa['Sport'] == "Swimming", "Gymnastics"].value_counts()
medal_sports_usa.plot.line()
plt.xticks(np.arange(len(medal_sports_usa.index)), medal_sports_usa.index)