Icon

OlympicsDataset_​Manipulation

Data Wrangling on Olympics Dataset

The objective of this workflow is to explore the Olympics dataset and
- to visualize among the summer and winter olympics, which is a better event in terms of the number of medals won.
- to find out the top 10 performing teams at summer event and winter event.
- to find out the top performing country iin both events in terms of gold medals won.
- to find out the best performing country in terms of points earned and it's medal tally.

4. Best Performing Country in terms of Points Earned Calculating Points gained by each Country 2. Top 10 countries in an Olympics Season. Selecting country with the mostpoints 1. From Olympics data set, figure out in which olympic event does the countriesperform better in.2. Which are the top 10 performing teams at summer event (with respect to totalmedals) and winter event.3. From the top 10 peformers for every season, find out the best performing countrywith respect to the ratio of gold medals to total medals 4. Find out the best performing country with respect to the points earned. 3. For each event, the top performing country interms of gold medals Rename Total column to Total_MedalsNode 39 File Reader (#1) Column Rename (#2) Math Formula (#26) Top k Selector(#29) Column Filter (#30) Table Row toVariable (#31) Medal Tally of the BestCountry in Olympics (#35) 1. Performance of countriesin different seasons (#36) Row Filter (#38) Top 10 countriesper season (#39) Math Formula (#43) Top k Selector(#44) Top k Selector(#45) Math Formula (#46) 4. Best Performing Country in terms of Points Earned Calculating Points gained by each Country 2. Top 10 countries in an Olympics Season. Selecting country with the mostpoints 1. From Olympics data set, figure out in which olympic event does the countriesperform better in.2. Which are the top 10 performing teams at summer event (with respect to totalmedals) and winter event.3. From the top 10 peformers for every season, find out the best performing countrywith respect to the ratio of gold medals to total medals 4. Find out the best performing country with respect to the points earned. 3. For each event, the top performing country interms of gold medals Rename Total column to Total_MedalsNode 39 File Reader (#1) Column Rename (#2) Math Formula (#26) Top k Selector(#29) Column Filter (#30) Table Row toVariable (#31) Medal Tally of the BestCountry in Olympics (#35) 1. Performance of countriesin different seasons (#36) Row Filter (#38) Top 10 countriesper season (#39) Math Formula (#43) Top k Selector(#44) Top k Selector(#45) Math Formula (#46)

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: knoldus
Created at: 2020-05-28
On NodePit since: 2020-05-29
Last update: 2024-11-18
Created with KNIME version: v4.1.3
Tags: DataWranglingvisualizeanalysis

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

Try NodePit Runner!