Make time intervals in dataset

Chimamam

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

MPB_

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

MartinLiebig

Hi,
9.6 has an operator called Equalize Timestamps (or so?) which does this for you.

Best,
Martin

Chimamam

@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.

MartinLiebig

Hi,
what is the question on the error message? it is very specific? I recommend to sort before Equalize Time Stamps.

Best,
Martin