Icon

08. Date and Time Analysis

Date and Time Analysis
Activity I1) Read the file: meter_data.csv2) Use String Manipulation to construct a date/timestamp column from the individual date and time columns3) Convert the date/time stamp column to a KNIME timestamp with the String to Date&Time node4) Extract entries from January 2007 using the Date&Time-based Row Filter Activity II1) Read the file: sampled_meter_data.table2) Use Extract Date&Time Fields to pull out the Year, Day of Year, and Hour values from the timestamp3) Use GroupBy to calculate mean time and intensity by year, day, and hour4) Calculate a gaussian centered moving average for the intensity, and plot this data in a line plot5) Calculate the maximum of the intensity column for the preceding day (1440 minutes) Data CitationLichman, M. (2013). UCI Machine Learning Repository [http://archive.ics.uci.edu/ml]. Irvine, CA: University of California, School of Informationand Computer Science. File Reader Table Reader Activity I1) Read the file: meter_data.csv2) Use String Manipulation to construct a date/timestamp column from the individual date and time columns3) Convert the date/time stamp column to a KNIME timestamp with the String to Date&Time node4) Extract entries from January 2007 using the Date&Time-based Row Filter Activity II1) Read the file: sampled_meter_data.table2) Use Extract Date&Time Fields to pull out the Year, Day of Year, and Hour values from the timestamp3) Use GroupBy to calculate mean time and intensity by year, day, and hour4) Calculate a gaussian centered moving average for the intensity, and plot this data in a line plot5) Calculate the maximum of the intensity column for the preceding day (1440 minutes) Data CitationLichman, M. (2013). UCI Machine Learning Repository [http://archive.ics.uci.edu/ml]. Irvine, CA: University of California, School of Informationand Computer Science. File Reader Table Reader

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: knime
Created at: 2014-06-17
On NodePit since: 2019-08-19
Last update: 2020-03-23
Created with KNIME version: v4.0.0
Tags: Date&Timetime seriesmoving averagemoving aggregationgranularityeducation

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

Try NodePit Runner!