Skip to content

Kumar-DataSavvy/Olympic-Games-Data-Analysis-using-MS-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 

Repository files navigation

Olympic-Games-Data-Analysis-using-MS-SQL

I downloaded the 120 years of Olympic Games historical dataset from Kaggle. The dataset contains information about Olympic games held from 1896 to 2016. I answered questions obtained from techtfq.com. The dataset contains two tables: one about the athletes and the other about the regions.

logo

CONTENT

The file athlete_events.csv contains 271116 rows and 15 columns. Each row corresponds to an individual athlete competing in an individual Olympic event (athlete-events). The columns are:

  • ID - Unique number for each athlete
  • Name - Athlete's name
  • Sex - M or F
  • Age - Integer
  • Height - In centimeters
  • Weight - In kilograms
  • Team - Team name
  • NOC - National Olympic Committee 3-letter code
  • Games - Year and season
  • Year - Integer
  • Season - Summer or Winter
  • City - Host city
  • Sport - Sport
  • Event - Event
  • Medal - Gold, Silver, Bronze, or NA

The Region file contains 230 rows and 3 columns. The columns are;

  • NOC - National Olympic Committee 3-letter code
  • Region - Name of countries
  • Notes - Notes

Link to the Dataset Olympic Games

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors