Olympics 124 Years Dataset(till 2020) by Kaggle | Sports

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


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


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


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