Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

Extract hourly data from 15 min interval dataset

Level 3
Extract hourly data from 15 min interval dataset

i am trying to extract hourly dataset from the data i have which consists of 15 min interval in it.

which recipe will be best to do so?

my data :

15 min data.PNG

0 Kudos
1 Reply
Neuron
Neuron

@sasidharp ,

There are a bunch of ways to try to do this. 

Using built-in features.  I'd take a look at the window and group by recipes. You will likely have to create a window key by rounding your timestamp to the nearest hour to do this.

You may also want to look at the Time Series Preparation Plugin.  This will have to be installed in your DSS instances before you can do this.  In particular, you may be interested in the resampling portion of this plugin.

The overview of the Time Series Preparation Plugin can be found here.

https://www.dataiku.com/product/plugins/timeseries-preparation/

--Tom
0 Kudos