Icon

Just KNIME It S03 _​ CH11 _​ Olympic Trivia

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

URL: Solutions to “Just KNIME It!” Challenge 11 - Season 3 https://forum.knime.com/t/solutions-to-just-knime-it-challenge-11-season-3/81309

Just KNIME It - Season3 - Challenge 11: Olympic Triviahttps://hub.knime.com/-/spaces/-/~LmaP6jR2tOipr6TB/current-state/ (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? JKI S03 CH 11 top average number ofmedals JKI S03 CH 11 debutant sport in Rio 2016 JKI S03 CH 11 oldest gold medalist athlete_events.csvnoc_regions.csvathletes by coutry and yearmedals by country and yearmerge $count athletes$ , $medals per country$count athletesmedals per country (gold, silver, and bronze combined)includeathlete_eventswith medalsaddress missing to $medals per country$ 0 == no medals$medals per athlete$ by country andyear$Mean(medals per athlete)$[ percent ] by country participations (all olimpic history)inspect top 5 sorted descendantaddress NOC namesconcatenate NOC info$medals per athlete _ avg of participations$[ percent ] by country participations (all olimpic history)round 2 decimalseason include summerRío 2016Node 100Node 101Node 1022016 Rio de Janeiro Rugby Sevens top 5 oldest gold medalistage exclude NAmedal include goldupper = previous olympicsselect displaycolumns CSV Reader CSV Reader GroupBy GroupBy Joiner Column Rename(deprecated) Column Rename(deprecated) Row Filter Missing Value Math Formula GroupBy Top k Row Filter Joiner Column Expressions Column Renamer Math Formula Row Filter Row Filter GroupBy GroupBy Joiner Rule-basedRow Filter Top k Row Filter Row Filter Row Filter Rule-basedRow Splitter Column Filter Just KNIME It - Season3 - Challenge 11: Olympic Triviahttps://hub.knime.com/-/spaces/-/~LmaP6jR2tOipr6TB/current-state/ (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? JKI S03 CH 11 top average number ofmedals JKI S03 CH 11 debutant sport in Rio 2016 JKI S03 CH 11 oldest gold medalist athlete_events.csvnoc_regions.csvathletes by coutry and yearmedals by country and yearmerge $count athletes$ , $medals per country$count athletesmedals per country (gold, silver, and bronze combined)includeathlete_eventswith medalsaddress missing to $medals per country$ 0 == no medals$medals per athlete$ by country andyear$Mean(medals per athlete)$[ percent ] by country participations (all olimpic history)inspect top 5 sorted descendantaddress NOC namesconcatenate NOC info$medals per athlete _ avg of participations$[ percent ] by country participations (all olimpic history)round 2 decimalseason include summerRío 2016Node 100Node 101Node 1022016 Rio de Janeiro Rugby Sevens top 5 oldest gold medalistage exclude NAmedal include goldupper = previous olympicsselect displaycolumns CSV Reader CSV Reader GroupBy GroupBy Joiner Column Rename(deprecated) Column Rename(deprecated) Row Filter Missing Value Math Formula GroupBy Top k Row Filter Joiner Column Expressions Column Renamer Math Formula Row Filter Row Filter GroupBy GroupBy Joiner Rule-basedRow Filter Top k Row Filter Row Filter Row Filter Rule-basedRow Splitter Column Filter

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: gabeg
Created at: 2024-07-28
On NodePit since: 2024-07-30
Last update: 2024-11-21
Created with KNIME version: v5.2.5
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!