Icon

10_​Lag_​Column - Solution

10_Lag_Column - Solution
Exercise Lag Column1) Read data clustered hourly_values_all.csv2) Replace the row ID values in the dataset with the values in the “row ID” column3) Transform the “row ID” column into a Date&Time type, and append these values as a new column inthe dataset4) Sort the data in ascending order according to the column of type Date&Time5) Filter the data to only include one of the clustered time series6) Use the Lag Column node to build the vector of 10 past samples for each time, t7) Plot the time series and the past 10 samples for each time, t Read dataclustered_hourly_values_all.csvReplace Row IDsConvert the "rowID" columnto Date&Time formatSort data accordingto Date&Time columnKeep only onecluster columnGet 10 past samplesfor each timePlot time seriesand samples File Reader RowID String to Date&Time Sorter Column Filter Lag Column Line Plot Exercise Lag Column1) Read data clustered hourly_values_all.csv2) Replace the row ID values in the dataset with the values in the “row ID” column3) Transform the “row ID” column into a Date&Time type, and append these values as a new column inthe dataset4) Sort the data in ascending order according to the column of type Date&Time5) Filter the data to only include one of the clustered time series6) Use the Lag Column node to build the vector of 10 past samples for each time, t7) Plot the time series and the past 10 samples for each time, t Read dataclustered_hourly_values_all.csvReplace Row IDsConvert the "rowID" columnto Date&Time formatSort data accordingto Date&Time columnKeep only onecluster columnGet 10 past samplesfor each timePlot time seriesand samples File Reader RowID String to Date&Time Sorter Column Filter Lag Column Line Plot

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: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2021-03-30
Last update: 2024-11-21
Created with KNIME version: v4.1.3
Tags: e-learningtime serieslag columneducation

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

Try NodePit Runner!