Options

Replace missing value is not working

mansourmansour Member Posts: 26 Contributor II
Dear All,
I am running the following process, I have already added three replace missing operators, but still I receive the error of weight by information gain and other weight operators cannot handle missing values.
Any thoughts?
<?xml version="1.0" encoding="UTF-8"?><process version="10.1.003">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="10.1.003" expanded="true" name="Process" origin="GENERATED_TUTORIAL">
<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="10.1.003" expanded="true" height="68" name="Retrieve Quartiled All data" width="90" x="45" y="85">
<parameter key="repository_entry" value="Quartiled All data"/>
</operator>
<operator activated="true" breakpoints="after" class="blending:set_role" compatibility="10.1.003" expanded="true" height="82" name="Set Role (2)" origin="GENERATED_TUTORIAL" width="90" x="179" y="85">
<list key="set_roles">
<parameter key="Hardness Bite 1 (N)" value="label"/>
<parameter key="Hardness Bite 2 (N)" value="label"/>
<parameter key="Adhesive Force (N)" value="label"/>
<parameter key="Cohesiveness" value="label"/>
<parameter key="Gumminess (N)" value="label"/>
<parameter key="Springiness (mm)" value="label"/>
<parameter key="Chewiness (N)" value="label"/>
<parameter key="Resilience" value="label"/>
<parameter key="gas amount (mol/g)" value="label"/>
<parameter key="baking loss" value="label"/>
<parameter key="Crust Colour a*" value="label"/>
<parameter key="Crust Colour b*" value="label"/>
<parameter key="Crust Colour L*" value="label"/>
<parameter key="Crust ^E*" value="label"/>
<parameter key="Crumb ^E*" value="label"/>
<parameter key="Crumb Colour a*" value="label"/>
<parameter key="Crumb Colour b*" value="label"/>
<parameter key="Crumb Colour L*" value="label"/>
<parameter key="void_fraction" value="label"/>
<parameter key="mean_area_mm2" value="label"/>
<parameter key="cell_density_cm2" value="label"/>
<parameter key="small_cell_density_cm2" value="label"/>
<parameter key="large_cell_density_cm2" value="label"/>
<parameter key="range" value="label"/>
<parameter key="mean_ecc" value="label"/>
</list>
</operator>
<operator activated="true" class="loop_labels" compatibility="10.1.003" expanded="true" height="82" name="Loop Labels" origin="GENERATED_TUTORIAL" width="90" x="313" y="85">
<process expanded="true">
<operator activated="false" class="set_macro" compatibility="10.1.003" expanded="true" height="68" name="Set Macro" width="90" x="1452" y="136">
<parameter key="macro" value="counter"/>
<parameter key="value" value="1"/>
</operator>
<operator activated="false" class="loop_labels" compatibility="10.1.003" expanded="true" height="82" name="Loop Labels (2)" width="90" x="1586" y="136">
<process expanded="true">
<operator activated="true" class="write_excel" compatibility="10.1.003" expanded="true" height="103" name="Write Excel (2)" width="90" x="45" y="34">
<parameter key="excel_file" value="/Users/Mansour/Downloads/Maman_Mona/test-%{counter}.xlsx"/>
<parameter key="file_format" value="xlsx"/>
<enumeration key="sheet_names"/>
<parameter key="sheet_name" value="RapidMiner Data"/>
<parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>
<parameter key="number_format" value="#.0"/>
<parameter key="encoding" value="UTF-8"/>
</operator>
<operator activated="true" class="generate_macro" compatibility="10.1.003" expanded="true" height="82" name="Generate Macro" width="90" x="179" y="34">
<list key="function_descriptions">
<parameter key="counter" value="eval(%{counter})+1"/>
</list>
</operator>
<connect from_port="example set" to_op="Write Excel (2)" to_port="input"/>
<connect from_op="Write Excel (2)" from_port="through" to_op="Generate Macro" to_port="through 1"/>
<connect from_op="Generate Macro" from_port="through 1" to_port="out 1"/>
<portSpacing port="source_example set" spacing="0"/>
<portSpacing port="sink_out 1" spacing="0"/>
<portSpacing port="sink_out 2" spacing="0"/>
</process>
</operator>
<operator activated="true" class="replace_missing_values" compatibility="10.1.003" expanded="true" height="103" name="Replace Missing Values (4)" width="90" x="45" y="34">
<parameter key="return_preprocessing_model" value="false"/>
<parameter key="attribute_filter_type" value="all"/>
<parameter key="attribute" value=""/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="attribute_value"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="false"/>
<parameter key="include_special_attributes" value="false"/>
<parameter key="default" value="average"/>
<list key="columns"/>
</operator>
<operator activated="true" class="select_attributes" compatibility="10.1.003" expanded="true" height="82" name="Select Attributes" width="90" x="179" y="34">
<parameter key="attribute_filter_type" value="all"/>
<parameter key="attribute" value="SCC"/>
<parameter key="attributes" value="|au_scc|Vol|Prot|Peak_Flow|Milking_Time|Lact|Fat|EC|Date"/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="numeric"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="false"/>
<parameter key="include_special_attributes" value="false"/>
</operator>
<operator activated="true" class="replace_missing_values" compatibility="5.2.000" expanded="true" height="103" name="Replace Missing Values" width="90" x="313" y="34">
<parameter key="return_preprocessing_model" value="false"/>
<parameter key="attribute_filter_type" value="all"/>
<parameter key="attribute" value=""/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="numeric"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="false"/>
<parameter key="include_special_attributes" value="false"/>
<parameter key="default" value="average"/>
<list key="columns"/>
</operator>
<operator activated="true" class="multiply" compatibility="10.1.003" expanded="true" height="271" name="Multiply" width="90" x="112" y="187"/>
<operator activated="true" class="replace_missing_values" compatibility="10.1.003" expanded="true" height="103" name="Replace Missing Values (5)" width="90" x="246" y="187">
<parameter key="return_preprocessing_model" value="false"/>
<parameter key="attribute_filter_type" value="all"/>
<parameter key="attribute" value=""/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="attribute_value"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="false"/>
<parameter key="include_special_attributes" value="false"/>
<parameter key="default" value="average"/>
<list key="columns"/>
</operator>
<operator activated="true" class="weight_by_information_gain" compatibility="10.1.003" expanded="true" height="82" name="Weight by Information Gain" width="90" x="380" y="174">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data" width="90" x="581" y="174"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="782" y="187">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename" width="90" x="983" y="174">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Info Gain"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="weight_by_information_gain_ratio" compatibility="10.1.003" expanded="true" height="82" name="Weight by Information Gain Ratio" width="90" x="380" y="309">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (2)" width="90" x="581" y="309"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (3)" width="90" x="782" y="322">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (2)" width="90" x="983" y="309">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Info Gain Ratio"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="weight_by_rule" compatibility="10.1.003" expanded="true" height="82" name="Weight by Rule" width="90" x="380" y="444">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (3)" width="90" x="581" y="444"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (4)" width="90" x="782" y="457">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (3)" width="90" x="983" y="444">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Rule"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="weight_by_deviation" compatibility="10.1.003" expanded="true" height="82" name="Weight by Deviation" width="90" x="380" y="595">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
<parameter key="normalize" value="none"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (4)" width="90" x="581" y="595"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (5)" width="90" x="782" y="608">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (4)" width="90" x="983" y="595">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Deviation"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="weight_by_chi_squared_statistic" compatibility="10.1.003" expanded="true" height="82" name="Weight by Chi Squared Statistic" width="90" x="380" y="730">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
<parameter key="number_of_bins" value="10"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (5)" width="90" x="581" y="730"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (6)" width="90" x="782" y="743">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (5)" width="90" x="983" y="730">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Chi Squared"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="weight_by_gini_index" compatibility="10.1.003" expanded="true" height="82" name="Weight by Gini Index" width="90" x="380" y="865">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (6)" width="90" x="581" y="865"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (7)" width="90" x="782" y="878">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (6)" width="90" x="983" y="865">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Gini Index"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="weight_by_uncertainty" compatibility="10.1.003" expanded="true" height="82" name="Weight by Uncertainty" width="90" x="380" y="1000">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
<parameter key="number_of_bins" value="10"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (7)" width="90" x="581" y="1000"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (8)" width="90" x="782" y="1013">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (7)" width="90" x="983" y="1003">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Uncertainty"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="weight_by_relief" compatibility="10.1.003" expanded="true" height="82" name="Weight by Relief" width="90" x="380" y="1124">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
<parameter key="number_of_neighbors" value="10"/>
<parameter key="sample_ratio" value="1.0"/>
<parameter key="use_local_random_seed" value="false"/>
<parameter key="local_random_seed" value="1992"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (8)" width="90" x="581" y="1135"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (9)" width="90" x="782" y="1148">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (8)" width="90" x="983" y="1135">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Relief"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join" width="90" x="1184" y="238">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes"/>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (2)" width="90" x="1184" y="340">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes"/>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (3)" width="90" x="1184" y="493">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes"/>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (4)" width="90" x="1184" y="697">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes"/>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (5)" width="90" x="1184" y="799">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes"/>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (6)" width="90" x="1184" y="1003">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes"/>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (7)" width="90" x="1184" y="1156">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes"/>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="replace_missing_values" compatibility="10.1.003" expanded="true" height="103" name="Replace Missing Values (2)" width="90" x="246" y="1175">
<parameter key="return_preprocessing_model" value="false"/>
<parameter key="attribute_filter_type" value="all"/>
<parameter key="attribute" value=""/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="attribute_value"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="false"/>
<parameter key="include_special_attributes" value="false"/>
<parameter key="default" value="average"/>
<list key="columns"/>
</operator>
<operator activated="true" class="weight_by_svm" compatibility="10.1.003" expanded="true" height="82" name="Weight by SVM" width="90" x="380" y="1258">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
<parameter key="C" value="0.0"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (9)" width="90" x="581" y="1258"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (10)" width="90" x="782" y="1271">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (9)" width="90" x="983" y="1258">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_SVM"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (8)" width="90" x="1251" y="1258">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes"/>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="replace_missing_values" compatibility="10.1.003" expanded="true" height="103" name="Replace Missing Values (3)" width="90" x="246" y="1328">
<parameter key="return_preprocessing_model" value="false"/>
<parameter key="attribute_filter_type" value="all"/>
<parameter key="attribute" value=""/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="attribute_value"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="false"/>
<parameter key="include_special_attributes" value="false"/>
<parameter key="default" value="average"/>
<list key="columns"/>
</operator>
<operator activated="true" class="weight_by_pca" compatibility="9.4.001" expanded="true" height="82" name="Weight by PCA" width="90" x="380" y="1360">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
<parameter key="component_number" value="1"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (10)" width="90" x="581" y="1393"/>
<operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (11)" width="90" x="782" y="1406">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (10)" width="90" x="983" y="1393">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_PCA"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (9)" width="90" x="1251" y="1360">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes"/>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="write_excel" compatibility="10.1.003" expanded="true" height="103" name="Write Excel" width="90" x="1519" y="238">
<parameter key="excel_file" value="/Users/Mansour/Downloads/Maman_Mona/%{a}.xlsx"/>
<parameter key="file_format" value="xlsx"/>
<enumeration key="sheet_names"/>
<parameter key="sheet_name" value="RapidMiner Data"/>
<parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>
<parameter key="number_format" value="#.0"/>
<parameter key="encoding" value="SYSTEM"/>
</operator>
<connect from_port="example set" to_op="Replace Missing Values (4)" to_port="example set input"/>
<connect from_op="Replace Missing Values (4)" from_port="example set output" to_op="Select Attributes" to_port="example set input"/>
<connect from_op="Select Attributes" from_port="example set output" to_op="Replace Missing Values" to_port="example set input"/>
<connect from_op="Replace Missing Values" from_port="example set output" to_op="Multiply" to_port="input"/>
<connect from_op="Multiply" from_port="output 1" to_op="Replace Missing Values (5)" to_port="example set input"/>
<connect from_op="Multiply" from_port="output 2" to_op="Weight by Information Gain Ratio" to_port="example set"/>
<connect from_op="Multiply" from_port="output 3" to_op="Weight by Rule" to_port="example set"/>
<connect from_op="Multiply" from_port="output 4" to_op="Weight by Chi Squared Statistic" to_port="example set"/>
<connect from_op="Multiply" from_port="output 5" to_op="Weight by Gini Index" to_port="example set"/>
<connect from_op="Multiply" from_port="output 6" to_op="Weight by Uncertainty" to_port="example set"/>
<connect from_op="Multiply" from_port="output 7" to_op="Weight by Relief" to_port="example set"/>
<connect from_op="Multiply" from_port="output 8" to_op="Weight by Deviation" to_port="example set"/>
<connect from_op="Multiply" from_port="output 9" to_op="Replace Missing Values (2)" to_port="example set input"/>
<connect from_op="Multiply" from_port="output 10" to_op="Replace Missing Values (3)" to_port="example set input"/>
<connect from_op="Replace Missing Values (5)" from_port="example set output" to_op="Weight by Information Gain" to_port="example set"/>
<connect from_op="Weight by Information Gain" from_port="weights" to_op="Weights to Data" to_port="attribute weights"/>
<connect from_op="Weights to Data" from_port="example set" to_op="Set Role" to_port="example set input"/>
<connect from_op="Set Role" from_port="example set output" to_op="Rename" to_port="example set input"/>
<connect from_op="Rename" from_port="example set output" to_op="Join" to_port="left"/>
<connect from_op="Weight by Information Gain Ratio" from_port="weights" to_op="Weights to Data (2)" to_port="attribute weights"/>
<connect from_op="Weights to Data (2)" from_port="example set" to_op="Set Role (3)" to_port="example set input"/>
<connect from_op="Set Role (3)" from_port="example set output" to_op="Rename (2)" to_port="example set input"/>
<connect from_op="Rename (2)" from_port="example set output" to_op="Join" to_port="right"/>
<connect from_op="Weight by Rule" from_port="weights" to_op="Weights to Data (3)" to_port="attribute weights"/>
<connect from_op="Weights to Data (3)" from_port="example set" to_op="Set Role (4)" to_port="example set input"/>
<connect from_op="Set Role (4)" from_port="example set output" to_op="Rename (3)" to_port="example set input"/>
<connect from_op="Rename (3)" from_port="example set output" to_op="Join (2)" to_port="right"/>
<connect from_op="Weight by Deviation" from_port="weights" to_op="Weights to Data (4)" to_port="attribute weights"/>
<connect from_op="Weights to Data (4)" from_port="example set" to_op="Set Role (5)" to_port="example set input"/>
<connect from_op="Set Role (5)" from_port="example set output" to_op="Rename (4)" to_port="example set input"/>
<connect from_op="Rename (4)" from_port="example set output" to_op="Join (3)" to_port="right"/>
<connect from_op="Weight by Chi Squared Statistic" from_port="weights" to_op="Weights to Data (5)" to_port="attribute weights"/>
<connect from_op="Weights to Data (5)" from_port="example set" to_op="Set Role (6)" to_port="example set input"/>
<connect from_op="Set Role (6)" from_port="example set output" to_op="Rename (5)" to_port="example set input"/>
<connect from_op="Rename (5)" from_port="example set output" to_op="Join (4)" to_port="right"/>
<connect from_op="Weight by Gini Index" from_port="weights" to_op="Weights to Data (6)" to_port="attribute weights"/>
<connect from_op="Weights to Data (6)" from_port="example set" to_op="Set Role (7)" to_port="example set input"/>
<connect from_op="Set Role (7)" from_port="example set output" to_op="Rename (6)" to_port="example set input"/>
<connect from_op="Rename (6)" from_port="example set output" to_op="Join (5)" to_port="right"/>
<connect from_op="Weight by Uncertainty" from_port="weights" to_op="Weights to Data (7)" to_port="attribute weights"/>
<connect from_op="Weights to Data (7)" from_port="example set" to_op="Set Role (8)" to_port="example set input"/>
<connect from_op="Set Role (8)" from_port="example set output" to_op="Rename (7)" to_port="example set input"/>
<connect from_op="Rename (7)" from_port="example set output" to_op="Join (6)" to_port="right"/>
<connect from_op="Weight by Relief" from_port="weights" to_op="Weights to Data (8)" to_port="attribute weights"/>
<connect from_op="Weights to Data (8)" from_port="example set" to_op="Set Role (9)" to_port="example set input"/>
<connect from_op="Set Role (9)" from_port="example set output" to_op="Rename (8)" to_port="example set input"/>
<connect from_op="Rename (8)" from_port="example set output" to_op="Join (7)" to_port="right"/>
<connect from_op="Join" from_port="join" to_op="Join (2)" to_port="left"/>
<connect from_op="Join (2)" from_port="join" to_op="Join (3)" to_port="left"/>
<connect from_op="Join (3)" from_port="join" to_op="Join (4)" to_port="left"/>
<connect from_op="Join (4)" from_port="join" to_op="Join (5)" to_port="left"/>
<connect from_op="Join (5)" from_port="join" to_op="Join (6)" to_port="left"/>
<connect from_op="Join (6)" from_port="join" to_op="Join (7)" to_port="left"/>
<connect from_op="Join (7)" from_port="join" to_op="Join (8)" to_port="left"/>
<connect from_op="Replace Missing Values (2)" from_port="example set output" to_op="Weight by SVM" to_port="example set"/>
<connect from_op="Weight by SVM" from_port="weights" to_op="Weights to Data (9)" to_port="attribute weights"/>
<connect from_op="Weights to Data (9)" from_port="example set" to_op="Set Role (10)" to_port="example set input"/>
<connect from_op="Set Role (10)" from_port="example set output" to_op="Rename (9)" to_port="example set input"/>
<connect from_op="Rename (9)" from_port="example set output" to_op="Join (8)" to_port="right"/>
<connect from_op="Join (8)" from_port="join" to_op="Join (9)" to_port="left"/>
<connect from_op="Replace Missing Values (3)" from_port="example set output" to_op="Weight by PCA" to_port="example set"/>
<connect from_op="Weight by PCA" from_port="weights" to_op="Weights to Data (10)" to_port="attribute weights"/>
<connect from_op="Weights to Data (10)" from_port="example set" to_op="Set Role (11)" to_port="example set input"/>
<connect from_op="Set Role (11)" from_port="example set output" to_op="Rename (10)" to_port="example set input"/>
<connect from_op="Rename (10)" from_port="example set output" to_op="Join (9)" to_port="right"/>
<connect from_op="Join (9)" from_port="join" to_op="Write Excel" to_port="input"/>
<connect from_op="Write Excel" from_port="through" to_port="out 1"/>
<portSpacing port="source_example set" spacing="0"/>
<portSpacing port="sink_out 1" spacing="0"/>
<portSpacing port="sink_out 2" spacing="0"/>
</process>
</operator>
<connect from_op="Retrieve Quartiled All data" from_port="output" to_op="Set Role (2)" to_port="example set input"/>
<connect from_op="Set Role (2)" from_port="example set output" to_op="Loop Labels" to_port="example set"/>
<connect from_op="Loop Labels" from_port="out 1" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="90"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process> 

Answers

  • Options
    ceaperezceaperez Member Posts: 522 Unicorn
    Hi @mansour

    I can't run your process, but I saw that you set roles for attributes before the missing values handling.

    If you don't check the "include special attributes" into the Replace missing Values operator, you will have missing values in your dataset and problems with the next operators.

    please check that. 

    Best, 
    Cesar


  • Options
    mansourmansour Member Posts: 26 Contributor II
    edited November 2023
    Dear @ceaperez
    Many thanks for your reply and suggestions. I made it simple to see the error message. I checked "include special attributes" but didn't work. 
    Thanks.
    This is the error log:
    Nov 5, 2023 9:55:49 PM INFO: No filename given for result file, using stdout for logging results!
    Nov 5, 2023 9:55:49 PM INFO: Process //Mona/Loop Label starts
    Nov 5, 2023 9:55:49 PM INFO: Set Role (2): Breakpoint reached.
    Nov 5, 2023 9:55:53 PM SEVERE: Process failed: operator cannot be executed (Index 0 out of bounds for length 0). Check the log messages...
    Nov 5, 2023 9:55:53 PM SEVERE: Here: 
    Nov 5, 2023 9:55:53 PM SEVERE:           Process[1] (Process)
    Nov 5, 2023 9:55:53 PM SEVERE:            subprocess 'Main Process'
    Nov 5, 2023 9:55:53 PM SEVERE:              +- Retrieve Quartiled All data[1] (Retrieve)
    Nov 5, 2023 9:55:53 PM SEVERE:              +- Set Role (2)[1] (Set Role)
    Nov 5, 2023 9:55:53 PM SEVERE:              +- Loop Labels[1] (Loop Labels)
    Nov 5, 2023 9:55:53 PM SEVERE:            subprocess 'Iteration'
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Set Macro[0] (Set Macro)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Loop Labels (2)[0] (Loop Labels)
    Nov 5, 2023 9:55:53 PM SEVERE:            subprocess 'Iteration'
    Nov 5, 2023 9:55:53 PM SEVERE:                    |     +- Write Excel (2)[0] (Write Excel)
    Nov 5, 2023 9:55:53 PM SEVERE:                    |     +- Generate Macro[0] (Generate Macro)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Replace Missing Values (4)[1] (Replace Missing Values)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Select Attributes[1] (Select Attributes)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Multiply[1] (Multiply)
    Nov 5, 2023 9:55:53 PM SEVERE:        ==>         +- Weight by Information Gain[1] (Weight by Information Gain)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weights to Data[0] (Weights to Data)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Set Role[0] (Set Role)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Rename[0] (Rename (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weight by Information Gain Ratio[0] (Weight by Information Gain Ratio)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weights to Data (2)[0] (Weights to Data)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Set Role (3)[0] (Set Role)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Rename (2)[0] (Rename (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weight by Rule[0] (Weight by Rule)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weights to Data (3)[0] (Weights to Data)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Set Role (4)[0] (Set Role)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Rename (3)[0] (Rename (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weight by Deviation[0] (Weight by Deviation)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weights to Data (4)[0] (Weights to Data)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Set Role (5)[0] (Set Role)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Rename (4)[0] (Rename (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weight by Chi Squared Statistic[0] (Weight by Chi Squared Statistic)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weights to Data (5)[0] (Weights to Data)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Set Role (6)[0] (Set Role)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Rename (5)[0] (Rename (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weight by Gini Index[0] (Weight by Gini Index)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weights to Data (6)[0] (Weights to Data)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Set Role (7)[0] (Set Role)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Rename (6)[0] (Rename (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weight by Uncertainty[0] (Weight by Uncertainty)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weights to Data (7)[0] (Weights to Data)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Set Role (8)[0] (Set Role)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Rename (7)[0] (Rename (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weight by Relief[0] (Weight by Relief)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Weights to Data (8)[0] (Weights to Data)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Set Role (9)[0] (Set Role)
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Rename (8)[0] (Rename (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Join[0] (Join (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Join (2)[0] (Join (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Join (3)[0] (Join (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Join (4)[0] (Join (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Join (5)[0] (Join (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Join (6)[0] (Join (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Join (7)[0] (Join (Deprecated))
    Nov 5, 2023 9:55:53 PM SEVERE:                    +- Write Excel[0] (Write Excel)
    Nov 5, 2023 9:55:53 PM SEVERE: java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Set Role' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Set Role (3)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Set Role (4)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Set Role (5)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Set Role (6)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Set Role (7)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Set Role (8)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Set Role (9)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Join' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Join (2)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Join (3)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Join (4)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Join (5)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Join (6)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:55:59 PM INFO: Operator 'Join (7)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Set Role' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Set Role (3)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Set Role (4)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Set Role (5)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Set Role (6)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Set Role (7)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Set Role (8)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Set Role (9)' was created with version '5.3.013'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Join' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Join (2)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Join (3)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Join (4)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Join (5)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Join (6)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.
    Nov 5, 2023 9:56:01 PM INFO: Operator 'Join (7)' was created with version '5.1.008'. The operator's behaviour has changed as of version '10.1.003' and can be adapted to the latest version in the parameter panel.

    <?xml version="1.0" encoding="UTF-8"?><process version="10.1.003">
    <context>
    <input/>
    <output/>
    <macros/>
    </context>
    <operator activated="true" class="process" compatibility="10.1.003" expanded="true" name="Process" origin="GENERATED_TUTORIAL">
    <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="10.1.003" expanded="true" height="68" name="Retrieve Quartiled All data" width="90" x="45" y="85">
    <parameter key="repository_entry" value="Quartiled All data"/>
    </operator>
    <operator activated="true" breakpoints="after" class="blending:set_role" compatibility="10.1.003" expanded="true" height="82" name="Set Role (2)" origin="GENERATED_TUTORIAL" width="90" x="179" y="85">
    <list key="set_roles">
    <parameter key="Hardness Bite 1 (N)" value="label"/>
    <parameter key="Hardness Bite 2 (N)" value="label"/>
    <parameter key="Adhesive Force (N)" value="label"/>
    <parameter key="Cohesiveness" value="label"/>
    <parameter key="Gumminess (N)" value="label"/>
    <parameter key="Springiness (mm)" value="label"/>
    <parameter key="Chewiness (N)" value="label"/>
    <parameter key="Resilience" value="label"/>
    <parameter key="gas amount (mol/g)" value="label"/>
    <parameter key="baking loss" value="label"/>
    <parameter key="Crust Colour a*" value="label"/>
    <parameter key="Crust Colour b*" value="label"/>
    <parameter key="Crust Colour L*" value="label"/>
    <parameter key="Crust ^E*" value="label"/>
    <parameter key="Crumb ^E*" value="label"/>
    <parameter key="Crumb Colour a*" value="label"/>
    <parameter key="Crumb Colour b*" value="label"/>
    <parameter key="Crumb Colour L*" value="label"/>
    <parameter key="void_fraction" value="label"/>
    <parameter key="mean_area_mm2" value="label"/>
    <parameter key="cell_density_cm2" value="label"/>
    <parameter key="small_cell_density_cm2" value="label"/>
    <parameter key="large_cell_density_cm2" value="label"/>
    <parameter key="range" value="label"/>
    <parameter key="mean_ecc" value="label"/>
    </list>
    </operator>
    <operator activated="true" class="loop_labels" compatibility="10.1.003" expanded="true" height="82" name="Loop Labels" origin="GENERATED_TUTORIAL" width="90" x="313" y="85">
    <process expanded="true">
    <operator activated="false" class="set_macro" compatibility="10.1.003" expanded="true" height="68" name="Set Macro" width="90" x="1452" y="136">
    <parameter key="macro" value="counter"/>
    <parameter key="value" value="1"/>
    </operator>
    <operator activated="false" class="loop_labels" compatibility="10.1.003" expanded="true" height="82" name="Loop Labels (2)" width="90" x="1586" y="136">
    <process expanded="true">
    <operator activated="true" class="write_excel" compatibility="10.1.003" expanded="true" height="103" name="Write Excel (2)" width="90" x="45" y="34">
    <parameter key="excel_file" value="/Users/Mansour/Downloads/Maman_Mona/test-%{counter}.xlsx"/>
    <parameter key="file_format" value="xlsx"/>
    <enumeration key="sheet_names"/>
    <parameter key="sheet_name" value="RapidMiner Data"/>
    <parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>
    <parameter key="number_format" value="#.0"/>
    <parameter key="encoding" value="UTF-8"/>
    </operator>
    <operator activated="true" class="generate_macro" compatibility="10.1.003" expanded="true" height="82" name="Generate Macro" width="90" x="179" y="34">
    <list key="function_descriptions">
    <parameter key="counter" value="eval(%{counter})+1"/>
    </list>
    </operator>
    <connect from_port="example set" to_op="Write Excel (2)" to_port="input"/>
    <connect from_op="Write Excel (2)" from_port="through" to_op="Generate Macro" to_port="through 1"/>
    <connect from_op="Generate Macro" from_port="through 1" to_port="out 1"/>
    <portSpacing port="source_example set" spacing="0"/>
    <portSpacing port="sink_out 1" spacing="0"/>
    <portSpacing port="sink_out 2" spacing="0"/>
    </process>
    </operator>
    <operator activated="true" class="replace_missing_values" compatibility="10.1.003" expanded="true" height="103" name="Replace Missing Values (4)" width="90" x="45" y="34">
    <parameter key="return_preprocessing_model" value="false"/>
    <parameter key="attribute_filter_type" value="all"/>
    <parameter key="attribute" value=""/>
    <parameter key="attributes" value=""/>
    <parameter key="use_except_expression" value="false"/>
    <parameter key="value_type" value="attribute_value"/>
    <parameter key="use_value_type_exception" value="false"/>
    <parameter key="except_value_type" value="time"/>
    <parameter key="block_type" value="attribute_block"/>
    <parameter key="use_block_type_exception" value="false"/>
    <parameter key="except_block_type" value="value_matrix_row_start"/>
    <parameter key="invert_selection" value="false"/>
    <parameter key="include_special_attributes" value="true"/>
    <parameter key="default" value="average"/>
    <list key="columns"/>
    </operator>
    <operator activated="true" class="select_attributes" compatibility="10.1.003" expanded="true" height="82" name="Select Attributes" width="90" x="179" y="34">
    <parameter key="attribute_filter_type" value="all"/>
    <parameter key="attribute" value="SCC"/>
    <parameter key="attributes" value="|au_scc|Vol|Prot|Peak_Flow|Milking_Time|Lact|Fat|EC|Date"/>
    <parameter key="use_except_expression" value="false"/>
    <parameter key="value_type" value="numeric"/>
    <parameter key="use_value_type_exception" value="false"/>
    <parameter key="except_value_type" value="time"/>
    <parameter key="block_type" value="attribute_block"/>
    <parameter key="use_block_type_exception" value="false"/>
    <parameter key="except_block_type" value="value_matrix_row_start"/>
    <parameter key="invert_selection" value="false"/>
    <parameter key="include_special_attributes" value="false"/>
    </operator>
    <operator activated="true" class="multiply" compatibility="10.1.003" expanded="true" height="229" name="Multiply" width="90" x="112" y="187"/>
    <operator activated="true" class="weight_by_information_gain" compatibility="10.1.003" expanded="true" height="82" name="Weight by Information Gain" width="90" x="380" y="174">
    <parameter key="normalize_weights" value="true"/>
    <parameter key="sort_weights" value="true"/>
    <parameter key="sort_direction" value="ascending"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data" width="90" x="581" y="174"/>
    <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="782" y="187">
    <parameter key="attribute_name" value="Attribute"/>
    <parameter key="target_role" value="id"/>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename" width="90" x="983" y="174">
    <parameter key="old_name" value="Weight"/>
    <parameter key="new_name" value="Weight_Info Gain"/>
    <list key="rename_additional_attributes"/>
    </operator>
    <operator activated="true" class="weight_by_information_gain_ratio" compatibility="10.1.003" expanded="true" height="82" name="Weight by Information Gain Ratio" width="90" x="380" y="309">
    <parameter key="normalize_weights" value="true"/>
    <parameter key="sort_weights" value="true"/>
    <parameter key="sort_direction" value="ascending"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (2)" width="90" x="581" y="309"/>
    <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (3)" width="90" x="782" y="322">
    <parameter key="attribute_name" value="Attribute"/>
    <parameter key="target_role" value="id"/>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (2)" width="90" x="983" y="309">
    <parameter key="old_name" value="Weight"/>
    <parameter key="new_name" value="Weight_Info Gain Ratio"/>
    <list key="rename_additional_attributes"/>
    </operator>
    <operator activated="true" class="weight_by_rule" compatibility="10.1.003" expanded="true" height="82" name="Weight by Rule" width="90" x="380" y="444">
    <parameter key="normalize_weights" value="true"/>
    <parameter key="sort_weights" value="true"/>
    <parameter key="sort_direction" value="ascending"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (3)" width="90" x="581" y="444"/>
    <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (4)" width="90" x="782" y="457">
    <parameter key="attribute_name" value="Attribute"/>
    <parameter key="target_role" value="id"/>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (3)" width="90" x="983" y="444">
    <parameter key="old_name" value="Weight"/>
    <parameter key="new_name" value="Weight_Rule"/>
    <list key="rename_additional_attributes"/>
    </operator>
    <operator activated="true" class="weight_by_deviation" compatibility="10.1.003" expanded="true" height="82" name="Weight by Deviation" width="90" x="380" y="595">
    <parameter key="normalize_weights" value="true"/>
    <parameter key="sort_weights" value="true"/>
    <parameter key="sort_direction" value="ascending"/>
    <parameter key="normalize" value="none"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (4)" width="90" x="581" y="595"/>
    <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (5)" width="90" x="782" y="608">
    <parameter key="attribute_name" value="Attribute"/>
    <parameter key="target_role" value="id"/>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (4)" width="90" x="983" y="595">
    <parameter key="old_name" value="Weight"/>
    <parameter key="new_name" value="Weight_Deviation"/>
    <list key="rename_additional_attributes"/>
    </operator>
    <operator activated="true" class="weight_by_chi_squared_statistic" compatibility="10.1.003" expanded="true" height="82" name="Weight by Chi Squared Statistic" width="90" x="380" y="730">
    <parameter key="normalize_weights" value="true"/>
    <parameter key="sort_weights" value="true"/>
    <parameter key="sort_direction" value="ascending"/>
    <parameter key="number_of_bins" value="10"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (5)" width="90" x="581" y="730"/>
    <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (6)" width="90" x="782" y="743">
    <parameter key="attribute_name" value="Attribute"/>
    <parameter key="target_role" value="id"/>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (5)" width="90" x="983" y="730">
    <parameter key="old_name" value="Weight"/>
    <parameter key="new_name" value="Weight_Chi Squared"/>
    <list key="rename_additional_attributes"/>
    </operator>
    <operator activated="true" class="weight_by_gini_index" compatibility="10.1.003" expanded="true" height="82" name="Weight by Gini Index" width="90" x="380" y="865">
    <parameter key="normalize_weights" value="true"/>
    <parameter key="sort_weights" value="true"/>
    <parameter key="sort_direction" value="ascending"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (6)" width="90" x="581" y="865"/>
    <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (7)" width="90" x="782" y="878">
    <parameter key="attribute_name" value="Attribute"/>
    <parameter key="target_role" value="id"/>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (6)" width="90" x="983" y="865">
    <parameter key="old_name" value="Weight"/>
    <parameter key="new_name" value="Weight_Gini Index"/>
    <list key="rename_additional_attributes"/>
    </operator>
    <operator activated="true" class="weight_by_uncertainty" compatibility="10.1.003" expanded="true" height="82" name="Weight by Uncertainty" width="90" x="380" y="1000">
    <parameter key="normalize_weights" value="true"/>
    <parameter key="sort_weights" value="true"/>
    <parameter key="sort_direction" value="ascending"/>
    <parameter key="number_of_bins" value="10"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (7)" width="90" x="581" y="1000"/>
    <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (8)" width="90" x="782" y="1013">
    <parameter key="attribute_name" value="Attribute"/>
    <parameter key="target_role" value="id"/>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (7)" width="90" x="983" y="1003">
    <parameter key="old_name" value="Weight"/>
    <parameter key="new_name" value="Weight_Uncertainty"/>
    <list key="rename_additional_attributes"/>
    </operator>
    <operator activated="true" class="weight_by_relief" compatibility="10.1.003" expanded="true" height="82" name="Weight by Relief" width="90" x="380" y="1124">
    <parameter key="normalize_weights" value="true"/>
    <parameter key="sort_weights" value="true"/>
    <parameter key="sort_direction" value="ascending"/>
    <parameter key="number_of_neighbors" value="10"/>
    <parameter key="sample_ratio" value="1.0"/>
    <parameter key="use_local_random_seed" value="false"/>
    <parameter key="local_random_seed" value="1992"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="10.1.003" expanded="true" height="68" name="Weights to Data (8)" width="90" x="581" y="1135"/>
    <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (9)" width="90" x="782" y="1148">
    <parameter key="attribute_name" value="Attribute"/>
    <parameter key="target_role" value="id"/>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="rename" compatibility="10.1.003" expanded="true" height="82" name="Rename (8)" width="90" x="983" y="1135">
    <parameter key="old_name" value="Weight"/>
    <parameter key="new_name" value="Weight_Relief"/>
    <list key="rename_additional_attributes"/>
    </operator>
    <operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join" width="90" x="1184" y="238">
    <parameter key="remove_double_attributes" value="true"/>
    <parameter key="join_type" value="inner"/>
    <parameter key="use_id_attribute_as_key" value="true"/>
    <list key="key_attributes"/>
    <parameter key="keep_both_join_attributes" value="false"/>
    </operator>
    <operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (2)" width="90" x="1184" y="340">
    <parameter key="remove_double_attributes" value="true"/>
    <parameter key="join_type" value="inner"/>
    <parameter key="use_id_attribute_as_key" value="true"/>
    <list key="key_attributes"/>
    <parameter key="keep_both_join_attributes" value="false"/>
    </operator>
    <operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (3)" width="90" x="1184" y="493">
    <parameter key="remove_double_attributes" value="true"/>
    <parameter key="join_type" value="inner"/>
    <parameter key="use_id_attribute_as_key" value="true"/>
    <list key="key_attributes"/>
    <parameter key="keep_both_join_attributes" value="false"/>
    </operator>
    <operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (4)" width="90" x="1184" y="697">
    <parameter key="remove_double_attributes" value="true"/>
    <parameter key="join_type" value="inner"/>
    <parameter key="use_id_attribute_as_key" value="true"/>
    <list key="key_attributes"/>
    <parameter key="keep_both_join_attributes" value="false"/>
    </operator>
    <operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (5)" width="90" x="1184" y="799">
    <parameter key="remove_double_attributes" value="true"/>
    <parameter key="join_type" value="inner"/>
    <parameter key="use_id_attribute_as_key" value="true"/>
    <list key="key_attributes"/>
    <parameter key="keep_both_join_attributes" value="false"/>
    </operator>
    <operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (6)" width="90" x="1184" y="1003">
    <parameter key="remove_double_attributes" value="true"/>
    <parameter key="join_type" value="inner"/>
    <parameter key="use_id_attribute_as_key" value="true"/>
    <list key="key_attributes"/>
    <parameter key="keep_both_join_attributes" value="false"/>
    </operator>
    <operator activated="true" class="join" compatibility="5.1.008" expanded="true" height="82" name="Join (7)" width="90" x="1184" y="1156">
    <parameter key="remove_double_attributes" value="true"/>
    <parameter key="join_type" value="inner"/>
    <parameter key="use_id_attribute_as_key" value="true"/>
    <list key="key_attributes"/>
    <parameter key="keep_both_join_attributes" value="false"/>
    </operator>
    <operator activated="true" class="write_excel" compatibility="10.1.003" expanded="true" height="103" name="Write Excel" width="90" x="1519" y="238">
    <parameter key="excel_file" value="/Users/Mansour/Downloads/Maman_Mona/%{a}.xlsx"/>
    <parameter key="file_format" value="xlsx"/>
    <enumeration key="sheet_names"/>
    <parameter key="sheet_name" value="RapidMiner Data"/>
    <parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>
    <parameter key="number_format" value="#.0"/>
    <parameter key="encoding" value="SYSTEM"/>
    </operator>
    <connect from_port="example set" to_op="Replace Missing Values (4)" to_port="example set input"/>
    <connect from_op="Replace Missing Values (4)" from_port="example set output" to_op="Select Attributes" to_port="example set input"/>
    <connect from_op="Select Attributes" from_port="example set output" to_op="Multiply" to_port="input"/>
    <connect from_op="Multiply" from_port="output 1" to_op="Weight by Information Gain" to_port="example set"/>
    <connect from_op="Multiply" from_port="output 2" to_op="Weight by Information Gain Ratio" to_port="example set"/>
    <connect from_op="Multiply" from_port="output 3" to_op="Weight by Rule" to_port="example set"/>
    <connect from_op="Multiply" from_port="output 4" to_op="Weight by Chi Squared Statistic" to_port="example set"/>
    <connect from_op="Multiply" from_port="output 5" to_op="Weight by Gini Index" to_port="example set"/>
    <connect from_op="Multiply" from_port="output 6" to_op="Weight by Uncertainty" to_port="example set"/>
    <connect from_op="Multiply" from_port="output 7" to_op="Weight by Relief" to_port="example set"/>
    <connect from_op="Multiply" from_port="output 8" to_op="Weight by Deviation" to_port="example set"/>
    <connect from_op="Weight by Information Gain" from_port="weights" to_op="Weights to Data" to_port="attribute weights"/>
    <connect from_op="Weights to Data" from_port="example set" to_op="Set Role" to_port="example set input"/>
    <connect from_op="Set Role" from_port="example set output" to_op="Rename" to_port="example set input"/>
    <connect from_op="Rename" from_port="example set output" to_op="Join" to_port="left"/>
    <connect from_op="Weight by Information Gain Ratio" from_port="weights" to_op="Weights to Data (2)" to_port="attribute weights"/>
    <connect from_op="Weights to Data (2)" from_port="example set" to_op="Set Role (3)" to_port="example set input"/>
    <connect from_op="Set Role (3)" from_port="example set output" to_op="Rename (2)" to_port="example set input"/>
    <connect from_op="Rename (2)" from_port="example set output" to_op="Join" to_port="right"/>
    <connect from_op="Weight by Rule" from_port="weights" to_op="Weights to Data (3)" to_port="attribute weights"/>
    <connect from_op="Weights to Data (3)" from_port="example set" to_op="Set Role (4)" to_port="example set input"/>
    <connect from_op="Set Role (4)" from_port="example set output" to_op="Rename (3)" to_port="example set input"/>
    <connect from_op="Rename (3)" from_port="example set output" to_op="Join (2)" to_port="right"/>
    <connect from_op="Weight by Deviation" from_port="weights" to_op="Weights to Data (4)" to_port="attribute weights"/>
    <connect from_op="Weights to Data (4)" from_port="example set" to_op="Set Role (5)" to_port="example set input"/>
    <connect from_op="Set Role (5)" from_port="example set output" to_op="Rename (4)" to_port="example set input"/>
    <connect from_op="Rename (4)" from_port="example set output" to_op="Join (3)" to_port="right"/>
    <connect from_op="Weight by Chi Squared Statistic" from_port="weights" to_op="Weights to Data (5)" to_port="attribute weights"/>
    <connect from_op="Weights to Data (5)" from_port="example set" to_op="Set Role (6)" to_port="example set input"/>
    <connect from_op="Set Role (6)" from_port="example set output" to_op="Rename (5)" to_port="example set input"/>
    <connect from_op="Rename (5)" from_port="example set output" to_op="Join (4)" to_port="right"/>
    <connect from_op="Weight by Gini Index" from_port="weights" to_op="Weights to Data (6)" to_port="attribute weights"/>
    <connect from_op="Weights to Data (6)" from_port="example set" to_op="Set Role (7)" to_port="example set input"/>
    <connect from_op="Set Role (7)" from_port="example set output" to_op="Rename (6)" to_port="example set input"/>
    <connect from_op="Rename (6)" from_port="example set output" to_op="Join (5)" to_port="right"/>
    <connect from_op="Weight by Uncertainty" from_port="weights" to_op="Weights to Data (7)" to_port="attribute weights"/>
    <connect from_op="Weights to Data (7)" from_port="example set" to_op="Set Role (8)" to_port="example set input"/>
    <connect from_op="Set Role (8)" from_port="example set output" to_op="Rename (7)" to_port="example set input"/>
    <connect from_op="Rename (7)" from_port="example set output" to_op="Join (6)" to_port="right"/>
    <connect from_op="Weight by Relief" from_port="weights" to_op="Weights to Data (8)" to_port="attribute weights"/>
    <connect from_op="Weights to Data (8)" from_port="example set" to_op="Set Role (9)" to_port="example set input"/>
    <connect from_op="Set Role (9)" from_port="example set output" to_op="Rename (8)" to_port="example set input"/>
    <connect from_op="Rename (8)" from_port="example set output" to_op="Join (7)" to_port="right"/>
    <connect from_op="Join" from_port="join" to_op="Join (2)" to_port="left"/>
    <connect from_op="Join (2)" from_port="join" to_op="Join (3)" to_port="left"/>
    <connect from_op="Join (3)" from_port="join" to_op="Join (4)" to_port="left"/>
    <connect from_op="Join (4)" from_port="join" to_op="Join (5)" to_port="left"/>
    <connect from_op="Join (5)" from_port="join" to_op="Join (6)" to_port="left"/>
    <connect from_op="Join (6)" from_port="join" to_op="Join (7)" to_port="left"/>
    <connect from_op="Join (7)" from_port="join" to_op="Write Excel" to_port="input"/>
    <connect from_op="Write Excel" from_port="through" to_port="out 1"/>
    <portSpacing port="source_example set" spacing="0"/>
    <portSpacing port="sink_out 1" spacing="0"/>
    <portSpacing port="sink_out 2" spacing="0"/>
    </process>
    </operator>
    <connect from_op="Retrieve Quartiled All data" from_port="output" to_op="Set Role (2)" to_port="example set input"/>
    <connect from_op="Set Role (2)" from_port="example set output" to_op="Loop Labels" to_port="example set"/>
    <connect from_op="Loop Labels" from_port="out 1" to_port="result 1"/>
    <portSpacing port="source_input 1" spacing="0"/>
    <portSpacing port="sink_result 1" spacing="90"/>
    <portSpacing port="sink_result 2" spacing="0"/>
    </process>
    </operator>
    </process>
Sign In or Register to comment.