Options
Operator Question
Newbie
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!
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!
0
Best Answer
-
Options
varunm1
Moderator, Member Posts: 1,207 
Unicorn
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>
Regards,
Varun
https://www.varunmandalapu.com/Be Safe. Follow precautions and Maintain Social Distancing
5
Answers
Dortmund, Germany