Olympics Sports and Medals from 1896-2014

This dataset provides comprehensive historical data on the medals won in the Olympics from 1896 to 2014. It includes detailed information about the sports in which the medals were won, the specific events, the athletes who secured them, and the type of medal awarded (Gold, Silver, or Bronze). Additionally, it covers both the Summer and Winter Olympics, offering a complete overview of the countries represented and the gender of the athletes, allowing for in-depth analysis of Olympic performance across different disciplines and time periods.

Dataset Overview

I am combining the following 3 datasets for my final project:

• Dictionary Dataset (Country Data):

• Columns:

  • Country: Date of stock data.
  • Code: Opening price.
  • Population: Highest price.
  • GDP per Capita: Lowest price.

• Summer Olympics Dataset (Country Data):

• Columns:

  • Year: The year of the event.
  • City: The city where the event took place
  • Sport: Specific discipline within the sport.
  • Athlete: Name of the athlete.
  • Country: The country the athlete represents.
  • Gender: The gender category.
  • Event: The specific event or competition.
  • Medal: Type of medal won (Gold, Silver, or Bronze).

• Winter Olympics Dataset (Country Data):

• Columns:

  • Year: The year of the event.
  • City: The city where the event took place
  • Sport: Specific discipline within the sport.
  • Athlete: Name of the athlete.
  • Country: The country the athlete represents.
  • Gender: The gender category.
  • Event: The specific event or competition.
  • Medal: Type of medal won (Gold, Silver, or Bronze).

Usage

• Time Series Analysis: Analyze stock trends over time.
• Predictive Modeling: Forecast stock prices.
• Algorithmic Trading: Test trading strategies.
• Research: Compare company performance.

Example Usage (Python)

import pandas as pd
df = pd.read_csv('top_10_global_companies_stock_data_2024.csv')
print(df.head())

Tasks

• I want to see who are the top athletes in terms of medal counts in both the Summer and Winter Olympics.
• I want to see what is the gender distribution among athletes in both Summer and Winter Olympics.
• I want to see if there is a correlation between a country's GDP per capita and its Olympic success.
• I want to see how has the performance of a particular country in the Olympics evolved over time.
• I want to see how many medals have different countries won in the Summer and Winter Olympics.