Icon

01_​DateTime_​Manipulation

01_DateTime_Manipulation
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? CSV 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? CSV 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: 2022-03-12
Last update: 2024-11-17
Created with KNIME version: v4.5.1
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!