The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
<?xml version="1.0" encoding="UTF-8"?><process version="9.2.000"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="9.2.000" 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" breakpoints="after" class="read_excel" compatibility="9.2.000" expanded="true" height="68" name="Read Excel" width="90" x="179" y="85"> <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\Impute_column_missing_values\Sample_Data_2_Impute.xlsx"/> <parameter key="sheet_selection" value="sheet number"/> <parameter key="sheet_number" value="1"/> <parameter key="imported_cell_range" value="A1"/> <parameter key="encoding" value="SYSTEM"/> <parameter key="first_row_as_names" value="true"/> <list key="annotations"/> <parameter key="date_format" value=""/> <parameter key="time_zone" value="SYSTEM"/> <parameter key="locale" value="English (United States)"/> <parameter key="read_all_values_as_polynominal" value="false"/> <list key="data_set_meta_data_information"> <parameter key="0" value="ID.true.integer.attribute"/> <parameter key="1" value="2017-01.true.integer.attribute"/> <parameter key="2" value="2017-02.true.integer.attribute"/> <parameter key="3" value="2017-03.true.integer.attribute"/> <parameter key="4" value="2017-04.true.integer.attribute"/> <parameter key="5" value="2017-05.true.integer.attribute"/> <parameter key="6" value="2017-06.true.integer.attribute"/> <parameter key="7" value="2017-07.true.integer.attribute"/> <parameter key="8" value="2017-08.true.integer.attribute"/> <parameter key="9" value="2017-09.true.integer.attribute"/> <parameter key="10" value="2017-10.true.integer.attribute"/> <parameter key="11" value="2017-11.true.integer.attribute"/> <parameter key="12" value="2017-12.true.integer.attribute"/> <parameter key="13" value="2018-01.true.integer.attribute"/> <parameter key="14" value="2018-02.true.integer.attribute"/> <parameter key="15" value="2018-03.true.integer.attribute"/> <parameter key="16" value="2018-04.true.integer.attribute"/> <parameter key="17" value="2018-05.true.integer.attribute"/> <parameter key="18" value="2018-06.true.integer.attribute"/> <parameter key="19" value="2018-07.true.integer.attribute"/> <parameter key="20" value="2018-08.true.integer.attribute"/> <parameter key="21" value="2018-09.true.integer.attribute"/> <parameter key="22" value="2018-10.true.integer.attribute"/> <parameter key="23" value="2018-11.true.integer.attribute"/> <parameter key="24" value="2018-12.true.integer.attribute"/> </list> <parameter key="read_not_matching_values_as_missings" value="false"/> <parameter key="datamanagement" value="double_array"/> <parameter key="data_management" value="auto"/> </operator> <operator activated="true" class="transpose" compatibility="9.2.000" expanded="true" height="82" name="Transpose" width="90" x="313" y="85"/> <operator activated="true" class="select_attributes" compatibility="9.2.000" expanded="true" height="82" name="Select Attributes" width="90" x="447" y="187"> <parameter key="attribute_filter_type" value="single"/> <parameter key="attribute" value="ID"/> <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"/> </operator> <operator activated="true" class="generate_id" compatibility="9.2.000" expanded="true" height="82" name="Generate ID" width="90" x="648" y="238"> <parameter key="create_nominal_ids" value="false"/> <parameter key="offset" value="0"/> </operator> <operator activated="true" class="filter_example_range" compatibility="9.2.000" expanded="true" height="82" name="Filter Example Range" width="90" x="447" y="85"> <parameter key="first_example" value="1"/> <parameter key="last_example" value="1"/> <parameter key="invert_filter" value="true"/> </operator> <operator activated="true" class="replace_missing_values" compatibility="9.2.000" expanded="true" height="103" name="Replace Missing Values" width="90" x="581" y="85"> <parameter key="return_preprocessing_model" value="false"/> <parameter key="create_view" 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="transpose" compatibility="9.2.000" expanded="true" height="82" name="Transpose (2)" width="90" x="715" y="85"/> <operator activated="true" class="generate_id" compatibility="9.2.000" expanded="true" height="82" name="Generate ID (2)" width="90" x="849" y="85"> <parameter key="create_nominal_ids" value="false"/> <parameter key="offset" value="0"/> </operator> <operator activated="true" class="concurrency:join" compatibility="9.2.000" expanded="true" height="82" name="Join" width="90" x="1050" y="136"> <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> <connect from_op="Read Excel" from_port="output" to_op="Transpose" to_port="example set input"/> <connect from_op="Transpose" from_port="example set output" to_op="Filter Example Range" to_port="example set input"/> <connect from_op="Transpose" from_port="original" to_op="Select Attributes" to_port="example set input"/> <connect from_op="Select Attributes" from_port="example set output" to_op="Generate ID" to_port="example set input"/> <connect from_op="Generate ID" from_port="example set output" to_op="Join" to_port="left"/> <connect from_op="Filter Example Range" 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="Transpose (2)" to_port="example set input"/> <connect from_op="Transpose (2)" from_port="example set output" to_op="Generate ID (2)" to_port="example set input"/> <connect from_op="Generate ID (2)" from_port="example set output" to_op="Join" to_port="right"/> <connect from_op="Join" from_port="join" 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>
<?xml version="1.0" encoding="UTF-8"?><process version="9.2.000"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="9.2.000" 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="read_excel" compatibility="9.2.000" expanded="true" height="68" name="Read Excel" width="90" x="179" y="85"> <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\Impute_column_missing_values\Sample_Data_2_Impute.xlsx"/> <parameter key="sheet_selection" value="sheet number"/> <parameter key="sheet_number" value="1"/> <parameter key="imported_cell_range" value="A1"/> <parameter key="encoding" value="SYSTEM"/> <parameter key="first_row_as_names" value="true"/> <list key="annotations"/> <parameter key="date_format" value=""/> <parameter key="time_zone" value="SYSTEM"/> <parameter key="locale" value="English (United States)"/> <parameter key="read_all_values_as_polynominal" value="false"/> <list key="data_set_meta_data_information"> <parameter key="0" value="ID.true.integer.attribute"/> <parameter key="1" value="2017-01.true.integer.attribute"/> <parameter key="2" value="2017-02.true.integer.attribute"/> <parameter key="3" value="2017-03.true.integer.attribute"/> <parameter key="4" value="2017-04.true.integer.attribute"/> <parameter key="5" value="2017-05.true.integer.attribute"/> <parameter key="6" value="2017-06.true.integer.attribute"/> <parameter key="7" value="2017-07.true.integer.attribute"/> <parameter key="8" value="2017-08.true.integer.attribute"/> <parameter key="9" value="2017-09.true.integer.attribute"/> <parameter key="10" value="2017-10.true.integer.attribute"/> <parameter key="11" value="2017-11.true.integer.attribute"/> <parameter key="12" value="2017-12.true.integer.attribute"/> <parameter key="13" value="2018-01.true.integer.attribute"/> <parameter key="14" value="2018-02.true.integer.attribute"/> <parameter key="15" value="2018-03.true.integer.attribute"/> <parameter key="16" value="2018-04.true.integer.attribute"/> <parameter key="17" value="2018-05.true.integer.attribute"/> <parameter key="18" value="2018-06.true.integer.attribute"/> <parameter key="19" value="2018-07.true.integer.attribute"/> <parameter key="20" value="2018-08.true.integer.attribute"/> <parameter key="21" value="2018-09.true.integer.attribute"/> <parameter key="22" value="2018-10.true.integer.attribute"/> <parameter key="23" value="2018-11.true.integer.attribute"/> <parameter key="24" value="2018-12.true.integer.attribute"/> </list> <parameter key="read_not_matching_values_as_missings" value="false"/> <parameter key="datamanagement" value="double_array"/> <parameter key="data_management" value="auto"/> </operator> <operator activated="true" class="transpose" compatibility="9.2.000" expanded="true" height="82" name="Transpose" width="90" x="313" y="85"/> <operator activated="true" class="filter_example_range" compatibility="9.2.000" expanded="true" height="82" name="Filter Example Range" width="90" x="447" y="85"> <parameter key="first_example" value="1"/> <parameter key="last_example" value="1"/> <parameter key="invert_filter" value="true"/> </operator> <operator activated="true" breakpoints="before" class="impute_missing_values" compatibility="9.2.000" expanded="true" height="68" name="Impute Missing Values (4)" width="90" x="581" y="85"> <parameter key="attribute_filter_type" value="value_type"/> <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="iterate" value="true"/> <parameter key="learn_on_complete_cases" value="true"/> <parameter key="order" value="chronological"/> <parameter key="sort" value="ascending"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> <process expanded="true"> <operator activated="true" breakpoints="before" class="neural_net" compatibility="9.2.000" expanded="true" height="82" name="Neural Net (2)" width="90" x="447" y="34"> <list key="hidden_layers"/> <parameter key="training_cycles" value="200"/> <parameter key="learning_rate" value="0.01"/> <parameter key="momentum" value="0.9"/> <parameter key="decay" value="false"/> <parameter key="shuffle" value="true"/> <parameter key="normalize" value="true"/> <parameter key="error_epsilon" value="1.0E-4"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> </operator> <connect from_port="example set source" to_op="Neural Net (2)" to_port="training set"/> <connect from_op="Neural Net (2)" from_port="model" to_port="model sink"/> <portSpacing port="source_example set source" spacing="0"/> <portSpacing port="sink_model sink" spacing="0"/> </process> </operator> <operator activated="true" class="select_attributes" compatibility="9.2.000" expanded="true" height="82" name="Select Attributes" width="90" x="447" y="187"> <parameter key="attribute_filter_type" value="single"/> <parameter key="attribute" value="ID"/> <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"/> </operator> <operator activated="true" class="generate_id" compatibility="9.2.000" expanded="true" height="82" name="Generate ID" width="90" x="648" y="238"> <parameter key="create_nominal_ids" value="false"/> <parameter key="offset" value="0"/> </operator> <operator activated="false" class="subprocess" compatibility="9.2.000" expanded="true" height="82" name="Subprocess" width="90" x="648" y="442"> <process expanded="true"> <operator activated="false" class="multiply" compatibility="9.2.000" expanded="true" height="68" name="Multiply" width="90" x="45" y="136"/> <operator activated="false" class="materialize_data" compatibility="9.2.000" expanded="true" height="82" name="DT then NN" width="90" x="179" y="34"> <parameter key="datamanagement" value="double_array"/> <parameter key="data_management" value="auto"/> </operator> <operator activated="false" class="materialize_data" compatibility="9.2.000" expanded="true" height="82" name="kNN" width="90" x="246" y="238"> <parameter key="datamanagement" value="double_array"/> <parameter key="data_management" value="auto"/> </operator> <operator activated="false" breakpoints="before" class="impute_missing_values" compatibility="7.3.001" expanded="true" height="68" name="Impute Missing Values (3)" width="90" x="380" y="187"> <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="iterate" value="true"/> <parameter key="learn_on_complete_cases" value="true"/> <parameter key="order" value="chronological"/> <parameter key="sort" value="ascending"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> <process expanded="true"> <operator activated="true" class="k_nn" compatibility="9.2.000" expanded="true" height="82" name="k-NN" width="90" x="112" y="34"> <parameter key="k" value="1"/> <parameter key="weighted_vote" value="false"/> <parameter key="measure_types" value="MixedMeasures"/> <parameter key="mixed_measure" value="MixedEuclideanDistance"/> <parameter key="nominal_measure" value="NominalDistance"/> <parameter key="numerical_measure" value="EuclideanDistance"/> <parameter key="divergence" value="GeneralizedIDivergence"/> <parameter key="kernel_type" value="radial"/> <parameter key="kernel_gamma" value="1.0"/> <parameter key="kernel_sigma1" value="1.0"/> <parameter key="kernel_sigma2" value="0.0"/> <parameter key="kernel_sigma3" value="2.0"/> <parameter key="kernel_degree" value="3.0"/> <parameter key="kernel_shift" value="1.0"/> <parameter key="kernel_a" value="1.0"/> <parameter key="kernel_b" value="0.0"/> </operator> <connect from_port="example set source" to_op="k-NN" to_port="training set"/> <connect from_op="k-NN" from_port="model" to_port="model sink"/> <portSpacing port="source_example set source" spacing="0"/> <portSpacing port="sink_model sink" spacing="0"/> </process> </operator> <operator activated="false" class="impute_missing_values" compatibility="7.3.001" expanded="true" height="68" name="Impute Missing Values" width="90" x="313" y="34"> <parameter key="attribute_filter_type" value="value_type"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="nominal"/> <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="iterate" value="true"/> <parameter key="learn_on_complete_cases" value="true"/> <parameter key="order" value="chronological"/> <parameter key="sort" value="ascending"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> <process expanded="true"> <operator activated="true" breakpoints="before,after" class="concurrency:parallel_decision_tree" compatibility="9.2.000" expanded="true" height="103" name="Decision Tree" width="90" x="380" y="34"> <parameter key="criterion" value="gain_ratio"/> <parameter key="maximal_depth" value="20"/> <parameter key="apply_pruning" value="true"/> <parameter key="confidence" value="0.25"/> <parameter key="apply_prepruning" value="true"/> <parameter key="minimal_gain" value="0.1"/> <parameter key="minimal_leaf_size" value="2"/> <parameter key="minimal_size_for_split" value="4"/> <parameter key="number_of_prepruning_alternatives" value="3"/> </operator> <connect from_port="example set source" to_op="Decision Tree" to_port="training set"/> <connect from_op="Decision Tree" from_port="model" to_port="model sink"/> <portSpacing port="source_example set source" spacing="0"/> <portSpacing port="sink_model sink" spacing="0"/> </process> </operator> <operator activated="true" class="impute_missing_values" compatibility="7.3.001" expanded="true" height="68" name="Impute Missing Values (2)" width="90" x="447" y="34"> <parameter key="attribute_filter_type" value="value_type"/> <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="iterate" value="true"/> <parameter key="learn_on_complete_cases" value="true"/> <parameter key="order" value="chronological"/> <parameter key="sort" value="ascending"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> <process expanded="true"> <operator activated="true" breakpoints="before" class="neural_net" compatibility="9.2.000" expanded="true" height="82" name="Neural Net" width="90" x="179" y="34"> <list key="hidden_layers"/> <parameter key="training_cycles" value="500"/> <parameter key="learning_rate" value="0.3"/> <parameter key="momentum" value="0.2"/> <parameter key="decay" value="false"/> <parameter key="shuffle" value="true"/> <parameter key="normalize" value="true"/> <parameter key="error_epsilon" value="1.0E-5"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> </operator> <connect from_port="example set source" to_op="Neural Net" to_port="training set"/> <connect from_op="Neural Net" from_port="model" to_port="model sink"/> <portSpacing port="source_example set source" spacing="0"/> <portSpacing port="sink_model sink" spacing="0"/> </process> </operator> <connect from_port="in 1" to_op="Impute Missing Values (2)" to_port="example set in"/> <connect from_op="Impute Missing Values (2)" from_port="example set out" to_port="out 1"/> <portSpacing port="source_in 1" spacing="0"/> <portSpacing port="source_in 2" spacing="0"/> <portSpacing port="sink_out 1" spacing="0"/> <portSpacing port="sink_out 2" spacing="0"/> <description align="center" color="yellow" colored="false" height="105" resized="false" width="180" x="601" y="506">Type your comment</description> </process> </operator> <operator activated="false" class="replace_missing_values" compatibility="9.2.000" expanded="true" height="103" name="Replace Missing Values" width="90" x="313" y="442"> <parameter key="return_preprocessing_model" value="false"/> <parameter key="create_view" 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="transpose" compatibility="9.2.000" expanded="true" height="82" name="Transpose (2)" width="90" x="715" y="85"/> <operator activated="true" class="generate_id" compatibility="9.2.000" expanded="true" height="82" name="Generate ID (2)" width="90" x="849" y="85"> <parameter key="create_nominal_ids" value="false"/> <parameter key="offset" value="0"/> </operator> <operator activated="true" class="concurrency:join" compatibility="9.2.000" expanded="true" height="82" name="Join" width="90" x="1050" y="136"> <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> <connect from_op="Read Excel" from_port="output" to_op="Transpose" to_port="example set input"/> <connect from_op="Transpose" from_port="example set output" to_op="Filter Example Range" to_port="example set input"/> <connect from_op="Transpose" from_port="original" to_op="Select Attributes" to_port="example set input"/> <connect from_op="Filter Example Range" from_port="example set output" to_op="Impute Missing Values (4)" to_port="example set in"/> <connect from_op="Impute Missing Values (4)" from_port="example set out" to_op="Transpose (2)" to_port="example set input"/> <connect from_op="Select Attributes" from_port="example set output" to_op="Generate ID" to_port="example set input"/> <connect from_op="Generate ID" from_port="example set output" to_op="Join" to_port="left"/> <connect from_op="Transpose (2)" from_port="example set output" to_op="Generate ID (2)" to_port="example set input"/> <connect from_op="Generate ID (2)" from_port="example set output" to_op="Join" to_port="right"/> <connect from_op="Join" from_port="join" 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>
<?xml version="1.0" encoding="UTF-8"?><process version="9.2.000"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="9.2.000" 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="read_excel" compatibility="9.2.000" expanded="true" height="68" name="Read Excel" width="90" x="179" y="85"> <parameter key="excel_file" value="/Users/genzerconsulting/Desktop/Sample_Data_2_Impute.xlsx"/> <parameter key="sheet_selection" value="sheet number"/> <parameter key="sheet_number" value="1"/> <parameter key="imported_cell_range" value="A1"/> <parameter key="encoding" value="SYSTEM"/> <parameter key="first_row_as_names" value="true"/> <list key="annotations"/> <parameter key="date_format" value=""/> <parameter key="time_zone" value="SYSTEM"/> <parameter key="locale" value="English (United States)"/> <parameter key="read_all_values_as_polynominal" value="false"/> <list key="data_set_meta_data_information"> <parameter key="0" value="ID.true.integer.attribute"/> <parameter key="1" value="2017-01.true.integer.attribute"/> <parameter key="2" value="2017-02.true.integer.attribute"/> <parameter key="3" value="2017-03.true.integer.attribute"/> <parameter key="4" value="2017-04.true.integer.attribute"/> <parameter key="5" value="2017-05.true.integer.attribute"/> <parameter key="6" value="2017-06.true.integer.attribute"/> <parameter key="7" value="2017-07.true.integer.attribute"/> <parameter key="8" value="2017-08.true.integer.attribute"/> <parameter key="9" value="2017-09.true.integer.attribute"/> <parameter key="10" value="2017-10.true.integer.attribute"/> <parameter key="11" value="2017-11.true.integer.attribute"/> <parameter key="12" value="2017-12.true.integer.attribute"/> <parameter key="13" value="2018-01.true.integer.attribute"/> <parameter key="14" value="2018-02.true.integer.attribute"/> <parameter key="15" value="2018-03.true.integer.attribute"/> <parameter key="16" value="2018-04.true.integer.attribute"/> <parameter key="17" value="2018-05.true.integer.attribute"/> <parameter key="18" value="2018-06.true.integer.attribute"/> <parameter key="19" value="2018-07.true.integer.attribute"/> <parameter key="20" value="2018-08.true.integer.attribute"/> <parameter key="21" value="2018-09.true.integer.attribute"/> <parameter key="22" value="2018-10.true.integer.attribute"/> <parameter key="23" value="2018-11.true.integer.attribute"/> <parameter key="24" value="2018-12.true.integer.attribute"/> </list> <parameter key="read_not_matching_values_as_missings" value="false"/> <parameter key="datamanagement" value="double_array"/> <parameter key="data_management" value="auto"/> </operator> <operator activated="true" class="transpose" compatibility="9.2.000" expanded="true" height="82" name="Transpose" width="90" x="313" y="85"/> <operator activated="true" breakpoints="after" class="filter_example_range" compatibility="9.2.000" expanded="true" height="82" name="Filter Example Range" width="90" x="447" y="85"> <parameter key="first_example" value="1"/> <parameter key="last_example" value="1"/> <parameter key="invert_filter" value="true"/> </operator> <operator activated="true" class="select_attributes" compatibility="9.2.000" expanded="true" height="82" name="Select Attributes" width="90" x="447" y="187"> <parameter key="attribute_filter_type" value="single"/> <parameter key="attribute" value="ID"/> <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"/> </operator> <operator activated="true" class="generate_id" compatibility="9.2.000" expanded="true" height="82" name="Generate ID" width="90" x="648" y="238"> <parameter key="create_nominal_ids" value="false"/> <parameter key="offset" value="0"/> </operator> <operator activated="false" class="subprocess" compatibility="9.2.000" expanded="true" height="82" name="Subprocess" width="90" x="648" y="442"> <process expanded="true"> <operator activated="false" class="multiply" compatibility="9.2.000" expanded="true" height="68" name="Multiply" width="90" x="45" y="136"/> <operator activated="false" class="materialize_data" compatibility="9.2.000" expanded="true" height="82" name="DT then NN" width="90" x="179" y="34"> <parameter key="datamanagement" value="double_array"/> <parameter key="data_management" value="auto"/> </operator> <operator activated="false" class="materialize_data" compatibility="9.2.000" expanded="true" height="82" name="kNN" width="90" x="246" y="238"> <parameter key="datamanagement" value="double_array"/> <parameter key="data_management" value="auto"/> </operator> <operator activated="false" breakpoints="before" class="impute_missing_values" compatibility="7.3.001" expanded="true" height="68" name="Impute Missing Values (3)" width="90" x="380" y="187"> <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="iterate" value="true"/> <parameter key="learn_on_complete_cases" value="true"/> <parameter key="order" value="chronological"/> <parameter key="sort" value="ascending"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> <process expanded="true"> <operator activated="true" class="k_nn" compatibility="9.2.000" expanded="true" height="82" name="k-NN" width="90" x="112" y="34"> <parameter key="k" value="1"/> <parameter key="weighted_vote" value="false"/> <parameter key="measure_types" value="MixedMeasures"/> <parameter key="mixed_measure" value="MixedEuclideanDistance"/> <parameter key="nominal_measure" value="NominalDistance"/> <parameter key="numerical_measure" value="EuclideanDistance"/> <parameter key="divergence" value="GeneralizedIDivergence"/> <parameter key="kernel_type" value="radial"/> <parameter key="kernel_gamma" value="1.0"/> <parameter key="kernel_sigma1" value="1.0"/> <parameter key="kernel_sigma2" value="0.0"/> <parameter key="kernel_sigma3" value="2.0"/> <parameter key="kernel_degree" value="3.0"/> <parameter key="kernel_shift" value="1.0"/> <parameter key="kernel_a" value="1.0"/> <parameter key="kernel_b" value="0.0"/> </operator> <connect from_port="example set source" to_op="k-NN" to_port="training set"/> <connect from_op="k-NN" from_port="model" to_port="model sink"/> <portSpacing port="source_example set source" spacing="0"/> <portSpacing port="sink_model sink" spacing="0"/> </process> </operator> <operator activated="false" class="impute_missing_values" compatibility="7.3.001" expanded="true" height="68" name="Impute Missing Values" width="90" x="313" y="34"> <parameter key="attribute_filter_type" value="value_type"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="nominal"/> <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="iterate" value="true"/> <parameter key="learn_on_complete_cases" value="true"/> <parameter key="order" value="chronological"/> <parameter key="sort" value="ascending"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> <process expanded="true"> <operator activated="true" breakpoints="before,after" class="concurrency:parallel_decision_tree" compatibility="9.2.000" expanded="true" height="103" name="Decision Tree" width="90" x="380" y="34"> <parameter key="criterion" value="gain_ratio"/> <parameter key="maximal_depth" value="20"/> <parameter key="apply_pruning" value="true"/> <parameter key="confidence" value="0.25"/> <parameter key="apply_prepruning" value="true"/> <parameter key="minimal_gain" value="0.1"/> <parameter key="minimal_leaf_size" value="2"/> <parameter key="minimal_size_for_split" value="4"/> <parameter key="number_of_prepruning_alternatives" value="3"/> </operator> <connect from_port="example set source" to_op="Decision Tree" to_port="training set"/> <connect from_op="Decision Tree" from_port="model" to_port="model sink"/> <portSpacing port="source_example set source" spacing="0"/> <portSpacing port="sink_model sink" spacing="0"/> </process> </operator> <operator activated="true" class="impute_missing_values" compatibility="7.3.001" expanded="true" height="68" name="Impute Missing Values (2)" width="90" x="447" y="34"> <parameter key="attribute_filter_type" value="value_type"/> <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="iterate" value="true"/> <parameter key="learn_on_complete_cases" value="true"/> <parameter key="order" value="chronological"/> <parameter key="sort" value="ascending"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> <process expanded="true"> <operator activated="true" breakpoints="before" class="neural_net" compatibility="9.2.000" expanded="true" height="82" name="Neural Net" width="90" x="179" y="34"> <list key="hidden_layers"/> <parameter key="training_cycles" value="500"/> <parameter key="learning_rate" value="0.3"/> <parameter key="momentum" value="0.2"/> <parameter key="decay" value="false"/> <parameter key="shuffle" value="true"/> <parameter key="normalize" value="true"/> <parameter key="error_epsilon" value="1.0E-5"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> </operator> <connect from_port="example set source" to_op="Neural Net" to_port="training set"/> <connect from_op="Neural Net" from_port="model" to_port="model sink"/> <portSpacing port="source_example set source" spacing="0"/> <portSpacing port="sink_model sink" spacing="0"/> </process> </operator> <connect from_port="in 1" to_op="Impute Missing Values (2)" to_port="example set in"/> <connect from_op="Impute Missing Values (2)" from_port="example set out" to_port="out 1"/> <portSpacing port="source_in 1" spacing="0"/> <portSpacing port="source_in 2" spacing="0"/> <portSpacing port="sink_out 1" spacing="0"/> <portSpacing port="sink_out 2" spacing="0"/> <description align="center" color="yellow" colored="false" height="105" resized="false" width="180" x="601" y="506">Type your comment</description> </process> </operator> <operator activated="false" class="replace_missing_values" compatibility="9.2.000" expanded="true" height="103" name="Replace Missing Values" width="90" x="313" y="442"> <parameter key="return_preprocessing_model" value="false"/> <parameter key="create_view" 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="impute_missing_values" compatibility="9.2.000" expanded="true" height="68" name="Impute Missing Values (4)" width="90" x="581" y="85"> <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="real"/> <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="iterate" value="true"/> <parameter key="learn_on_complete_cases" value="false"/> <parameter key="order" value="chronological"/> <parameter key="sort" value="ascending"/> <parameter key="use_local_random_seed" value="false"/> <parameter key="local_random_seed" value="1992"/> <process expanded="true"> <operator activated="true" class="k_nn" compatibility="9.2.000" expanded="true" height="82" name="k-NN (2)" width="90" x="380" y="34"> <parameter key="k" value="5"/> <parameter key="weighted_vote" value="true"/> <parameter key="measure_types" value="MixedMeasures"/> <parameter key="mixed_measure" value="MixedEuclideanDistance"/> <parameter key="nominal_measure" value="NominalDistance"/> <parameter key="numerical_measure" value="EuclideanDistance"/> <parameter key="divergence" value="GeneralizedIDivergence"/> <parameter key="kernel_type" value="radial"/> <parameter key="kernel_gamma" value="1.0"/> <parameter key="kernel_sigma1" value="1.0"/> <parameter key="kernel_sigma2" value="0.0"/> <parameter key="kernel_sigma3" value="2.0"/> <parameter key="kernel_degree" value="3.0"/> <parameter key="kernel_shift" value="1.0"/> <parameter key="kernel_a" value="1.0"/> <parameter key="kernel_b" value="0.0"/> </operator> <connect from_port="example set source" to_op="k-NN (2)" to_port="training set"/> <connect from_op="k-NN (2)" from_port="model" to_port="model sink"/> <portSpacing port="source_example set source" spacing="0"/> <portSpacing port="sink_model sink" spacing="0"/> </process> </operator> <operator activated="true" class="transpose" compatibility="9.2.000" expanded="true" height="82" name="Transpose (2)" width="90" x="715" y="85"/> <operator activated="true" class="generate_id" compatibility="9.2.000" expanded="true" height="82" name="Generate ID (2)" width="90" x="849" y="85"> <parameter key="create_nominal_ids" value="false"/> <parameter key="offset" value="0"/> </operator> <operator activated="true" class="concurrency:join" compatibility="9.2.000" expanded="true" height="82" name="Join" width="90" x="1050" y="136"> <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> <connect from_op="Read Excel" from_port="output" to_op="Transpose" to_port="example set input"/> <connect from_op="Transpose" from_port="example set output" to_op="Filter Example Range" to_port="example set input"/> <connect from_op="Transpose" from_port="original" to_op="Select Attributes" to_port="example set input"/> <connect from_op="Filter Example Range" from_port="example set output" to_op="Impute Missing Values (4)" to_port="example set in"/> <connect from_op="Select Attributes" from_port="example set output" to_op="Generate ID" to_port="example set input"/> <connect from_op="Generate ID" from_port="example set output" to_op="Join" to_port="left"/> <connect from_op="Impute Missing Values (4)" from_port="example set out" to_op="Transpose (2)" to_port="example set input"/> <connect from_op="Transpose (2)" from_port="example set output" to_op="Generate ID (2)" to_port="example set input"/> <connect from_op="Generate ID (2)" from_port="example set output" to_op="Join" to_port="right"/> <connect from_op="Join" from_port="join" 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>
Lastly, if i try to build a ensemble here, is there any way i can evaluate a imputation performance of various learners ??
As Always Thank you for your valuable advice and time.
Join us for a community conversation on accelerating power electronics design, where you'll learn how to leverage the fast simulation capabilities of Simcenter PSIM alongside the powerful design exploration and optimization features of Simcenter HEEDS. In this webinar, we’ll show how engineers can move beyond manual…
Join us for a community conversation on Pulse Width Modulation (PWM), a fundamental technique in electric motor control, and explore how different PWM strategies can yield significantly different results. This webinar provides a comparative analysis of various PWM methods and their effects on motor efficiency, torque…
Join us for a community conversation to discover the Advanced Iterative Solver(AIS) in Simcenter Feko and its application to electrically large and computationally demanding electromagnetic models. The session will provide a general overview of how iterative solution methods can help improve efficiency of large scale…