difference of values

sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
edited November 2018 in Help

OK I know there is an easy way to do this but cannot get my brain around it.  If I have an attribute that contains integers in ascending order but they are not sequential, how do I create a new attribute that shows the difference between each example and the one before it?  For example:

 

att1         delta

1             ?

3             2

4             1

5             1

17           12

20           3

 

etc..

 

Thanks.


Scott

Best Answer

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 RM Data Scientist
    Solution Accepted

    Scott,

     

    the Lag operator is your friend.

     

    Generally speaking: All operations which requiere cross-example operations are rather in the time series extension than in core.

     

    ~Martin

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany

Answers

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager

    Perfect.  Thank you Martin!


    Scott

     

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

    Try the lag operator!

Sign In or Register to comment.