Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Identifying the First value of an attribute

swamysantoshkumarswamysantoshkumar Member Posts: 3 Learner I
in Help
Could some one please let me know 
1. How can we identify the first value of an attribute ?
2. How do we identify the first value of an attribute based on grouping ?
3. How do we create a new attribute with first value assigned based on grouping of other attributes ?

Answers

  • lionelderkrikorlionelderkrikor RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    Hi @swamysantoshkumar,

    To identify the first value of an attribute, you can use the Filter Example Range operator and set
    first example = 1
    last example = 1

    For you questions 2. and 3. I have difficulties to understand : 
    Can you provide : 
     -  an example of what you have and 
     - an example of what you want to obtain

    Regards,

    Lionel
  • swamysantoshkumarswamysantoshkumar Member Posts: 3 Learner I
    Thanks for the response @Lionelderkrikor 

    Below is the example in which I would need attributes 3 & 4 to be created from Attributes 1 & 2

    1. How do we identify the first value of an attribute and assign it as new attribute for all examples
    2. How do we identify the first value of an attribute specific to a group of examples 
    3. How do we create the new attribute by assigning the first value identified in step 2

    I would like to generate Attribute 3 and 4 as depicted in the below table

    Ex:
    Attribute 1    Attribute 2   Attribute 3    Attribute 4
    A                     10                10                10
    A                      20               10                10
    A                      25               10                10
    A                      40               10                10
    B                      30               10                30
    B                      40               10                30
    C                      50               10                50
    C                      60               10                50


  • lionelderkrikorlionelderkrikor RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    @swamysantoshkumar,

    In attached file, a process to generate your att_3 based on att_1 and att_2.
    For your second request (generate att_4) I need a little time of reflexion ...

    Stay tuned ! 

    Regards,

    Lionel
  • lionelderkrikorlionelderkrikor RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    @swamysantoshkumar

    .....and here, in attached file, the final process (including generation of attribute 4) which use Group into Collection / Loop Collection operators

    Does this process answer to your need ?

    Regards,

    Lionel
  • swamysantoshkumarswamysantoshkumar Member Posts: 3 Learner I
    @lionelderkrikor

    Thank you so much ! Yes it really helps. This is what I was looking for.

    Thanks again..
    Santosh !
  • lionelderkrikorlionelderkrikor RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    You're welcome, @swamysantoshkumar.

    Good luck for your study ! 

    Regards,

    Lionel
Sign In or Register to comment.