Date_diff different rows

christian_feise
christian_feise New Altair Community Member
edited November 2024 in Community Q&A

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!

Tagged:

Best Answer

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    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)

Answers

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    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
    christian_feise New Altair Community Member

    Thanks Thomas, your proposed solution works just fine,

    have a nice day!

Categories