🎉 🎉. RAPIDMINER 9.8 IS OUT!!! 🎉 🎉

RapidMiner 9.8 continues to innovate in data science collaboration, connectivity and governance

CLICK HERE TO DOWNLOAD

Make time intervals in dataset

ChimamamChimamam Member Posts: 2 Learner I
edited March 29 in Help
How can one get time intervals of say like 10 mins or 15 mins from our dataset that contains date-time of the entire day in the format dd/mm/yy h:m
e.g 1/04/2019 7.02 
1/04/2019 7.12
1/04/2019 7.23
1/04/2019 7.18
1/04/2019 7.36
1/04/2019 7.43
1/04/2019 7.29
1/04/2019 7.56
.
.
.
.
.
.
.
So on.......
I want to divide this datasets in intervals of 15 mins like 7.00-7.15, 7.15-7.30, 7.30-7.45, 7.45-8.00

Thanks

Answers

  • MPB_MPB_ Member Posts: 45  Guru
    Hey @Chimamam,

    I am pretty sure that this is not the most efficient way to solve this, but for now, this is my only idea.

    I would :

    1. Divide Date and Time into two separat columns (You will find a suitable function in the operator "Generate Attributes" , but you may need to convert the datatypes first)

    2. I would create a function for every 15-minute-intervall [This will take some effort. You have 4 intervalls for every hour which makes 4*24= 96 functions. But it is mostly copy and paste]

    3. Merge Intervall and Date. [Also via Generate Attributes]

    4. Select Attributes for cleaning


  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,761  RM Data Scientist
    Hi,
    9.6 has an operator called Equalize Timestamps (or so?) which does this for you.

    Best,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
    sgenzer
  • ChimamamChimamam Member Posts: 2 Learner I
    @mschmitz
    I am still not able to do that there is an error as shown in the image below I am also attaching the datasets below hope it helps.
  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,761  RM Data Scientist
    Hi,
    what is the question on the error message? it is very specific? I recommend to sort before Equalize Time Stamps.

    Best,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.