Operator Question

njay8

Hi,

I'm new to Rapidminer! I'm wondering if there is an operator that can remove rows when two columns have the same value? Or, if there is an operator that can filter to show only those rows where these two columns don't have the same value? 

Any help is appreciated, thank you!

varunm1

Hello @njay8

You donot need matching values between two attributes right? then you need to do as seen below. I also attached sample XML code below. You can check this process in your rapidminer.

<?xml version="1.0" encoding="UTF-8"?><process version="9.2.001">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="9.2.001" expanded="true" name="Process">
<parameter key="logverbosity" value="init"/>
<parameter key="random_seed" value="2001"/>
<parameter key="send_mail" value="never"/>
<parameter key="notification_email" value=""/>
<parameter key="process_duration_for_mail" value="30"/>
<parameter key="encoding" value="SYSTEM"/>
<process expanded="true">
<operator activated="true" class="retrieve" compatibility="9.2.001" expanded="true" height="68" name="Retrieve Polynomial" width="90" x="112" y="85">
<parameter key="repository_entry" value="//Samples/data/Polynomial"/>
</operator>
<operator activated="true" class="filter_examples" compatibility="9.2.001" expanded="true" height="103" name="Filter Examples" width="90" x="246" y="136">
<parameter key="parameter_expression" value="a2 == a5"/>
<parameter key="condition_class" value="expression"/>
<parameter key="invert_filter" value="true"/>
<list key="filters_list"/>
<parameter key="filters_logic_and" value="true"/>
<parameter key="filters_check_metadata" value="true"/>
</operator>
<connect from_op="Retrieve Polynomial" from_port="output" to_op="Filter Examples" to_port="example set input"/>
<connect from_op="Filter Examples" from_port="example set output" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>

MartinLiebig

Hi,

you can use Filter Examples and filter for

[attName1]==[attName2]

as an expression.

Best,

Martin

njay8

Thank you! I tried this operator, which makes complete sense, but for some reason it shows instantation error: not a valid format 

njay8

It worked! Thank you!!