Make time intervals in dataset

ChimamamChimamam Member Posts: 2 Learner I
edited March 2020 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


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

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • 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.
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 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
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.