Time series for runtime
HValderrama
Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 4 ✭
I have a downtime dataset with assets, downtime start, and downtime end. I want to create a recipe in Dataiku without using Python to create a time series with the downtime and run time. 1 for downtime and 0 for running.
Here is an example of the data set:
Asset | downtime_start | downtime_end | status |
123 | 01/15/23 11:00 am | 01/15/23 1:00 pm | 1 |
123 | 01/15/23 1:45 pm | 01/15/23 3:00 pm | 1 |
123 | 02/01/23 6:20 am | 02/03/23 4:00 pm | 1 |
789 | 01/01/23 7:48 pm | 01/02/23 7:49 pm | 1 |
I want the time series to start on the first downtime on 01/01/23 and keep until the last downtime on 02/03/23. Fill in the values for each asset for the date and time it was running with 0 in the Status.
Operating system used: Windows
Tagged:
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,978 Neuron
Why can't it be done in Python? Where is this dataset stored on? (ie which technology).
-
HValderrama Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 4 ✭
The preference is to use the Dataiku Recipe and not code in Python. Data is stored on an SQL database Azure Synapse.