Icon

Challenge 36 - Implementing Custom Time Alignment

Challenge 36 - Implementing Custom Time Alignment
Challenge 36 : Implementing Custom Time Alignment Description: For this challenge you will perform time alignment on data that contains two types of gaps: regular gaps by the nature of the data, andirregular gaps. For example, daily stock market data regularly skips Saturdays and Sundays, and irregularly skips some other weekdays due to public holidays. Your concrete task for this challenge is to introduce the missing timestamps that correspond to weekdays into the given data, while omitting thosefor weekends. The data contains the daily exchange rates of US dollar vs Swiss franc from 1980 to 1998. Hint: Check out our verified components for time seriesanalysis. Hint 2: For reference, if you get access to the book, check out Chapter 3 (Preparing Data for Time Series Analysis) which this challenge isbased on. READ DATA CREATE NEW DATE RANGE Read Daily DataString Dateto TimeExtract DatesMin & MaxMin & Max Dates to VarCreate DateRangeAdd CompelteDate RangeSort Desc byNew DateExtract dayoF WeekExcludeWeekendsCSV Reader String to Date&Time GroupBy Table Rowto Variable Create Date&TimeRange Joiner Sorter Extract Date&TimeFields Rule-basedRow Filter Challenge 36 : Implementing Custom Time Alignment Description: For this challenge you will perform time alignment on data that contains two types of gaps: regular gaps by the nature of the data, andirregular gaps. For example, daily stock market data regularly skips Saturdays and Sundays, and irregularly skips some other weekdays due to public holidays. Your concrete task for this challenge is to introduce the missing timestamps that correspond to weekdays into the given data, while omitting thosefor weekends. The data contains the daily exchange rates of US dollar vs Swiss franc from 1980 to 1998. Hint: Check out our verified components for time seriesanalysis. Hint 2: For reference, if you get access to the book, check out Chapter 3 (Preparing Data for Time Series Analysis) which this challenge isbased on. READ DATA CREATE NEW DATE RANGE Read Daily DataString Dateto TimeExtract DatesMin & MaxMin & Max Dates to VarCreate DateRangeAdd CompelteDate RangeSort Desc byNew DateExtract dayoF WeekExcludeWeekendsCSV Reader String to Date&Time GroupBy Table Rowto Variable Create Date&TimeRange Joiner Sorter Extract Date&TimeFields Rule-basedRow Filter

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: USER
Created at: 2022-09-28
On NodePit since: 2022-09-29
Last update: 2024-05-03
Created with KNIME version: v4.5.0
Tags: justknimeit-36

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

Try NodePit Runner!