Baselight
Sign In

Olympics 124 Years Dataset(till 2020)

Summer olympics data set (124 years) & winter dataset (90 years)

@kaggle.nitishsharma01_olympics_124_years_datasettill_2020

About this Dataset

Olympics 124 Years Dataset(till 2020)

The modern Olympic Games have been held every four years since 1896, so there have been a total of 27 summer Olympics and 22 winter Olympics as of my training data cutoff in 2021. I used two different datasets for this project, and I performed multiple functions to create a valuable dataset from the two. The first dataset was completely different from the other, so I used Pandas to perform different tasks and create a compatible dataset for this project. 

Tables

Athletes Summer Games

@kaggle.nitishsharma01_olympics_124_years_datasettill_2020.athletes_summer_games
  • 4.94 MB
  • 237673 rows
  • 13 columns
Loading...
 

CREATE TABLE athletes_summer_games (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "sex" VARCHAR,
  "age" DOUBLE,
  "team" VARCHAR,
  "noc" VARCHAR,
  "games" VARCHAR,
  "year" BIGINT,
  "season" VARCHAR,
  "city" VARCHAR,
  "sport" VARCHAR,
  "event" VARCHAR,
  "medal" VARCHAR
);

Athletes Winter Games

@kaggle.nitishsharma01_olympics_124_years_datasettill_2020.athletes_winter_games
  • 925.02 KB
  • 48564 rows
  • 13 columns
Loading...
 

CREATE TABLE athletes_winter_games (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "sex" VARCHAR,
  "age" DOUBLE,
  "team" VARCHAR,
  "noc" VARCHAR,
  "games" VARCHAR,
  "year" BIGINT,
  "season" VARCHAR,
  "city" VARCHAR,
  "sport" VARCHAR,
  "event" VARCHAR,
  "medal" VARCHAR
);

Regions

@kaggle.nitishsharma01_olympics_124_years_datasettill_2020.regions
  • 8.26 KB
  • 234 rows
  • 4 columns
Loading...
 

CREATE TABLE regions (
  "unnamed_0" BIGINT,
  "noc" VARCHAR,
  "region" VARCHAR,
  "notes" VARCHAR
);