How can I delete every rows which have a specific attribute?

dr_mirzaiee
dr_mirzaiee New Altair Community Member
edited November 2024 in Community Q&A
I have sorted my data list by its "codes".  How can I request from Rapidminer to delete every rows which have code the same as next row?

Tagged:

Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Hi,

    using the Windowing operator you can access the value in the previous row. By sorting the data in the reverse order, the previous row becomes the next row. Then you can use Generate Attributes to check for equality, or even Filter Examples.

    Regards,

    Balázs
  • sgenzer
    sgenzer
    Altair Employee
    of course agree with @BalazsBarany. My usual technique is similar but I use the Lag operator to "shift" all the rows by one.

    Scott

  • dr_mirzaiee
    dr_mirzaiee New Altair Community Member
    edited January 2020
    I want using only operators with arrows, instead of doing by hand. Please explain more, with an example, if it is possible (I am a bigining user).
  • sgenzer
    sgenzer
    Altair Employee
    hi @dr_mirzaiee did you take the time to read the blue window that was on the "Ask a Question" page, and read the article that is linked? It explains very clearly how to share processes with others on this community. This is important - I strongly recommend you read and understand so you can get the most help from us.



    Scott

Categories