Icon

justknimeit-36

justknimeit-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 in this challenge. Checkout 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 the data, and irregulargaps. For example, daily stock market data regularly skips Saturdays and Sundays, and irregularly skips some other weekdays due to publicholidays. Your concrete task for this challenge is to introduce the missing timestamps that correspond to weekdays into the given data, whileomitting those for weekends. The data contains the daily exchange rates of US dollar vs Swiss franc from 1980 to 1998. Hint: Check out our verifiedcomponents for time series analysis. Hint 2: For reference, if you get access to the book, check out Chapter 3 (Preparing Data for Time SeriesAnalysis) which this challenge is based on.Author: Maarit Widmann ReadHistoricalDataConvert toDate formatCreate CompleteTime SeriesExtract Day ofWeek (name)Missing Value= Previous ValueRemoveSat & SunPlot ExchangeRatesOBS toDate (OBS)Export toSVG CSV Reader String to Date&Time Timestamp Alignment Extract Date&TimeFields Missing Value Rule-basedRow Filter Line Plot Column Rename Image Writer (Port) 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. Checkout 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 the data, and irregulargaps. For example, daily stock market data regularly skips Saturdays and Sundays, and irregularly skips some other weekdays due to publicholidays. Your concrete task for this challenge is to introduce the missing timestamps that correspond to weekdays into the given data, whileomitting those for weekends. The data contains the daily exchange rates of US dollar vs Swiss franc from 1980 to 1998. Hint: Check out our verifiedcomponents for time series analysis. Hint 2: For reference, if you get access to the book, check out Chapter 3 (Preparing Data for Time SeriesAnalysis) which this challenge is based on.Author: Maarit Widmann ReadHistoricalDataConvert toDate formatCreate CompleteTime SeriesExtract Day ofWeek (name)Missing Value= Previous ValueRemoveSat & SunPlot ExchangeRatesOBS toDate (OBS)Export toSVG CSV Reader String to Date&Time Timestamp Alignment Extract Date&TimeFields Missing Value Rule-basedRow Filter Line Plot Column Rename Image Writer (Port)

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: UserID
Created at: 2022-10-02
On NodePit since: 2022-10-02
Last update: 2024-04-28
Created with KNIME version: v4.6.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!