Icon

JKISeason3-11_​tomljh

Olympic Trivia

Level: Easy

Description: The 2024 Summer Olympics start this week: are you ready for some on-theme trivia? Here are three questions to test your knowledge:

1. Which country has the highest average number of medals (gold, silver, and bronze combined) per athlete, across all Summer Olympics?

2. Which sport made its debut at the Rio 2016 Olympics?

3. Who holds the title of the oldest gold medalist of all time?

If you're not sure about the answers, don't sweat it: we've got a handy dataset that covers the entire history of the Games for you. Before you know it, you'll be standing on the virtual podium as the trivia champion, ready to take home the gold!

Author: Michele Bassanelli

Dataset: Olympics Data on KNIME Community Hub

The field definitions in the table: ID: Unique identifier for each athlete.Name: Full name of the athlete.Sex: Gender of the athlete, typically 'M' for male or 'F' for female.Age: Age of the athlete at the time of the competition.Height: Height of the athlete, usually measured in centimeters.Weight: Weight of the athlete, usually measured in kilograms.Team: The team or country that the athlete represents.NOC: Three-letter code for the National Olympic Committee that the athlete represents.Games: Specific Olympic Games in which the athlete participated, often including the year and city.Year: Year in which the Olympic Games were held.Season: Season of the Olympic Games, either "Summer" or "Winter".City: City where the Olympic Games were hosted.Sport: Sport in which the athlete competed.Event: Specific event within the sport in which the athlete competed.Medal: Type of medal won by the athlete, such as "Gold", "Silver", or "Bronze". If no medal was won, this field may be empty or marked as "NA". 1. Which country has the highest average number of medals (gold, silver, and bronze combined) per athlete, across all SummerOlympics? 2. Which sport made its debut at the Rio 2016 Olympics? 3. Who holds the title of the oldest gold medalist of all time? athlete_events.csvnoc_regionsleft joinSIN -> SGPThe NOC code of Singapore seems to be wronggroup by :regionpivot : Medalagg : countAverage number of medals0Top 1<2016=2016ComplementA - BPS:Rugby SevensMeda = "Gold"Age<>"NA"Agerank = 1Season = "Summer" CSV Reader CSV Reader Joiner String Replacer Pivot Math Formula Missing Value Top k Row Filter Row Filter Row Filter Set Operator Row Filter Row Filter Rank Row Filter Row Filter Table View Column Resorter Number FormatManager Table View Table Manipulator Table View The field definitions in the table: ID: Unique identifier for each athlete.Name: Full name of the athlete.Sex: Gender of the athlete, typically 'M' for male or 'F' for female.Age: Age of the athlete at the time of the competition.Height: Height of the athlete, usually measured in centimeters.Weight: Weight of the athlete, usually measured in kilograms.Team: The team or country that the athlete represents.NOC: Three-letter code for the National Olympic Committee that the athlete represents.Games: Specific Olympic Games in which the athlete participated, often including the year and city.Year: Year in which the Olympic Games were held.Season: Season of the Olympic Games, either "Summer" or "Winter".City: City where the Olympic Games were hosted.Sport: Sport in which the athlete competed.Event: Specific event within the sport in which the athlete competed.Medal: Type of medal won by the athlete, such as "Gold", "Silver", or "Bronze". If no medal was won, this field may be empty or marked as "NA". 1. Which country has the highest average number of medals (gold, silver, and bronze combined) per athlete, across all SummerOlympics? 2. Which sport made its debut at the Rio 2016 Olympics? 3. Who holds the title of the oldest gold medalist of all time? athlete_events.csvnoc_regionsleft joinSIN -> SGPThe NOC code of Singapore seems to be wronggroup by :regionpivot : Medalagg : countAverage number of medals0Top 1<2016=2016ComplementA - BPS:Rugby SevensMeda = "Gold"Age<>"NA"Agerank = 1Season = "Summer" CSV Reader CSV Reader Joiner String Replacer Pivot Math Formula Missing Value Top k Row Filter Row Filter Row Filter Set Operator Row Filter Row Filter Rank Row Filter Row Filter Table View Column Resorter Number FormatManager Table View Table Manipulator Table View

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Admin
Created at: 2024-07-25
On NodePit since: 2024-07-27
Last update: 2024-09-18
Created with KNIME version: v5.3.0
Tags: JKISeason3-11

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!