Sort by data contained in columns

User222697
User222697 New Altair Community Member
edited November 2024 in Community Q&A

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

Tagged:

Best Answer

  • kypexin
    kypexin New Altair Community Member
    Answer ✓

    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

  • lionelderkrikor
    lionelderkrikor New Altair Community Member

    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

  • kypexin
    kypexin New Altair Community Member
    Answer ✓

    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? 

Categories