Dataset

Olympics 2024

Why did I chose this dataset?

I chose this dataset on the 2024 Olympics dataset because it's a highly relevant event currently generating significant interest from everyone around the world. The event just ended not long ago, and an in-depth analysis would provide valuable insights into the performances and outcomes.

Progress

• Picked dataset
• Defined 10 questions
• Answered 10 questions using Pandas
• Added at least one data visualization (using Matplotlib and/or Seaborn) to each single question
• Prepared presentation slides to present at graduation

Questions

• Question 1: What is total medals won in each Olympic sport?

  • Answer: Here's a list of the medal counts for each sport: Archery: 15, Artistic swimming: 6, Athletics: 145, Badminton: 15, Basketball: 12, Boxing: 52, Breaking: 6, Canoeing: 49, Cycling: 66, Diving: 24, Equestrian: 18, Fencing: 36, Field hockey: 6, Football: 6, Golf: 6, Gymnastics: 55, Handball: 6, Judo: 60,Modern pentathlon: 6, Rowing: 42, Rugby sevens: 6, Sailing: 30, Shooting: 45, Skateboarding: 12, Sport climbing: 12, Surfing: 6, Swimming: 111, Table tennis: 15, Taekwondo: 32, Tennis: 15, Triathlon: 9, Volleyball: 12, Water polo: 6, Weightlifting: 30, Wrestling: 72.
  • Visualization:

• Question 2: What is total medals won by each country?

  • Answer: See the graph for detail information. For example, Albania:2, Algeria: 3, Argentina: 3, Armenia: 4, Australia: 53, Uganda: 2, Ukraine: 12, United States: 126, Uzbekistan: 13, Zambia:1
  • Visualization:

• Question 3: What is the ratio of gold medals to silver medals to bronze medals?

  • Answer: Ratio of Gold medal is 31.5%, silver medal is 31.6, and bronze medal is 36.9%.
  • Visualization:

• Question 4: Top 5 country with the most gold medal

  • Answer: China won 40 gold medals. USA won 40 gold medals as well. Japan won 20 gold medals while Australia won 18 gold medals. France won 16 gold medals.
  • Visualization:

• Question 5: Top 5 country with the most silver medal

  • Answer: USA won 44 silver medals. China won 27 silver medals. France won 26 silver medals while Great Britain won 22 silver medals. Australia won 19 silver medals.
  • Visualization:

• Question 6: Top 5 country with the most bronze medal

  • Answer: USA won 42 bronze medals. Great Britain won 29 bronze medals. China won 24 bronze medals while France won 22 bronze medals. Australia won 16 bronze medals.
  • Visualization:

• Question 7: Top 5 sport with the most gold medal

  • Answer: There was 48 gold medals in athletics, 37 gold medals in swimming, 22 gold medals in cycling, 18 gold in wrestling as well as gymnastics.
  • Visualization:

• Question 8: Top 5 sport with the most silver medal

  • Answer: There was 48 silver medals in athletics, 38 silver medals in swimming, 22 silver medals in cycling, 18 silver medals in wrestling as well as gymnastics.
  • Visualization:

• Question 9: Top 5 sport with the most bronze medal

  • Answer: There was 49 bronze medals in athletics, 36 bronze medals in wrestling and swimming respectively, 30 bronze medals in Judo, 26 bronze medals in boxing.
  • Visualization:

• Question 10:What proportion of total medals is contributed by each sport?

  • Answer: Archery 1.436782 Artistic swimming 0.574713 Athletics 13.888889 Badminton 1.436782 Basketball 1.149425 Boxing 4.980843 Breaking 0.574713 Canoeing 4.693487 Cycling 6.321839 Diving 2.298851 Equestrian 1.724138 Fencing 3.448276 Field hockey 0.574713 Football 0.574713 Golf 0.574713 Gymnastics 5.268199 Handball 0.574713 Judo 5.747126 Modern pentathlon 0.574713 Rowing 4.022989 Rugby sevens 0.574713 Sailing 2.873563 Shooting 4.310345 Skateboarding 1.149425 Sport climbing 1.149425 Surfing 0.574713 Swimming 10.632184 Table tennis 1.436782 Taekwondo 3.065134 Tennis 1.436782 Triathlon 0.862069 Volleyball 1.149425 Water polo 0.574713 Weightlifting 2.873563 Wrestling 6.896552
  • Visualization: