Icon

Challenge 4 - Days With Price Changes

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 Date columnshifted by -1 daysconvert Date fielddata type to Dateadding yesterdaypricepopulate changewith 1 if today priceis not equal yesterday'sclean unnecessarycolumns CSV Reader Date&Time Shift String to Date&Time Joiner 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 Date columnshifted by -1 daysconvert Date fielddata type to Dateadding yesterdaypricepopulate changewith 1 if today priceis not equal yesterday'sclean unnecessarycolumns CSV Reader Date&Time Shift String to Date&Time Joiner Rule Engine Column Filter

Nodes

Extensions

Links