Icon

justKnimeit-21

justKnimeit-21
Challenge 21: Eating OutDescription: 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 datasetwith 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. read eating_out.csvconvert checkincheckout to DateTimeCalculateremaning balancegroup by balanceCalculatedurationgroup by durationTop 10 participantshighest spendingTop 10 participantshighest time consumedParticipants both highestspending and time consumed CSV Reader String to Date&Time Math Formula GroupBy Date&TimeDifference GroupBy Top k Selector Top k Selector Joiner Challenge 21: Eating OutDescription: 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 datasetwith 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. read eating_out.csvconvert checkincheckout to DateTimeCalculateremaning balancegroup by balanceCalculatedurationgroup by durationTop 10 participantshighest spendingTop 10 participantshighest time consumedParticipants both highestspending and time consumed CSV Reader String to Date&Time Math Formula GroupBy Date&TimeDifference GroupBy Top k Selector Top k Selector Joiner

Nodes

Extensions

Links