Icon

10_​DateTime_​Manipulation - Solution

10_DateTime_Manipulation - Solution
Exercise Date&Time Manipulation1) Read data daily_sales.csv available in the "data" folder2) Convert the order times from string to Date&Time. Replace the string column.3) Add the date “2019-09-03” to all time values. Create a new column called “order_time_date”.4) Extract the hours of the orders. Are there especially many orders occurring in a certain hour of the day? The maximum numberof orders occuredbetween 2 and 3 p.m. Read datadaily_sales.csvConvert theorder timesAppend the dateExtract the hoursof ordersNumber of ordersper hour File Reader String to Date&Time Modify Date Extract Date&TimeFields GroupBy Exercise Date&Time Manipulation1) Read data daily_sales.csv available in the "data" folder2) Convert the order times from string to Date&Time. Replace the string column.3) Add the date “2019-09-03” to all time values. Create a new column called “order_time_date”.4) Extract the hours of the orders. Are there especially many orders occurring in a certain hour of the day? The maximum numberof orders occuredbetween 2 and 3 p.m. Read datadaily_sales.csvConvert theorder timesAppend the dateExtract the hoursof ordersNumber of ordersper hour File Reader String to Date&Time Modify Date Extract Date&TimeFields GroupBy

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: 2020-08-06
Last update: 2024-11-21
Created with KNIME version: v4.1.2
Tags: e-learningdatetimegranularityeducation

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

Try NodePit Runner!