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