Icon

Challenge 4 - Days With Price Changes(2)

Challenge 4 - Days With Price Changes
Challenge 4 - Days with price changesYou are using KNIME to monitor the daily price of a product online. After using the Line Plot node to visualize the daily prices you have alreadygathered, you notice that they are often constant for a certain number of days before changing again. You want to create a new column in theprice data you have at hand, named "Change", such that its value is 1 if a daily price changed with respect to the previous day, or 0 if itremained unchanged. For the first daily price in the data, the "Change" value should be 1. As an example, 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 Silvestri (https://hub.knime.com/emilio_s)Dataset: Daily Prices in the KNIME Hub (https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%204%20-%20Dataset~X8vqcbhabggq6AtD/) daily pricesadd a columnwith yesterday's valuemaking sure seriesis order by datespopulate changewith 1 if today priceis not equal yesterday'sclean CSV Reader Lag Column Sorter Rule Engine Column Filter Challenge 4 - Days with price changesYou are using KNIME to monitor the daily price of a product online. After using the Line Plot node to visualize the daily prices you have alreadygathered, you notice that they are often constant for a certain number of days before changing again. You want to create a new column in theprice data you have at hand, named "Change", such that its value is 1 if a daily price changed with respect to the previous day, or 0 if itremained unchanged. For the first daily price in the data, the "Change" value should be 1. As an example, 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 Silvestri (https://hub.knime.com/emilio_s)Dataset: Daily Prices in the KNIME Hub (https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%204%20-%20Dataset~X8vqcbhabggq6AtD/) daily pricesadd a columnwith yesterday's valuemaking sure seriesis order by datespopulate changewith 1 if today priceis not equal yesterday'sclean CSV Reader Lag Column Sorter 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: TAREK.CD
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 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!