I want to predict a value by another values

davidraul36

Hello, I'm very newbie to RapidMiner and data science as well so bear me please.

 

I want to predict values from totally different values, it's like trying to finding a model for the relation between them.

For Example;

I have Excel spreedsheet with cloumns (A, B, C, D, F)

 

I want to use (A, B, C, D) to predict or getting model for the values in (F) then use it to test data...

 

Thanks in advance,

 

Thomas_Ott

@davidraul36 Here's what I would do. Clean up the date and time attributes and use a different algo. 74% trend accuracy and you can most likely optimize that with Optimize Parameters. 

 

<?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="8.0.001" expanded="true" name="Process">
    <parameter key="encoding" value="SYSTEM"/>
    <process expanded="true">
      <operator activated="true" class="read_excel" compatibility="8.0.001" expanded="true" height="68" name="Read Excel" width="90" x="45" y="34">
        <parameter key="excel_file" value="C:\Users\Thomas Ott\Desktop\Feed.xls"/>
        <parameter key="imported_cell_range" value="A1:G3000"/>
        <parameter key="encoding" value="SYSTEM"/>
        <parameter key="first_row_as_names" value="false"/>
        <list key="annotations">
          <parameter key="0" value="Name"/>
        </list>
        <parameter key="date_format" value="yyyy.mm.dd"/>
        <list key="data_set_meta_data_information">
          <parameter key="0" value="Date.true.date.attribute"/>
          <parameter key="1" value="Time.true.time.attribute"/>
          <parameter key="2" value="Open.true.real.attribute"/>
          <parameter key="3" value="High.true.real.attribute"/>
          <parameter key="4" value="Low.true.real.attribute"/>
          <parameter key="5" value="Close.true.real.attribute"/>
          <parameter key="6" value="Avg.true.real.attribute"/>
        </list>
      </operator>
      <operator activated="true" class="generate_concatenation" compatibility="8.0.001" expanded="true" height="82" name="Generate Concatenation" width="90" x="179" y="34">
        <parameter key="first_attribute" value="Date"/>
        <parameter key="second_attribute" value="Time"/>
        <parameter key="separator" value=" "/>
      </operator>
      <operator activated="true" class="select_attributes" compatibility="8.0.001" expanded="true" height="82" name="Select Attributes" width="90" x="313" y="34">
        <parameter key="attribute_filter_type" value="subset"/>
        <parameter key="attributes" value="Date||Time"/>
        <parameter key="invert_selection" value="true"/>
      </operator>
      <operator activated="true" class="nominal_to_date" compatibility="8.0.001" expanded="true" height="82" name="Nominal to Date" width="90" x="447" y="34">
        <parameter key="attribute_name" value="Date Time"/>
        <parameter key="date_type" value="date_time"/>
        <parameter key="date_format" value="MMM dd, yyyy H:mm:ss"/>
      </operator>
      <operator activated="true" class="read_excel" compatibility="8.0.001" expanded="true" height="68" name="Read Excel (2)" width="90" x="45" y="289">
        <parameter key="excel_file" value="C:\Users\Thomas Ott\Desktop\test.xls"/>
        <parameter key="imported_cell_range" value="A1:G703"/>
        <parameter key="encoding" value="SYSTEM"/>
        <parameter key="first_row_as_names" value="false"/>
        <list key="annotations">
          <parameter key="0" value="Name"/>
        </list>
        <parameter key="date_format" value="yyyy.mm.dd"/>
        <list key="data_set_meta_data_information">
          <parameter key="0" value="Date.true.date.attribute"/>
          <parameter key="1" value="Time.true.time.attribute"/>
          <parameter key="2" value="Open.true.real.attribute"/>
          <parameter key="3" value="High.true.real.attribute"/>
          <parameter key="4" value="Low.true.real.attribute"/>
          <parameter key="5" value="Close.true.real.attribute"/>
          <parameter key="6" value="Avg.true.real.attribute"/>
        </list>
      </operator>
      <operator activated="true" class="set_role" compatibility="8.0.001" expanded="true" height="82" name="Set Role" width="90" x="581" y="34">
        <parameter key="attribute_name" value="Date Time"/>
        <parameter key="target_role" value="id"/>
        <list key="set_additional_roles">
          <parameter key="Avg" value="label"/>
        </list>
      </operator>
      <operator activated="true" class="sort" compatibility="8.0.001" expanded="true" height="82" name="Sort" width="90" x="715" y="34">
        <parameter key="attribute_name" value="Date Time"/>
      </operator>
      <operator activated="true" class="series:windowing" compatibility="7.4.000" expanded="true" height="82" name="Windowing" width="90" x="849" y="34">
        <parameter key="window_size" value="1"/>
        <parameter key="create_label" value="true"/>
        <parameter key="label_attribute" value="Avg"/>
      </operator>
      <operator activated="true" class="series:sliding_window_validation" compatibility="7.4.000" expanded="true" height="124" name="Validation" width="90" x="983" y="34">
        <parameter key="training_window_width" value="10"/>
        <parameter key="training_window_step_size" value="5"/>
        <parameter key="test_window_width" value="20"/>
        <parameter key="horizon" value="5"/>
        <parameter key="average_performances_only" value="false"/>
        <process expanded="true">
          <operator activated="true" class="h2o:deep_learning" compatibility="7.6.001" expanded="true" height="82" name="Deep Learning" width="90" x="240" y="34">
            <enumeration key="hidden_layer_sizes">
              <parameter key="hidden_layer_sizes" value="50"/>
              <parameter key="hidden_layer_sizes" value="50"/>
            </enumeration>
            <enumeration key="hidden_dropout_ratios"/>
            <list key="expert_parameters"/>
            <list key="expert_parameters_"/>
          </operator>
          <connect from_port="training" to_op="Deep Learning" to_port="training set"/>
          <connect from_op="Deep Learning" from_port="model" to_port="model"/>
          <portSpacing port="source_training" spacing="0"/>
          <portSpacing port="sink_model" spacing="0"/>
          <portSpacing port="sink_through 1" spacing="0"/>
        </process>
        <process expanded="true">
          <operator activated="true" class="apply_model" compatibility="8.0.001" expanded="true" height="82" name="Apply Model" width="90" x="45" y="34">
            <list key="application_parameters"/>
          </operator>
          <operator activated="true" class="series:forecasting_performance" compatibility="7.4.000" expanded="true" height="82" name="Performance" width="90" x="179" y="34">
            <parameter key="horizon" value="1"/>
          </operator>
          <connect from_port="model" to_op="Apply Model" to_port="model"/>
          <connect from_port="test set" to_op="Apply Model" to_port="unlabelled data"/>
          <connect from_op="Apply Model" from_port="labelled data" to_op="Performance" to_port="labelled data"/>
          <connect from_op="Performance" from_port="performance" to_port="averagable 1"/>
          <portSpacing port="source_model" spacing="0"/>
          <portSpacing port="source_test set" spacing="0"/>
          <portSpacing port="source_through 1" spacing="0"/>
          <portSpacing port="sink_averagable 1" spacing="0"/>
          <portSpacing port="sink_averagable 2" spacing="0"/>
        </process>
      </operator>
      <operator activated="true" class="generate_concatenation" compatibility="8.0.001" expanded="true" height="82" name="Generate Concatenation (2)" width="90" x="179" y="289">
        <parameter key="first_attribute" value="Date"/>
        <parameter key="second_attribute" value="Time"/>
        <parameter key="separator" value=" "/>
      </operator>
      <operator activated="true" class="select_attributes" compatibility="8.0.001" expanded="true" height="82" name="Select Attributes (3)" width="90" x="313" y="289">
        <parameter key="attribute_filter_type" value="subset"/>
        <parameter key="attributes" value="Date||Time"/>
        <parameter key="invert_selection" value="true"/>
      </operator>
      <operator activated="true" class="set_role" compatibility="8.0.001" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="289">
        <parameter key="attribute_name" value="Date Time"/>
        <parameter key="target_role" value="id"/>
        <list key="set_additional_roles">
          <parameter key="Avg" value="dummy"/>
        </list>
      </operator>
      <operator activated="true" class="sort" compatibility="8.0.001" expanded="true" height="82" name="Sort (2)" width="90" x="581" y="289">
        <parameter key="attribute_name" value="Date Time"/>
      </operator>
      <operator activated="true" class="select_attributes" compatibility="8.0.001" expanded="true" height="82" name="Select Attributes (2)" width="90" x="715" y="289">
        <parameter key="attribute_filter_type" value="single"/>
        <parameter key="attribute" value="Avg"/>
        <parameter key="invert_selection" value="true"/>
      </operator>
      <operator activated="true" class="series:windowing" compatibility="7.4.000" expanded="true" height="82" name="Windowing (2)" width="90" x="849" y="187">
        <parameter key="window_size" value="1"/>
        <parameter key="label_attribute" value="Avg"/>
        <parameter key="horizon" value="0"/>
      </operator>
      <operator activated="true" class="apply_model" compatibility="8.0.001" expanded="true" height="82" name="Apply Model (2)" width="90" x="1184" y="187">
        <list key="application_parameters"/>
      </operator>
      <operator activated="true" class="join" compatibility="8.0.001" expanded="true" height="82" name="Join" width="90" x="1318" y="289">
        <list key="key_attributes"/>
      </operator>
      <connect from_op="Read Excel" from_port="output" to_op="Generate Concatenation" to_port="example set input"/>
      <connect from_op="Generate Concatenation" 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="Nominal to Date" to_port="example set input"/>
      <connect from_op="Nominal to Date" from_port="example set output" to_op="Set Role" to_port="example set input"/>
      <connect from_op="Read Excel (2)" from_port="output" to_op="Generate Concatenation (2)" to_port="example set input"/>
      <connect from_op="Set Role" from_port="example set output" to_op="Sort" to_port="example set input"/>
      <connect from_op="Sort" from_port="example set output" to_op="Windowing" to_port="example set input"/>
      <connect from_op="Windowing" from_port="example set output" to_op="Validation" to_port="training"/>
      <connect from_op="Validation" from_port="model" to_op="Apply Model (2)" to_port="model"/>
      <connect from_op="Validation" from_port="training" to_port="result 1"/>
      <connect from_op="Validation" from_port="averagable 1" to_port="result 2"/>
      <connect from_op="Generate Concatenation (2)" from_port="example set output" to_op="Select Attributes (3)" to_port="example set input"/>
      <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Set Role (2)" to_port="example set input"/>
      <connect from_op="Set Role (2)" from_port="example set output" to_op="Sort (2)" to_port="example set input"/>
      <connect from_op="Sort (2)" from_port="example set output" to_op="Select Attributes (2)" to_port="example set input"/>
      <connect from_op="Select Attributes (2)" from_port="example set output" to_op="Windowing (2)" to_port="example set input"/>
      <connect from_op="Select Attributes (2)" from_port="original" to_op="Join" to_port="right"/>
      <connect from_op="Windowing (2)" from_port="example set output" to_op="Apply Model (2)" to_port="unlabelled data"/>
      <connect from_op="Apply Model (2)" from_port="labelled data" to_op="Join" to_port="left"/>
      <connect from_op="Join" from_port="join" to_port="result 3"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
      <portSpacing port="sink_result 3" spacing="0"/>
      <portSpacing port="sink_result 4" spacing="0"/>
    </process>
  </operator>
</process>