Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

how to use loop in Rapidminer

sgnarkhede2016

Hello,
I have below Data,
I want to check first value with all below values and vice versa is greter or not and put True or False flag in check column

1
Sr A Check
1 12
2 5 True
3 8 True

2
Sr A Check
1 12 False
2 5
3 8    False

3
Sr A Check
1 12 false
2 5 true
3 8

How can i do this

Find more posts tagged with

AI Studio

Loops + Branches

Accepted answers

All comments

BalazsBaranyRM

Hi,

is this one example set? Or three different ones? In which form do you have them?

If you have one table and want to change the Check column, you don't need a loop. Just Generate Attributes with something like this:

A > Sr
(this will automatically return true or false)

I hope I understand you correctly. If not, please answer the questions and specify what the Check logic should be.

Regards,

Balázs

sgnarkhede2016

this is single table but how can i check iterative ways
like first time i need to check with "1" with 2,3 and then "2" check with 1,3 etc

sgnarkhede2016

I want to use multiple for loop in rapidminer as i used in python

for yr in yr_df['sic'].unique().tolist():

sic_df=yr_df[yr_df['sic']==yr]

for index_1,i in sic_df.iterrows():

for index_2,j in sic_df.iterrows():

if i['name']!=j['name']:

if i['RevenueTotalR']>=j['below_percnt'] and i['RevenueTotalR']<=j['above_percnt']:

print(i['name'],'==',j['name'])

print(index_1)

i['peer_name']=j['name']