Extract hourly data from 15 min interval dataset
![sasidharp](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar5.png)
sasidharp
Registered Posts: 27 ✭✭✭✭
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 :
Answers
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
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/