Icon

jKi-36

jKi-36
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 inthis 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 the nature of thedata, and irregular gaps. For example, daily stock market data regularly skips Saturdays and Sundays, and irregularly skipssome other weekdays due to public holidays. Your concrete task for this challenge is to introduce the missing timestampsthat correspond to weekdays into the given data, while omitting those for weekends. The data contains the daily exchangerates 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 the book, check out Chapter 3 (Preparing Data for Time Series Analysis) which thischallenge is based on. Node 1Node 2add missing exchange ratevalueextractweekdayremoveweekends CSV Reader String to Date&Time Timestamp Alignment Missing Value Extract Date&TimeFields Row Filter 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 inthis 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 the nature of thedata, and irregular gaps. For example, daily stock market data regularly skips Saturdays and Sundays, and irregularly skipssome other weekdays due to public holidays. Your concrete task for this challenge is to introduce the missing timestampsthat correspond to weekdays into the given data, while omitting those for weekends. The data contains the daily exchangerates 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 the book, check out Chapter 3 (Preparing Data for Time Series Analysis) which thischallenge is based on. Node 1Node 2add missing exchange ratevalueextractweekdayremoveweekendsCSV Reader String to Date&Time Timestamp Alignment Missing Value Extract Date&TimeFields Row 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: franz
Created at: 2022-10-01
On NodePit since: 2022-10-02
Last update: 2024-04-27
Created with KNIME version: v4.6.3
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!