Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

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,527 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,527 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.