Icon

justknimeit-4_​Victor

Description: You 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 already gathered,you notice that they are often constant for a certain number of days before changing again. You want to create a new column in the price data you haveat hand, named "Change", such that its value is 1 if a daily price changed with respect to the previous day, or 0 if it remained unchanged. For the firstdaily 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 1 Data available at : https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%204%20-%20Dataset~X8vqcbhabggq6AtD/ Readdaily_prices.csvVisualizationprices vs. timeConvert stringto date&timeLag column"Price"Compare"Price" with "Price(-1)"and create column "Change"Considermissing first row "Price" as 0Deletecolumn"Price(-1)" CSV Reader Line Plot String to Date&Time Lag Column Math Formula Missing Value Column Filter Description: You 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 already gathered,you notice that they are often constant for a certain number of days before changing again. You want to create a new column in the price data you haveat hand, named "Change", such that its value is 1 if a daily price changed with respect to the previous day, or 0 if it remained unchanged. For the firstdaily 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 1 Data available at : https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%204%20-%20Dataset~X8vqcbhabggq6AtD/ Readdaily_prices.csvVisualizationprices vs. timeConvert stringto date&timeLag column"Price"Compare"Price" with "Price(-1)"and create column "Change"Considermissing first row "Price" as 0Deletecolumn"Price(-1)" CSV Reader Line Plot String to Date&Time Lag Column Math Formula Missing Value 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: victo
Created at: 2022-02-17
On NodePit since: 2022-02-18
Last update: 2024-05-02
Created with KNIME version: v4.5.1

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

Try NodePit Runner!