Icon

KNIME_​challenge21_​solution

KNIME_challenge21_solution
Challenge 21: Eating OutLevel: EasyDescription: You 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:Find the top 10 participants spending the highest amount of money on eating.Find out whether the people who spend the most money on eating are the same people who spend the most time eating.Note: Sometimes the ending balance is more than the starting balance. Assume this was a mistake when calculating money spent.Author: Ahmad Varasteh Access the data directly from theknime hubhttps://hub.knime.com/ Data preparation and wrangling Analysing data 1)+---------------+---------+--------------------+----------------+| participantId | purpose | spend | date&time diff |+---------------+---------+--------------------+----------------+| 798 | Eating | 17.339568456453435 | 45 || 825 | Eating | 17.339568456453435 | 45 || 847 | Eating | 17.339568456453435 | 45 || 380 | Eating | 17.37920361239094 | 45 || 887 | Eating | 17.339568456453435 | 45 || 406 | Eating | 17.37920361239094 | 45 || 603 | Eating | 18.159703366429312 | 65 || 621 | Eating | 19.682806625251487 | 65 || 117 | Eating | 309.08146046076786 | 40 || 860 | Eating | 17.423635312293527 | 45 |+---------------+---------+--------------------+----------------+ 2)+---------------+---------+--------------------+----------------+| participantId | purpose | spend | date&time diff |+---------------+---------+--------------------+----------------+| 603 | Eating | 18.159703366429312 | 65 || 621 | Eating | 19.682806625251487 | 65 |+---------------+---------+--------------------+----------------+ readeating_out.csvfrom hubcalcmoney spendgroup perparticipant andpurposefilterEatingtop 10moneyspenderscalctime spendformatdate typestop 10timespendersfind overlapof participants CSV Reader Column Expressions GroupBy Row Filter Top k Selector Date&TimeDifference Table Manipulator Top k Selector Joiner Challenge 21: Eating OutLevel: EasyDescription: You 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:Find the top 10 participants spending the highest amount of money on eating.Find out whether the people who spend the most money on eating are the same people who spend the most time eating.Note: Sometimes the ending balance is more than the starting balance. Assume this was a mistake when calculating money spent.Author: Ahmad Varasteh Access the data directly from theknime hubhttps://hub.knime.com/ Data preparation and wrangling Analysing data 1)+---------------+---------+--------------------+----------------+| participantId | purpose | spend | date&time diff |+---------------+---------+--------------------+----------------+| 798 | Eating | 17.339568456453435 | 45 || 825 | Eating | 17.339568456453435 | 45 || 847 | Eating | 17.339568456453435 | 45 || 380 | Eating | 17.37920361239094 | 45 || 887 | Eating | 17.339568456453435 | 45 || 406 | Eating | 17.37920361239094 | 45 || 603 | Eating | 18.159703366429312 | 65 || 621 | Eating | 19.682806625251487 | 65 || 117 | Eating | 309.08146046076786 | 40 || 860 | Eating | 17.423635312293527 | 45 |+---------------+---------+--------------------+----------------+ 2)+---------------+---------+--------------------+----------------+| participantId | purpose | spend | date&time diff |+---------------+---------+--------------------+----------------+| 603 | Eating | 18.159703366429312 | 65 || 621 | Eating | 19.682806625251487 | 65 |+---------------+---------+--------------------+----------------+ readeating_out.csvfrom hubcalcmoney spendgroup perparticipant andpurposefilterEatingtop 10moneyspenderscalctime spendformatdate typestop 10timespendersfind overlapof participants CSV Reader Column Expressions GroupBy Row Filter Top k Selector Date&TimeDifference Table Manipulator Top k Selector Joiner

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: MMU
Created at: 2022-06-15
On NodePit since: 2022-06-16
Last update: 2024-04-27
Created with KNIME version: v4.5.2
Tags: justknimeitjustknimeit-21

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

Try NodePit Runner!