Sort by data contained in columns

User222697User222697 Member Posts: 17 Contributor II
edited December 2018 in Help

Hi!

 

I have a set of data such that:

Memberof | Name | Surname | Points
SP Demo Demo 53
SP Demo1 .. Demo 51
SP ............................... 56
BM ............................... 49
BM ............................... 42
AX ............................... 11
GZ ................................ 22

Using the data in the "Points" column, I'm trying to get Rapidminer to classify the data into "Memberof" values.

Example of expected result:

> = 50 Points
SP
<50 Poinra
VM
AX
GZ

Do you know any basic tutorial or model to learn how to do it? My idea is to later use the "AutoModel" functionality.

Thank you very much

Best Answer

  • kypexinkypexin Moderator, RapidMiner Certified Analyst, Member Posts: 291 Unicorn
    Solution Accepted

    Hi @User222697

     

    Couple of questions without even seeing your data: 

     

    1. Do you want your predictive model to distinguish only between 'SP' and 'all others', or you need to predict the precise 'memberof' value? In the second case, how many distinct values are there in this column?  
    2. What's the magnitude of 'points' variable - maximum and minimum values? 

Answers

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

    Hi @User222697,

     

    I have difficulties to understand : 

    Can you post your dataset (or a screenshot of your dataset) and explain more explicity in which form you wish to obtain the results.

     

    Regards,

     

    Lionel

Sign In or Register to comment.