Make time intervals in dataset

New Altair Community Member

Mar 29, 2020

Updated Nov 5, 2024 by Jocelyn

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

Find more posts tagged with

AI Studio

Sort by:

1 - 4 of 41

MPB_

New Altair Community Member

Mar 29, 2020

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