Icon

justknimeit-21

Challenge 21: Eating OutYou are interning for a travel agency that wants to know about their top spenders' eating habits. As a trial run, you are given a tiny dataset with 6647 rows containinginformation on 1011 unique citizens traveling with different purposes. In this challenge you will:1. Find the top 10 participants spending the highest amount of money on eating.2. Find out whether the people who spend the most money on eating are the same people who spend the most time eating.Link: https://www.knime.com/just-knime-it Findings1. Top 10 participants are listed in the results table: Actually 12 participants as there is no way - based on the data - who is the "one" number 102. People who spend the most money on eating are NOT the same people who spend the most time eating (otherwise participantId 860 would be ranked #3 not #13)Link to this solution on the KNIME Hub: https://hub.knime.com/kowisoft/spaces/Public/latest/Just%20KNIME%20It/justknimeit-21~EWrU16hwnOs4nHInLink to the corresponding forum post: https://forum.knime.com/t/solutions-to-just-knime-it-challenge-21/44186/12?u=kowisoft import base datafocus on purpose" Eating"calc money spentcalctime spentgroup byparticipantIdadd rank based onmoney spentadd rankbased on time spentsort by rank moneythen byrank timedel allrank money >10CSV Reader Row Filter Math Formula Date&TimeDifference GroupBy Rank Rank Sorter Row Filter Challenge 21: Eating OutYou are interning for a travel agency that wants to know about their top spenders' eating habits. As a trial run, you are given a tiny dataset with 6647 rows containinginformation on 1011 unique citizens traveling with different purposes. In this challenge you will:1. Find the top 10 participants spending the highest amount of money on eating.2. Find out whether the people who spend the most money on eating are the same people who spend the most time eating.Link: https://www.knime.com/just-knime-it Findings1. Top 10 participants are listed in the results table: Actually 12 participants as there is no way - based on the data - who is the "one" number 102. People who spend the most money on eating are NOT the same people who spend the most time eating (otherwise participantId 860 would be ranked #3 not #13)Link to this solution on the KNIME Hub: https://hub.knime.com/kowisoft/spaces/Public/latest/Just%20KNIME%20It/justknimeit-21~EWrU16hwnOs4nHInLink to the corresponding forum post: https://forum.knime.com/t/solutions-to-just-knime-it-challenge-21/44186/12?u=kowisoft import base datafocus on purpose" Eating"calc money spentcalctime spentgroup byparticipantIdadd rank based onmoney spentadd rankbased on time spentsort by rank moneythen byrank timedel allrank money >10CSV Reader Row Filter Math Formula Date&TimeDifference GroupBy Rank Rank Sorter Row 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: m1pegv
Created at: 2022-06-17
On NodePit since: 2022-06-18
Last update: 2024-05-01
Created with KNIME version: v4.5.2

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

Try NodePit Runner!