Time series for runtime

Options
HValderrama
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:

Assetdowntime_startdowntime_endstatus
12301/15/23 11:00 am01/15/23 1:00 pm1
12301/15/23 1:45 pm01/15/23 3:00 pm1
12302/01/23 6:20 am02/03/23 4:00 pm1
78901/01/23 7:48 pm01/02/23 7:49 pm1

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
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,757 Neuron
    Options

    Why can't it be done in Python? Where is this dataset stored on? (ie which technology).

  • HValderrama
    HValderrama Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 4
    Options

    The preference is to use the Dataiku Recipe and not code in Python. Data is stored on an SQL database Azure Synapse.

Setup Info
    Tags
      Help me…