Icon

challenge 20220216

challenge 20220216
Description: You are using KNIME to monitor the daily price of a product online. After usingthe Line Plot node to visualize the daily prices you have already gathered, you notice thatthey are often constant for a certain number of days before changing again. You want tocreate a new column in the price data you have at hand, named "Change", such that itsvalue is 1 if a daily price changed with respect to the previous day, or 0 if it remainedunchanged. For the first daily price in the data, the "Change" value should be 1. As anexample, if the initial daily prices look like:Date Price2015-01-01 102015-01-02 102015-01-03 11You should end up with data in the following format:Date Price Change2015-01-01 10 12015-01-02 10 02015-01-03 11 1Author: Emilio SilvestriDataset: Daily Prices in the KNIME HubOur solution will appear here next Tuesday. In the meantime, feel free to discuss your workon the KNIME forum or on social media using the hashtag #justknimeit.Remember to upload your solution with tag justknimeit-4 to your public space on the KNIMEHub. To increase the visibility of your solution, also post it to this challenge thread on theKNIME forum. read filecollect previousrow pricedoes the previous rowprice match thecurrent row price?remove unwantedcolumns CSV Reader Lag Column Rule Engine Column Filter Description: You are using KNIME to monitor the daily price of a product online. After usingthe Line Plot node to visualize the daily prices you have already gathered, you notice thatthey are often constant for a certain number of days before changing again. You want tocreate a new column in the price data you have at hand, named "Change", such that itsvalue is 1 if a daily price changed with respect to the previous day, or 0 if it remainedunchanged. For the first daily price in the data, the "Change" value should be 1. As anexample, if the initial daily prices look like:Date Price2015-01-01 102015-01-02 102015-01-03 11You should end up with data in the following format:Date Price Change2015-01-01 10 12015-01-02 10 02015-01-03 11 1Author: Emilio SilvestriDataset: Daily Prices in the KNIME HubOur solution will appear here next Tuesday. In the meantime, feel free to discuss your workon the KNIME forum or on social media using the hashtag #justknimeit.Remember to upload your solution with tag justknimeit-4 to your public space on the KNIMEHub. To increase the visibility of your solution, also post it to this challenge thread on theKNIME forum. read filecollect previousrow pricedoes the previous rowprice match thecurrent row price?remove unwantedcolumns CSV Reader Lag Column Rule Engine Column 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: Alex Martin
Created at: 2022-02-17
On NodePit since: 2022-02-18
Last update: 2024-05-05
Created with KNIME version: v4.5.1
Tags: justknimeit-4

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

Try NodePit Runner!