Icon

EatingOut

Eating Out

Description: 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 containing information 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.

Note: Sometimes the ending balance is more than the starting balance. Assume this was a mistake when calculating money spent.

There can be several persons with the value at position 10. Thesection determines the value at position 10 and adds more personswith this value if necessary. eatingCostspurpose = EatingANDeatingOut > 0eatingTimein minutessumseatingCostsTop 10+ participantsby eatingCosts (SUM)eatingTimeandeatingCostsTop 10+ participantsby eatingTime (SUM)Row10Top10eatingCostslower boundRow10Top10eatingTimelower bound CSV Reader Math Formula Rule-basedRow Filter Date&TimeDifference GroupBy Sorter Row Filter Sorter Row Filter Row Filter Table Rowto Variable Row Filter Table Rowto Variable Visualisation There can be several persons with the value at position 10. Thesection determines the value at position 10 and adds more personswith this value if necessary. eatingCostspurpose = EatingANDeatingOut > 0eatingTimein minutessumseatingCostsTop 10+ participantsby eatingCosts (SUM)eatingTimeandeatingCostsTop 10+ participantsby eatingTime (SUM)Row10Top10eatingCostslower boundRow10Top10eatingTimelower boundCSV Reader Math Formula Rule-basedRow Filter Date&TimeDifference GroupBy Sorter Row Filter Sorter Row Filter Row Filter Table Rowto Variable Row Filter Table Rowto Variable Visualisation

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: stan
Created at: 2022-06-15
On NodePit since: 2022-06-17
Last update: 2024-11-17
Created with KNIME version: v4.6.0
Tags: justknimeit-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!