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.

Separating Column Values on Percentage Basis

P2017000971P2017000971 Member Posts: 8 Learner III
in Help
Hello to every one,

thanks For Taking the Time to look into my Question

I will Explain the issue using some examples for better clarification

NO Product Price
1 593
2 623
3 1880
4 2811
5 1208
6 3403
7 2300
8 2406
9 2729
10 2500
Let us Assume we have the Previous Two Columns (i.e. NO and Product Price)
I want to separate their values based on 50% basis of overall values in column
in this Example we have 10 values so the aim is to make it like this :
First Output 
NO Product Price
1 593
2 623
3 1880
4 2811
5 1208

Second Output 
NO Product Price
6 3403
7 2300
8 2406
9 2729
10 2500
If there is way to generate two different outputs, it is good
Also if there was a way to select a portion depending on my preference that is even better.

Answers

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

    Here a process (in attached file) that performs what you want to do (based on your example)

    Regards,

    Lionel
  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    You can do this pretty easily with Filter Example Range as well, if you know in advance how many records there are and how many you want in each partition.
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.