Options

Date_diff different rows

christian_feisechristian_feise Member Posts: 5 Contributor I
edited November 2018 in Help

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

  • Options
    Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn
    Solution Accepted

    @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

  • Options
    christian_feisechristian_feise Member Posts: 5 Contributor I

    Thanks Thomas, your proposed solution works just fine,

    have a nice day!

Sign In or Register to comment.