Icon

justknimeit-36 - Implementing Custom Time Alignment

justknimeit-36 - Implementing Custom Time Alignment
Challenge 36: Implementing Custom Time AlignmentLevel: MediumDescription: KNIME has just released a new textbook on time series: to celebrate it, we will do a little time series analysis in this challenge. Check out the book (and discount!) here.For this challenge you will perform time alignment on data that contains two types of gaps: regular gaps by thenature of the data, and irregular gaps. For example, daily stock market data regularly skips Saturdays andSundays, and irregularly skips some other weekdays due to public holidays. Your concrete task for thischallenge is to introduce the missing timestamps that correspond to weekdays into the given data, while omittingthose for 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 series analysis. Hint 2: For reference, if you get access to thebook, check out Chapter 3 (Preparing Data for Time Series Analysis) which this challenge is based on. Reads the file of exchange rateConverts string to dateCreates missing values on dates which are not includedConverts date to days of the weekFilters out Saturday and SundayReplace missing value with the previous day's rate CSV Reader String to Date&Time Timestamp Alignment Extract Date&TimeFields Row Filter Missing Value Challenge 36: Implementing Custom Time AlignmentLevel: MediumDescription: KNIME has just released a new textbook on time series: to celebrate it, we will do a little time series analysis in this challenge. Check out the book (and discount!) here.For this challenge you will perform time alignment on data that contains two types of gaps: regular gaps by thenature of the data, and irregular gaps. For example, daily stock market data regularly skips Saturdays andSundays, and irregularly skips some other weekdays due to public holidays. Your concrete task for thischallenge is to introduce the missing timestamps that correspond to weekdays into the given data, while omittingthose for 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 series analysis. Hint 2: For reference, if you get access to thebook, check out Chapter 3 (Preparing Data for Time Series Analysis) which this challenge is based on. Reads the file of exchange rateConverts string to dateCreates missing values on dates which are not includedConverts date to days of the weekFilters out Saturday and SundayReplace missing value with the previous day's rate CSV Reader String to Date&Time Timestamp Alignment Extract Date&TimeFields Row Filter Missing Value

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: astl3
Created at: 2022-09-28
On NodePit since: 2022-09-29
Last update: 2024-04-28
Created with KNIME version: v4.6.2
Tags: justknimeit-36time seriesmissing valuetimestamp alignmentjust knime itjustknimeit

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

Try NodePit Runner!