Icon

Pivoting - Exploring the Olympics

Pivoting: Exploring the Olympics
Five Interesting facts about the Olympic Games 1896-2016This worflows uses the Pivoting node to aggregate and visually explore the athlete_events.xlsx dataset. #5 The true story of Tarzan #3 Many countries, same athlete #4 Winning isn't everything #1 Gender disparity and boycott #2 Winners will be winners Group by NOC and year,pivot by medal,aggregateby event (unique count)Filter out NAGroup by games,pivot by sex,aggregate by ID (unique count)Split for gamesFilterJohnny WeissmullerGroup by ID, name, sport,pivot by medal,aggregate by games(unique count)Filter out missing valuesandgames < 3Sort by NA medal(descending)Filter out gold,silver and bronze medalRead dataExtract yearExtract yearFilter outWinter gamesGroup by ID and name,aggregate by NOC(unique concatenate)CalculateaggregationlengthFilter out athletes whocompeted onlyfor 1 countryGroup by ID and name,pivot by medal,aggregate by event(count)Filter name, ID andgold medalRemovemissing valuesFilter althelteby IDJoin byathlete ID Pivoting Column Filter Pivoting Row Splitter Row Filter Pivoting Rule-basedRow Filter Sorter Column Filter Excel Reader String Manipulation String Manipulation Participationtrends Column Rename Visualize most tenaciousathletes/sports Visualize Tarzatat the Olympics Row Filter GroupBy String Manipulation Rule-basedRow Filter Pivoting Column Filter Missing Value ReferenceRow Filter Joiner Athlete and countryvisualization Frequency filtering Reshape data Scrape Tokyo2020 Medal Count Colour Bar Chart Plot Winners Five Interesting facts about the Olympic Games 1896-2016This worflows uses the Pivoting node to aggregate and visually explore the athlete_events.xlsx dataset. #5 The true story of Tarzan #3 Many countries, same athlete #4 Winning isn't everything #1 Gender disparity and boycott #2 Winners will be winners Group by NOC and year,pivot by medal,aggregateby event (unique count)Filter out NAGroup by games,pivot by sex,aggregate by ID (unique count)Split for gamesFilterJohnny WeissmullerGroup by ID, name, sport,pivot by medal,aggregate by games(unique count)Filter out missing valuesandgames < 3Sort by NA medal(descending)Filter out gold,silver and bronze medalRead dataExtract yearExtract yearFilter outWinter gamesGroup by ID and name,aggregate by NOC(unique concatenate)CalculateaggregationlengthFilter out athletes whocompeted onlyfor 1 countryGroup by ID and name,pivot by medal,aggregate by event(count)Filter name, ID andgold medalRemovemissing valuesFilter althelteby IDJoin byathlete ID Pivoting Column Filter Pivoting Row Splitter Row Filter Pivoting Rule-basedRow Filter Sorter Column Filter Excel Reader String Manipulation String Manipulation Participationtrends Column Rename Visualize most tenaciousathletes/sports Visualize Tarzatat the Olympics Row Filter GroupBy String Manipulation Rule-basedRow Filter Pivoting Column Filter Missing Value ReferenceRow Filter Joiner Athlete and countryvisualization Frequency filtering Reshape data Scrape Tokyo2020 Medal Count Colour Bar Chart Plot Winners

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: roberto.cadili
Created at: 2020-10-15
On NodePit since: 2021-09-28
Last update: 2024-04-28
Created with KNIME version: v4.4.1
Tags: #ETL#Aggregation#Pivoting#VisualExploration

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

Try NodePit Runner!