Date_diff different rows
New Altair Community Member
Updated by Jocelyn
Hello rapidminer community,
i am looking for a way to use the date_diff function in the generate attributes operator for two different rows. I have data for products with an ongoing time stamp and want to generate a new column that shows the difference between the timestap of row x and row x-1
for example
1 16:11; 00:00
2 16:14; 00:03
3 16:30; 00:16
4 16:52; 00:22
any help is appreciated. thank you very much!
Find more posts tagged with
Sort by:
1 - 2 of
21
New Altair Community Member
OPThanks Thomas, your proposed solution works just fine,
have a nice day!
Sort by:
1 - 1 of
11
New Altair Community Member
Accepted Answer
@christian_feise check out the Lag operator in the Value Series extension. You can create a second attribute column by lagging the first column, then use a Generate Attributes operator by doing date_diff(attribute1,attribute2)
@christian_feise check out the Lag operator in the Value Series extension. You can create a second attribute column by lagging the first column, then use a Generate Attributes operator by doing date_diff(attribute1,attribute2)