The problem I'm having right now is seperating a groupby.
I have a dataframe of Olympic data which would look something like this for example:
ID Name Sport Medal
1 name1 Athletics Gold
2 name2 Handball NaN
3 name3 Fencing Silver
4 name4 Athletics NaN
5 name5 Fencing Bronze
6 name6 Fencing Gold
And I want to show the amount of medals per sport. I tried to achieve this by using:
medals_per_sport = df.groupby(['Sport', 'Medal']).size()
medals_per_sport
This gives me the following result:
Sport Medal
Athletics Gold 1
Fencing Silver 1
Bronze 1
Gold 1
This looks good, but what I would kinda want is a dataframe result like this:
Sport Gold Silver Bronze
Athletics 1 NaN/0 NaN/0
Fencing 1 1 1
So I can easily get the amount of medals per sport. Or (maybe I'm missing the use of a "Series") someone could show me a way to easily extract this information from the above Series.