RAPIDMINER 9.7 BETA ANNOUNCEMENT

The beta program for the RapidMiner 9.7 release is now available. Lots of amazing new improvements including true version control!

CLICK HERE TO DOWNLOAD

Identifying the First value of an attribute

swamysantoshkumarswamysantoshkumar Member Posts: 3 Newbie
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 Moderator, RapidMiner Certified Analyst, Member Posts: 1,047   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 Newbie
    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 Moderator, RapidMiner Certified Analyst, Member Posts: 1,047   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 Moderator, RapidMiner Certified Analyst, Member Posts: 1,047   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
    swamysantoshkumar
  • swamysantoshkumarswamysantoshkumar Member Posts: 3 Newbie
    @lionelderkrikor

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

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

    Good luck for your study ! 

    Regards,

    Lionel
Sign In or Register to comment.