Skip to content

uchenna23/Project-3

Repository files navigation

2021 Tokyo Olympics 🏅

alt text

About our project:

The 2020 Olympic tournament was delayed one year due to the unforgivable Covid-19 pandemic. With this looming around the Olympic games, many around the world were not able to fully experience the sacred event which comes every four years. With this in mind, we created an interactive dashboard to help inform the end user about the competition including gender participation and medal information for each discipline and event. From there, we deployed our dashboard on GitHub pages.

Our data comes from a kaggle data set that included athletes, coaches, medals and technical officials information. From the data provided, we chose to focus on the athlete and medals data for our dashboard. Athletes information included their name, gender, country they represented and their event's discipline. The medals information included the medal type, the athletes who won medals, the events and number and types of medals won by country.

This would be useful to sports analysts, Olympic historians and hobbyists and even athlete's by having a place to check Olympic related information. This would also be helpful to the casual Olympic fan who weren't in a place to watch the Olympics due to lower coverage because of the pandemic.

Click here to view site: 2021 Olympic Dashboard

Technologies: 🥇

  • Python
  • PostgreSQL
  • Javascript (D3, Plotly, Flip.min)
  • HTML/Bootstrap/CSS
  • GitHub Pages

Approach: 🥈

  1. Identify data sources
  2. Collect and clean athletes, medals and medals total data
  3. Load data in PostgreSQL
  4. Create charts and graphs using Javascript libraries
  5. Customize HTML and CSS for final application
  6. Visualize dashboard in GitHub Pages

Going Forward: 🥉

  • Charts of medals for each country by discipline and event​
  • Charts of the amount and type of medals won by each country by discipline and event​
  • A heatmap of the type the numbers of medals won by each country

Data Sources:

This is an Olympic Games dataset that describes medals and athletes for Tokyo 2020. The data was created from Tokyo Olympics. We used the athletes.csv (11657 rows), medals.csv (2402 rows) and medals_total.csv (94 rows).

Schema (ERD):

ERD

Contributors: 🏆

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •