Icon

Week 41 - Forbes Highest Paid Athletes

Recently, one of the Data School Coaches, Robbin, set the following challenge. It seemed perfect for a Preppin' Data, so over to Robbin:

We'd like to get historical data on the highest paid athletes so we can do temporal analysis.

Lucky us, it turns out Wikipedia has been tracking the Forbes list of the world's highest-paid athletes. Unlucky us, it is in an HTML table format with human readable symbols and table by table basis. Now it's time for you to clean it up into one single dataset, so that it's ready for analysis.

URL: 2024: Week 41 - Forbes Highest Paid Athletes https://preppindata.blogspot.com/2024/10/2024-week-41-forbes-highest-paid.html

Node 1Node 3Node 4Node 5Node 6Node 7Node 10Node 12Node 24Node 26Read ExcelSheet Names Table Row toVariable Loop Start Excel Reader Loop End Rule Engine(Dictionary) Table Creator Number to String Column Renamer Column Filter ConstantValue Column Math calcuations string calcuations Node 1Node 3Node 4Node 5Node 6Node 7Node 10Node 12Node 24Node 26Read ExcelSheet Names Table Row toVariable Loop Start Excel Reader Loop End Rule Engine(Dictionary) Table Creator Number to String Column Renamer Column Filter ConstantValue Column Math calcuations string calcuations

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: girib
Created at: 2024-10-17
On NodePit since: 2024-10-17
Last update: 2026-01-13
Created with KNIME version: v5.3.2
Tags: Preppindata

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

Try NodePit Runner!