Icon

justKnimeit-8

justKnimeit-8
Challenge 8: Wordle Scores on Average1) For the bar chart, each possible number of guesses (1 through 6) must be represented, as well as the number ofvictories by each player. Check this example with just a single player's data.2) Transform the number of guesses [1, 6] into a score [1,10], but remember that a higher number of guessesshould result in a lower score. A missing guess means that the player did not manage to guess the word andtherefore should receive a 0 score.3) Next, calculate the average of the three players. Who has the best average?4) Now consider the difficulty of the words. Assign a weight W to the words in the list of the 306 most difficult words inthe English language (file “difficult words.txt”), and recalculate the average of the three players for W=2 and for W=0.Has the player with the best score changed? Read PointsRead difficultwordsClear MissingPoints [1,6] to [1,10]Fix locale problemReplace with 0General Avg.Weigthed Avg.Node 36Add Description columnDescriptionsCalculate Difference Excel Reader File Reader Row Filter (Labs) String To Number Normalizer String Manipulation Missing Value Visualizations GroupBy GroupBy Lookup and Tidy up Concatenate Column Appender Table Creator Transpose Math Formula Transpose Challenge 8: Wordle Scores on Average1) For the bar chart, each possible number of guesses (1 through 6) must be represented, as well as the number ofvictories by each player. Check this example with just a single player's data.2) Transform the number of guesses [1, 6] into a score [1,10], but remember that a higher number of guessesshould result in a lower score. A missing guess means that the player did not manage to guess the word andtherefore should receive a 0 score.3) Next, calculate the average of the three players. Who has the best average?4) Now consider the difficulty of the words. Assign a weight W to the words in the list of the 306 most difficult words inthe English language (file “difficult words.txt”), and recalculate the average of the three players for W=2 and for W=0.Has the player with the best score changed? Read PointsRead difficultwordsClear MissingPoints [1,6] to [1,10]Fix locale problemReplace with 0General Avg.Weigthed Avg.Node 36Add Description columnDescriptionsCalculate Difference Excel Reader File Reader Row Filter (Labs) String To Number Normalizer String Manipulation Missing Value Visualizations GroupBy GroupBy Lookup and Tidy up Concatenate Column Appender Table Creator Transpose Math Formula Transpose

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: Lenovo
Created at: 2022-03-16
On NodePit since: 2022-03-17
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: justKnimeit-8

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

Try NodePit Runner!