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