Finding number of times a sport comes up for each country python data frame
import pandas as pd
df = pd.DataFrame([{'Country': 'India', 'Sport': 'Badmintan'}, {'Country': 'China', 'Sport': 'Badmintan'},{'Country': 'India', 'Sport': 'Football'}])
print(df)
print(df.groupby(by=('Country')).count())
Answer:
Country
China        1
India        2
I am stuck on a problem about Olympics athletes.
I need to find the number of different sports each country participates in from my data frame, I am unsure how to do this as the column 'country' obviously has duplicates as well as the column 'sport' and I cant figure out how to group them and return a value for each country
Any help would be awesome :)