Prediction with SVM

elham_calm
elham_calm New Altair Community Member
edited November 5 in Community Q&A
Hello ,
I have a data set that includes data on the heating and cooling loads of a building every hour from one year, and I want to do prediction with the SVM algorithm, but I do not get good results. please guide me!
Tagged:

Best Answers

  • lionelderkrikor
    lionelderkrikor New Altair Community Member
    Answer ✓

    Hi again @elham_calm,

     

    Here a first element of response : I builded a first process with a SVM model, but the predictions were totally fanciful.

    I tried with a Deep Learning model and the predictions are more relevant. Here a screenshot of the predictions of Zone heating  for January 2003 : 

    heat_cooling_forecast.png

     

    However, this process is largely perfectible : I don't observe in these predictions, the same shape as the January 2002 curve.

    In deed, my window size is equal to 40 (hours) and the predictions are made on 1 month. So to improve the accuracy of the predictions

    a next step would be to increase the window size.

     

    You can find the process here : 

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>futureMonths</key>
            <value>15</value>
          </macro>
          <macro>
            <key>horizon</key>
            <value>1</value>
          </macro>
          <macro>
            <key>windowSize</key>
            <value>6</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="8.1.000" expanded="true" height="68" name="Read Excel" width="90" x="45" y="136">
            <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\heating and cooling\heating and cooling loads.xlsx"/>
            <parameter key="imported_cell_range" value="A1:D8762"/>
            <parameter key="first_row_as_names" value="false"/>
            <list key="annotations">
              <parameter key="0" value="Name"/>
            </list>
            <list key="data_set_meta_data_information">
              <parameter key="0" value="Date/Time.true.date_time.attribute"/>
              <parameter key="1" value="Sensible Cooling.true.polynominal.attribute"/>
              <parameter key="2" value="Total Cooling.true.polynominal.attribute"/>
              <parameter key="3" value="Zone Heating.true.polynominal.attribute"/>
            </list>
          </operator>
          <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="179" y="136">
            <parameter key="attribute_name" value="Date/Time"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename (2)" width="90" x="313" y="136">
            <parameter key="old_name" value="Date/Time"/>
            <parameter key="new_name" value="DateTime"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="subprocess" compatibility="8.1.000" expanded="true" height="82" name="Set Predictions_Params" width="90" x="447" y="136">
            <process expanded="true">
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Window_Size" width="90" x="45" y="34">
                <parameter key="macro" value="WindowSize"/>
                <parameter key="value" value="40"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Horizon" width="90" x="179" y="34">
                <parameter key="macro" value="horizon"/>
                <parameter key="value" value="1"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Future_Month" width="90" x="313" y="34">
                <parameter key="macro" value="futureMonth"/>
                <parameter key="value" value="720"/>
              </operator>
              <connect from_port="in 1" to_op="Set Window_Size" to_port="through 1"/>
              <connect from_op="Set Window_Size" from_port="through 1" to_op="Set Horizon" to_port="through 1"/>
              <connect from_op="Set Horizon" from_port="through 1" to_op="Set Future_Month" to_port="through 1"/>
              <connect from_op="Set Future_Month" from_port="through 1" 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"/>
            </process>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="581" y="136">
            <parameter key="attribute_name" value="DateTime"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="715" y="136">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Zone Heating"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="916" y="85">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" breakpoints="after" class="parse_numbers" compatibility="8.1.000" expanded="true" height="82" name="Parse Numbers" width="90" x="1050" y="136"/>
          <operator activated="true" breakpoints="after" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Training" width="90" x="1184" y="136">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Zone Heating"/>
            <parameter key="horizon" value="%{horizon}"/>
          </operator>
          <operator activated="true" class="h2o:deep_learning" compatibility="7.6.001" expanded="true" height="82" name="Deep Learning" width="90" x="1318" 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>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Application" width="90" x="1318" y="187">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="label_attribute" value="inputYt"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Example Count" width="90" x="1519" y="187">
            <parameter key="macro" value="exampleCount"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="1653" y="187">
            <parameter key="first_example" value="%{exampleCount}"/>
            <parameter key="last_example" value="%{exampleCount}"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="1787" y="187">
            <parameter key="name" value="data"/>
          </operator>
          <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="1519" y="34">
            <parameter key="iterations" value="%{futureMonth}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="136">
                <parameter key="name" value="data"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="179" y="30">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="multiply" compatibility="8.1.000" expanded="true" height="103" name="Multiply" width="90" x="447" y="30"/>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="179" y="165"/>
              <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Increase Date (2)" width="90" x="313" y="165">
                <list key="function_descriptions">
                  <parameter key="DateTime" value="date_add(DateTime, 1, DATE_UNIT_HOUR)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="165">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="179" y="289">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="Zone Heating-39"/>
                <parameter key="invert_selection" value="true"/>
              </operator>
              <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="313" y="289">
                <parameter key="old_name" value="Zone Heating-38"/>
                <parameter key="new_name" value="Zone Heating-39"/>
                <list key="rename_additional_attributes">
                  <parameter key="Zone Heating-37" value="Zone Heating-38"/>
                  <parameter key="Zone Heating-36" value="Zone Heating-37"/>
                  <parameter key="Zone Heating-35" value="Zone Heating-36"/>
                  <parameter key="Zone Heating-34" value="Zone Heating-35"/>
                  <parameter key="Zone Heating-33" value="Zone Heating-34"/>
                  <parameter key="Zone Heating-32" value="Zone Heating-33"/>
                  <parameter key="Zone Heating-31" value="Zone Heating-32"/>
                  <parameter key="Zone Heating-30" value="Zone Heating-31"/>
                  <parameter key="Zone Heating-29" value="Zone Heating-30"/>
                  <parameter key="Zone Heating-28" value="Zone Heating-29"/>
                  <parameter key="Zone Heating-27" value="Zone Heating-28"/>
                  <parameter key="Zone Heating-26" value="Zone Heating-27"/>
                  <parameter key="Zone Heating-25" value="Zone Heating-26"/>
                  <parameter key="Zone Heating-24" value="Zone Heating-25"/>
                  <parameter key="Zone Heating-23" value="Zone Heating-24"/>
                  <parameter key="Zone Heating-22" value="Zone Heating-23"/>
                  <parameter key="Zone Heating-21" value="Zone Heating-22"/>
                  <parameter key="Zone Heating-20" value="Zone Heating-21"/>
                  <parameter key="Zone Heating-19" value="Zone Heating-20"/>
                  <parameter key="Zone Heating-18" value="Zone Heating-19"/>
                  <parameter key="Zone Heating-17" value="Zone Heating-18"/>
                  <parameter key="Zone Heating-16" value="Zone Heating-17"/>
                  <parameter key="Zone Heating-15" value="Zone Heating-16"/>
                  <parameter key="Zone Heating-14" value="Zone Heating-15"/>
                  <parameter key="Zone Heating-13" value="Zone Heating-14"/>
                  <parameter key="Zone Heating-12" value="Zone Heating-13"/>
                  <parameter key="Zone Heating-11" value="Zone Heating-12"/>
                  <parameter key="Zone Heating-10" value="Zone Heating-11"/>
                  <parameter key="Zone Heating-9" value="Zone Heating-10"/>
                  <parameter key="Zone Heating-8" value="Zone Heating-9"/>
                  <parameter key="Zone Heating-7" value="Zone Heating-8"/>
                  <parameter key="Zone Heating-6" value="Zone Heating-7"/>
                  <parameter key="Zone Heating-5" value="Zone Heating-6"/>
                  <parameter key="Zone Heating-4" value="Zone Heating-5"/>
                  <parameter key="Zone Heating-3" value="Zone Heating-4"/>
                  <parameter key="Zone Heating-2" value="Zone Heating-3"/>
                  <parameter key="Zone Heating-1" value="Zone Heating-2"/>
                  <parameter key="Zone Heating-0" value="Zone Heating-1"/>
                  <parameter key="prediction(label)" value="Zone Heating-0"/>
                </list>
              </operator>
              <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember (2)" width="90" x="447" y="289">
                <parameter key="name" value="data"/>
              </operator>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Multiply" to_port="input"/>
              <connect from_op="Multiply" from_port="output 1" to_port="output 1"/>
              <connect from_op="Multiply" from_port="output 2" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_op="Increase Date (2)" to_port="example set input"/>
              <connect from_op="Increase Date (2)" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Rename" to_port="example set input"/>
              <connect from_op="Rename" from_port="example set output" to_op="Remember (2)" to_port="store"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="1653" y="34"/>
          <connect from_op="Read Excel" from_port="output" to_op="Sort" to_port="example set input"/>
          <connect from_op="Sort" 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="Set Predictions_Params" to_port="in 1"/>
          <connect from_op="Set Predictions_Params" from_port="out 1" to_op="Set Role" to_port="example set input"/>
          <connect from_op="Set Role" 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="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
          <connect from_op="Parse Numbers" from_port="example set output" to_op="Windowing for Training" to_port="example set input"/>
          <connect from_op="Windowing for Training" from_port="example set output" to_op="Deep Learning" to_port="training set"/>
          <connect from_op="Windowing for Training" from_port="original" to_op="Windowing for Application" to_port="example set input"/>
          <connect from_op="Deep Learning" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Windowing for Application" from_port="example set output" to_op="Extract Example Count" to_port="example set"/>
          <connect from_op="Extract Example Count" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" 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>

    NB : I deleted the second row (the row with units) of your file because it caused trouble in the RapidMiner process.

     

    I hope it helps,

     

    Best regards,

     

     

    Lionel

  • lionelderkrikor
    lionelderkrikor New Altair Community Member
    Answer ✓

    Hello @elham_calm,

     

    Abstract of this post : 

    1. By choosing kNN algorithm,  I think you had a good idea.

    2. Bug with Deep Learning model inside Sliding Window Validation.

     

    1. To answer to your question :

    My point of view is that an algorithm is not good or bad. It is adapted or not adapted to a problem. So you have to experiment

    several algorithms for a given problem (I think that's what you realized according to your posts) and to choose the best one.

    But to compare objectively some models, you need of a performance metrics. In case of a time series problem, like your case,

    the RMSE (Root Mean Squared Error) can be a good choice. Without going into details, this metrics calculate the total difference/distance between the data of your test set and the predictions of a model, so the lower this indicator, the better the model.

    To implement that in RapidMiner in your case, like said @Thomas_Ott, we use the Sliding Window Validation operator with inside

    the model to test and the Performance (Regression) operator (which calculate the RMSE).

     

    The results (mean value of RMSE) are the following : 

    RMSE(SVM) = 22,360

    RMSE(kNN) = 15,869

    RMSE(Deep Learning) = ?????

    We can conclude too that kNN is the best algorithm in your case (but you can continue your experimentations with other models).

     

    When running the process with the Deep Learning, the process raise the following error : 

    Model training error (H2O) : ....... response cannot be constant.

     

    Does anyone have an idea of the cause ?

     

    Thanks you,

     

    Here the process : 

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>futureMonths</key>
            <value>15</value>
          </macro>
          <macro>
            <key>horizon</key>
            <value>1</value>
          </macro>
          <macro>
            <key>windowSize</key>
            <value>6</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="8.1.000" expanded="true" height="68" name="Read Excel" width="90" x="45" y="136">
            <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\heating and cooling\heating and cooling loads.xlsx"/>
            <parameter key="imported_cell_range" value="A1:D8762"/>
            <parameter key="first_row_as_names" value="false"/>
            <list key="annotations">
              <parameter key="0" value="Name"/>
            </list>
            <list key="data_set_meta_data_information">
              <parameter key="0" value="Date/Time.true.date_time.attribute"/>
              <parameter key="1" value="Sensible Cooling.true.polynominal.attribute"/>
              <parameter key="2" value="Total Cooling.true.polynominal.attribute"/>
              <parameter key="3" value="Zone Heating.true.polynominal.attribute"/>
            </list>
          </operator>
          <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="179" y="136">
            <parameter key="attribute_name" value="Date/Time"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename (2)" width="90" x="313" y="136">
            <parameter key="old_name" value="Date/Time"/>
            <parameter key="new_name" value="DateTime"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="subprocess" compatibility="8.1.000" expanded="true" height="82" name="Set Predictions_Params" width="90" x="447" y="136">
            <process expanded="true">
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Window_Size" width="90" x="45" y="34">
                <parameter key="macro" value="WindowSize"/>
                <parameter key="value" value="40"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Horizon" width="90" x="179" y="34">
                <parameter key="macro" value="horizon"/>
                <parameter key="value" value="1"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Future_Month" width="90" x="313" y="34">
                <parameter key="macro" value="futureMonth"/>
                <parameter key="value" value="720"/>
              </operator>
              <connect from_port="in 1" to_op="Set Window_Size" to_port="through 1"/>
              <connect from_op="Set Window_Size" from_port="through 1" to_op="Set Horizon" to_port="through 1"/>
              <connect from_op="Set Horizon" from_port="through 1" to_op="Set Future_Month" to_port="through 1"/>
              <connect from_op="Set Future_Month" from_port="through 1" 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"/>
            </process>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="581" y="136">
            <parameter key="attribute_name" value="DateTime"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="715" y="136">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Zone Heating"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="916" y="85">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" class="parse_numbers" compatibility="8.1.000" expanded="true" height="82" name="Parse Numbers" width="90" x="1050" y="136"/>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Training" width="90" x="1184" y="136">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Zone Heating"/>
            <parameter key="horizon" value="%{horizon}"/>
          </operator>
          <operator activated="true" class="series:sliding_window_validation" compatibility="7.4.000" expanded="true" height="124" name="Validation" width="90" x="1318" y="34">
            <parameter key="training_window_width" value="40"/>
            <parameter key="test_window_width" value="20"/>
            <process expanded="true">
              <operator activated="true" class="h2o:deep_learning" compatibility="7.6.001" expanded="true" height="82" name="Deep Learning" width="90" x="179" 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.1.000" expanded="true" height="82" name="Apply Model (2)" width="90" x="112" y="34">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="performance_regression" compatibility="8.1.000" expanded="true" height="82" name="Performance" width="90" x="246" y="34"/>
              <connect from_port="model" to_op="Apply Model (2)" to_port="model"/>
              <connect from_port="test set" to_op="Apply Model (2)" to_port="unlabelled data"/>
              <connect from_op="Apply Model (2)" 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="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Application" width="90" x="1318" y="187">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="label_attribute" value="inputYt"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Example Count" width="90" x="1519" y="187">
            <parameter key="macro" value="exampleCount"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="1653" y="187">
            <parameter key="first_example" value="%{exampleCount}"/>
            <parameter key="last_example" value="%{exampleCount}"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="1787" y="187">
            <parameter key="name" value="data"/>
          </operator>
          <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="1519" y="34">
            <parameter key="iterations" value="%{futureMonth}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="136">
                <parameter key="name" value="data"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="179" y="30">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="multiply" compatibility="8.1.000" expanded="true" height="103" name="Multiply" width="90" x="447" y="30"/>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="179" y="165"/>
              <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Increase Date (2)" width="90" x="313" y="165">
                <list key="function_descriptions">
                  <parameter key="DateTime" value="date_add(DateTime, 1, DATE_UNIT_HOUR)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="165">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="179" y="289">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="Zone Heating-39"/>
                <parameter key="invert_selection" value="true"/>
              </operator>
              <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="313" y="289">
                <parameter key="old_name" value="Zone Heating-38"/>
                <parameter key="new_name" value="Zone Heating-39"/>
                <list key="rename_additional_attributes">
                  <parameter key="Zone Heating-37" value="Zone Heating-38"/>
                  <parameter key="Zone Heating-36" value="Zone Heating-37"/>
                  <parameter key="Zone Heating-35" value="Zone Heating-36"/>
                  <parameter key="Zone Heating-34" value="Zone Heating-35"/>
                  <parameter key="Zone Heating-33" value="Zone Heating-34"/>
                  <parameter key="Zone Heating-32" value="Zone Heating-33"/>
                  <parameter key="Zone Heating-31" value="Zone Heating-32"/>
                  <parameter key="Zone Heating-30" value="Zone Heating-31"/>
                  <parameter key="Zone Heating-29" value="Zone Heating-30"/>
                  <parameter key="Zone Heating-28" value="Zone Heating-29"/>
                  <parameter key="Zone Heating-27" value="Zone Heating-28"/>
                  <parameter key="Zone Heating-26" value="Zone Heating-27"/>
                  <parameter key="Zone Heating-25" value="Zone Heating-26"/>
                  <parameter key="Zone Heating-24" value="Zone Heating-25"/>
                  <parameter key="Zone Heating-23" value="Zone Heating-24"/>
                  <parameter key="Zone Heating-22" value="Zone Heating-23"/>
                  <parameter key="Zone Heating-21" value="Zone Heating-22"/>
                  <parameter key="Zone Heating-20" value="Zone Heating-21"/>
                  <parameter key="Zone Heating-19" value="Zone Heating-20"/>
                  <parameter key="Zone Heating-18" value="Zone Heating-19"/>
                  <parameter key="Zone Heating-17" value="Zone Heating-18"/>
                  <parameter key="Zone Heating-16" value="Zone Heating-17"/>
                  <parameter key="Zone Heating-15" value="Zone Heating-16"/>
                  <parameter key="Zone Heating-14" value="Zone Heating-15"/>
                  <parameter key="Zone Heating-13" value="Zone Heating-14"/>
                  <parameter key="Zone Heating-12" value="Zone Heating-13"/>
                  <parameter key="Zone Heating-11" value="Zone Heating-12"/>
                  <parameter key="Zone Heating-10" value="Zone Heating-11"/>
                  <parameter key="Zone Heating-9" value="Zone Heating-10"/>
                  <parameter key="Zone Heating-8" value="Zone Heating-9"/>
                  <parameter key="Zone Heating-7" value="Zone Heating-8"/>
                  <parameter key="Zone Heating-6" value="Zone Heating-7"/>
                  <parameter key="Zone Heating-5" value="Zone Heating-6"/>
                  <parameter key="Zone Heating-4" value="Zone Heating-5"/>
                  <parameter key="Zone Heating-3" value="Zone Heating-4"/>
                  <parameter key="Zone Heating-2" value="Zone Heating-3"/>
                  <parameter key="Zone Heating-1" value="Zone Heating-2"/>
                  <parameter key="Zone Heating-0" value="Zone Heating-1"/>
                  <parameter key="prediction(label)" value="Zone Heating-0"/>
                </list>
              </operator>
              <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember (2)" width="90" x="447" y="289">
                <parameter key="name" value="data"/>
              </operator>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Multiply" to_port="input"/>
              <connect from_op="Multiply" from_port="output 1" to_port="output 1"/>
              <connect from_op="Multiply" from_port="output 2" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_op="Increase Date (2)" to_port="example set input"/>
              <connect from_op="Increase Date (2)" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Rename" to_port="example set input"/>
              <connect from_op="Rename" from_port="example set output" to_op="Remember (2)" to_port="store"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="1653" y="34"/>
          <connect from_op="Read Excel" from_port="output" to_op="Sort" to_port="example set input"/>
          <connect from_op="Sort" 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="Set Predictions_Params" to_port="in 1"/>
          <connect from_op="Set Predictions_Params" from_port="out 1" to_op="Set Role" to_port="example set input"/>
          <connect from_op="Set Role" 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="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
          <connect from_op="Parse Numbers" from_port="example set output" to_op="Windowing for Training" to_port="example set input"/>
          <connect from_op="Windowing for Training" from_port="example set output" to_op="Validation" to_port="training"/>
          <connect from_op="Windowing for Training" from_port="original" to_op="Windowing for Application" to_port="example set input"/>
          <connect from_op="Validation" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Validation" from_port="averagable 1" to_port="result 2"/>
          <connect from_op="Windowing for Application" from_port="example set output" to_op="Extract Example Count" to_port="example set"/>
          <connect from_op="Extract Example Count" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" 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"/>
          <portSpacing port="sink_result 3" spacing="0"/>
        </process>
      </operator>
    </process>

     

     

     

    2. To have an idea of the relative performances of the models (and mostly the relative performance of Deep learning), I decided, exceptionally, to use the Cross Validation operator (instead Sliding Window Validation operator) .

    The results (mean value of RMSE) are the following : 

    RMSE(SVM) = 144,567

    RMSE(Deep Learning) = 34,355

    RMSE(kNN) = 13,174

     

    With these results, we can conclude too that kNN is the best algorithm in your case 

     

    NB : Thanks to the communauty, to correct me, if these method is not applicable to have an idea of the relativ

    performances of some models.

     

    You can find the process here :

     

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>futureMonths</key>
            <value>15</value>
          </macro>
          <macro>
            <key>horizon</key>
            <value>1</value>
          </macro>
          <macro>
            <key>windowSize</key>
            <value>6</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="8.1.000" expanded="true" height="68" name="Read Excel" width="90" x="45" y="136">
            <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\heating and cooling\heating and cooling loads.xlsx"/>
            <parameter key="imported_cell_range" value="A1:D8762"/>
            <parameter key="first_row_as_names" value="false"/>
            <list key="annotations">
              <parameter key="0" value="Name"/>
            </list>
            <list key="data_set_meta_data_information">
              <parameter key="0" value="Date/Time.true.date_time.attribute"/>
              <parameter key="1" value="Sensible Cooling.true.polynominal.attribute"/>
              <parameter key="2" value="Total Cooling.true.polynominal.attribute"/>
              <parameter key="3" value="Zone Heating.true.polynominal.attribute"/>
            </list>
          </operator>
          <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="179" y="136">
            <parameter key="attribute_name" value="Date/Time"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename (2)" width="90" x="313" y="136">
            <parameter key="old_name" value="Date/Time"/>
            <parameter key="new_name" value="DateTime"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="subprocess" compatibility="8.1.000" expanded="true" height="82" name="Set Predictions_Params" width="90" x="447" y="136">
            <process expanded="true">
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Window_Size" width="90" x="45" y="34">
                <parameter key="macro" value="WindowSize"/>
                <parameter key="value" value="40"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Horizon" width="90" x="179" y="34">
                <parameter key="macro" value="horizon"/>
                <parameter key="value" value="1"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Future_Month" width="90" x="313" y="34">
                <parameter key="macro" value="futureMonth"/>
                <parameter key="value" value="720"/>
              </operator>
              <connect from_port="in 1" to_op="Set Window_Size" to_port="through 1"/>
              <connect from_op="Set Window_Size" from_port="through 1" to_op="Set Horizon" to_port="through 1"/>
              <connect from_op="Set Horizon" from_port="through 1" to_op="Set Future_Month" to_port="through 1"/>
              <connect from_op="Set Future_Month" from_port="through 1" 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"/>
            </process>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="581" y="136">
            <parameter key="attribute_name" value="DateTime"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="715" y="136">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Zone Heating"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="916" y="85">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" class="parse_numbers" compatibility="8.1.000" expanded="true" height="82" name="Parse Numbers" width="90" x="1050" y="136"/>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Training" width="90" x="1184" y="136">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Zone Heating"/>
            <parameter key="horizon" value="%{horizon}"/>
          </operator>
          <operator activated="true" class="concurrency:cross_validation" compatibility="8.1.000" expanded="true" height="145" name="Cross Validation" width="90" x="1318" y="34">
            <process expanded="true">
              <operator activated="true" class="k_nn" compatibility="8.1.000" expanded="true" height="82" name="k-NN" width="90" x="179" y="34"/>
              <connect from_port="training set" to_op="k-NN" to_port="training set"/>
              <connect from_op="k-NN" from_port="model" to_port="model"/>
              <portSpacing port="source_training set" 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.1.000" expanded="true" height="82" name="Apply Model (2)" width="90" x="112" y="34">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="performance_regression" compatibility="8.1.000" expanded="true" height="82" name="Performance" width="90" x="246" y="34"/>
              <connect from_port="model" to_op="Apply Model (2)" to_port="model"/>
              <connect from_port="test set" to_op="Apply Model (2)" to_port="unlabelled data"/>
              <connect from_op="Apply Model (2)" from_port="labelled data" to_op="Performance" to_port="labelled data"/>
              <connect from_op="Performance" from_port="performance" to_port="performance 1"/>
              <portSpacing port="source_model" spacing="0"/>
              <portSpacing port="source_test set" spacing="0"/>
              <portSpacing port="source_through 1" spacing="0"/>
              <portSpacing port="sink_test set results" spacing="0"/>
              <portSpacing port="sink_performance 1" spacing="0"/>
              <portSpacing port="sink_performance 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Application" width="90" x="1318" y="187">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="label_attribute" value="inputYt"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Example Count" width="90" x="1519" y="187">
            <parameter key="macro" value="exampleCount"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="1653" y="187">
            <parameter key="first_example" value="%{exampleCount}"/>
            <parameter key="last_example" value="%{exampleCount}"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="1787" y="187">
            <parameter key="name" value="data"/>
          </operator>
          <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="1519" y="34">
            <parameter key="iterations" value="%{futureMonth}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="136">
                <parameter key="name" value="data"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="179" y="30">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="multiply" compatibility="8.1.000" expanded="true" height="103" name="Multiply" width="90" x="447" y="30"/>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="179" y="165"/>
              <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Increase Date (2)" width="90" x="313" y="165">
                <list key="function_descriptions">
                  <parameter key="DateTime" value="date_add(DateTime, 1, DATE_UNIT_HOUR)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="165">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="179" y="289">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="Zone Heating-39"/>
                <parameter key="invert_selection" value="true"/>
              </operator>
              <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="313" y="289">
                <parameter key="old_name" value="Zone Heating-38"/>
                <parameter key="new_name" value="Zone Heating-39"/>
                <list key="rename_additional_attributes">
                  <parameter key="Zone Heating-37" value="Zone Heating-38"/>
                  <parameter key="Zone Heating-36" value="Zone Heating-37"/>
                  <parameter key="Zone Heating-35" value="Zone Heating-36"/>
                  <parameter key="Zone Heating-34" value="Zone Heating-35"/>
                  <parameter key="Zone Heating-33" value="Zone Heating-34"/>
                  <parameter key="Zone Heating-32" value="Zone Heating-33"/>
                  <parameter key="Zone Heating-31" value="Zone Heating-32"/>
                  <parameter key="Zone Heating-30" value="Zone Heating-31"/>
                  <parameter key="Zone Heating-29" value="Zone Heating-30"/>
                  <parameter key="Zone Heating-28" value="Zone Heating-29"/>
                  <parameter key="Zone Heating-27" value="Zone Heating-28"/>
                  <parameter key="Zone Heating-26" value="Zone Heating-27"/>
                  <parameter key="Zone Heating-25" value="Zone Heating-26"/>
                  <parameter key="Zone Heating-24" value="Zone Heating-25"/>
                  <parameter key="Zone Heating-23" value="Zone Heating-24"/>
                  <parameter key="Zone Heating-22" value="Zone Heating-23"/>
                  <parameter key="Zone Heating-21" value="Zone Heating-22"/>
                  <parameter key="Zone Heating-20" value="Zone Heating-21"/>
                  <parameter key="Zone Heating-19" value="Zone Heating-20"/>
                  <parameter key="Zone Heating-18" value="Zone Heating-19"/>
                  <parameter key="Zone Heating-17" value="Zone Heating-18"/>
                  <parameter key="Zone Heating-16" value="Zone Heating-17"/>
                  <parameter key="Zone Heating-15" value="Zone Heating-16"/>
                  <parameter key="Zone Heating-14" value="Zone Heating-15"/>
                  <parameter key="Zone Heating-13" value="Zone Heating-14"/>
                  <parameter key="Zone Heating-12" value="Zone Heating-13"/>
                  <parameter key="Zone Heating-11" value="Zone Heating-12"/>
                  <parameter key="Zone Heating-10" value="Zone Heating-11"/>
                  <parameter key="Zone Heating-9" value="Zone Heating-10"/>
                  <parameter key="Zone Heating-8" value="Zone Heating-9"/>
                  <parameter key="Zone Heating-7" value="Zone Heating-8"/>
                  <parameter key="Zone Heating-6" value="Zone Heating-7"/>
                  <parameter key="Zone Heating-5" value="Zone Heating-6"/>
                  <parameter key="Zone Heating-4" value="Zone Heating-5"/>
                  <parameter key="Zone Heating-3" value="Zone Heating-4"/>
                  <parameter key="Zone Heating-2" value="Zone Heating-3"/>
                  <parameter key="Zone Heating-1" value="Zone Heating-2"/>
                  <parameter key="Zone Heating-0" value="Zone Heating-1"/>
                  <parameter key="prediction(label)" value="Zone Heating-0"/>
                </list>
              </operator>
              <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember (2)" width="90" x="447" y="289">
                <parameter key="name" value="data"/>
              </operator>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Multiply" to_port="input"/>
              <connect from_op="Multiply" from_port="output 1" to_port="output 1"/>
              <connect from_op="Multiply" from_port="output 2" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_op="Increase Date (2)" to_port="example set input"/>
              <connect from_op="Increase Date (2)" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Rename" to_port="example set input"/>
              <connect from_op="Rename" from_port="example set output" to_op="Remember (2)" to_port="store"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="1653" y="34"/>
          <connect from_op="Read Excel" from_port="output" to_op="Sort" to_port="example set input"/>
          <connect from_op="Sort" 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="Set Predictions_Params" to_port="in 1"/>
          <connect from_op="Set Predictions_Params" from_port="out 1" to_op="Set Role" to_port="example set input"/>
          <connect from_op="Set Role" 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="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
          <connect from_op="Parse Numbers" from_port="example set output" to_op="Windowing for Training" to_port="example set input"/>
          <connect from_op="Windowing for Training" from_port="example set output" to_op="Cross Validation" to_port="example set"/>
          <connect from_op="Windowing for Training" from_port="original" to_op="Windowing for Application" to_port="example set input"/>
          <connect from_op="Cross Validation" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Cross Validation" from_port="performance 1" to_port="result 2"/>
          <connect from_op="Windowing for Application" from_port="example set output" to_op="Extract Example Count" to_port="example set"/>
          <connect from_op="Extract Example Count" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" 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"/>
          <portSpacing port="sink_result 3" spacing="0"/>
        </process>
      </operator>
    </process>

     

     

    I hope, that  I helped you find the best model for your project.

     

    Best regards,

     

    Lionel

     

     

     

     

     

     

     

     

Answers

  • lionelderkrikor
    lionelderkrikor New Altair Community Member

    Hi @elham_calm,

     

    1. First to know as performant is your model, you can use the Cross-validation operator : the results of this operator are differents score metrics (accuracy, recall, precision etc.) to measure the performance of your model.

    2. "but I do not get good results" Maybe SVM is not the best model for your data. But it's difficult to help you more without your dataset. : Can you share it ?

     

    I hope it helps

     

    Regards,

     

    Lionel

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    @elham_calm if this is a time series problem, using a standard Cross Validation is not the way to go. You will need to use the Sliding Window Validation operator. 

  • elham_calm
    elham_calm New Altair Community Member
    Elham Rafieipour:
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="7.1.001">
    <operator activated="true" class="retrieve" compatibility="7.1.001" expanded="true" height="68" name="Retrieve totall" width="90" x="45" y="136">
    <parameter key="repository_entry" value="//Local Repository/totall"/>
    </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="7.1.001">
    <operator activated="true" class="write_csv" compatibility="7.1.001" expanded="true" height="82" name="Write CSV" width="90" x="179" y="289">
    <parameter key="csv_file" value="heating zone"/>
    <parameter key="column_separator" value=","/>
    <parameter key="write_attribute_names" value="true"/>
    <parameter key="quote_nominal_values" value="true"/>
    <parameter key="format_date_attributes" value="true"/>
    <parameter key="append_to_file" value="false"/>
    <parameter key="encoding" value="SYSTEM"/>
    </operator>
    </process>
  • elham_calm
    elham_calm New Altair Community Member
    How can I share Excel file here?
  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    @elham_calm your process is corrupted, you must open the XML view and copy and paste it from there. Also use the </> format button so it doesn't misread your XML code and make emoticons from it. You can upload a zip file I beleive for your data file.

  • elham_calm
    elham_calm New Altair Community Member
  • elham_calm
    elham_calm New Altair Community Member
    And
    If I got a proper model on my dataset to predict the heat load of the building, how do I get a graph for the next month for example?
  • lionelderkrikor
    lionelderkrikor New Altair Community Member

    Hi again @elham_calm,

     

    I can not open your .xlsx file after dezipping it with Winrar.

    Can you verify it or post your file on Google Drive or OneDrive and share the link in this forum.

     

    Regards,

     

     

    Lionel

  • elham_calm
    elham_calm New Altair Community Member
    Yes
    It is :
    https://drive.google.com/file/d/1y8_kJxlIh4URPRxQsiuBU4RG7sQC3F00/view?usp=drivesdk
  • lionelderkrikor
    lionelderkrikor New Altair Community Member
    Answer ✓

    Hi again @elham_calm,

     

    Here a first element of response : I builded a first process with a SVM model, but the predictions were totally fanciful.

    I tried with a Deep Learning model and the predictions are more relevant. Here a screenshot of the predictions of Zone heating  for January 2003 : 

    heat_cooling_forecast.png

     

    However, this process is largely perfectible : I don't observe in these predictions, the same shape as the January 2002 curve.

    In deed, my window size is equal to 40 (hours) and the predictions are made on 1 month. So to improve the accuracy of the predictions

    a next step would be to increase the window size.

     

    You can find the process here : 

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>futureMonths</key>
            <value>15</value>
          </macro>
          <macro>
            <key>horizon</key>
            <value>1</value>
          </macro>
          <macro>
            <key>windowSize</key>
            <value>6</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="8.1.000" expanded="true" height="68" name="Read Excel" width="90" x="45" y="136">
            <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\heating and cooling\heating and cooling loads.xlsx"/>
            <parameter key="imported_cell_range" value="A1:D8762"/>
            <parameter key="first_row_as_names" value="false"/>
            <list key="annotations">
              <parameter key="0" value="Name"/>
            </list>
            <list key="data_set_meta_data_information">
              <parameter key="0" value="Date/Time.true.date_time.attribute"/>
              <parameter key="1" value="Sensible Cooling.true.polynominal.attribute"/>
              <parameter key="2" value="Total Cooling.true.polynominal.attribute"/>
              <parameter key="3" value="Zone Heating.true.polynominal.attribute"/>
            </list>
          </operator>
          <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="179" y="136">
            <parameter key="attribute_name" value="Date/Time"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename (2)" width="90" x="313" y="136">
            <parameter key="old_name" value="Date/Time"/>
            <parameter key="new_name" value="DateTime"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="subprocess" compatibility="8.1.000" expanded="true" height="82" name="Set Predictions_Params" width="90" x="447" y="136">
            <process expanded="true">
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Window_Size" width="90" x="45" y="34">
                <parameter key="macro" value="WindowSize"/>
                <parameter key="value" value="40"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Horizon" width="90" x="179" y="34">
                <parameter key="macro" value="horizon"/>
                <parameter key="value" value="1"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Future_Month" width="90" x="313" y="34">
                <parameter key="macro" value="futureMonth"/>
                <parameter key="value" value="720"/>
              </operator>
              <connect from_port="in 1" to_op="Set Window_Size" to_port="through 1"/>
              <connect from_op="Set Window_Size" from_port="through 1" to_op="Set Horizon" to_port="through 1"/>
              <connect from_op="Set Horizon" from_port="through 1" to_op="Set Future_Month" to_port="through 1"/>
              <connect from_op="Set Future_Month" from_port="through 1" 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"/>
            </process>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="581" y="136">
            <parameter key="attribute_name" value="DateTime"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="715" y="136">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Zone Heating"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="916" y="85">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" breakpoints="after" class="parse_numbers" compatibility="8.1.000" expanded="true" height="82" name="Parse Numbers" width="90" x="1050" y="136"/>
          <operator activated="true" breakpoints="after" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Training" width="90" x="1184" y="136">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Zone Heating"/>
            <parameter key="horizon" value="%{horizon}"/>
          </operator>
          <operator activated="true" class="h2o:deep_learning" compatibility="7.6.001" expanded="true" height="82" name="Deep Learning" width="90" x="1318" 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>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Application" width="90" x="1318" y="187">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="label_attribute" value="inputYt"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Example Count" width="90" x="1519" y="187">
            <parameter key="macro" value="exampleCount"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="1653" y="187">
            <parameter key="first_example" value="%{exampleCount}"/>
            <parameter key="last_example" value="%{exampleCount}"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="1787" y="187">
            <parameter key="name" value="data"/>
          </operator>
          <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="1519" y="34">
            <parameter key="iterations" value="%{futureMonth}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="136">
                <parameter key="name" value="data"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="179" y="30">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="multiply" compatibility="8.1.000" expanded="true" height="103" name="Multiply" width="90" x="447" y="30"/>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="179" y="165"/>
              <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Increase Date (2)" width="90" x="313" y="165">
                <list key="function_descriptions">
                  <parameter key="DateTime" value="date_add(DateTime, 1, DATE_UNIT_HOUR)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="165">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="179" y="289">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="Zone Heating-39"/>
                <parameter key="invert_selection" value="true"/>
              </operator>
              <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="313" y="289">
                <parameter key="old_name" value="Zone Heating-38"/>
                <parameter key="new_name" value="Zone Heating-39"/>
                <list key="rename_additional_attributes">
                  <parameter key="Zone Heating-37" value="Zone Heating-38"/>
                  <parameter key="Zone Heating-36" value="Zone Heating-37"/>
                  <parameter key="Zone Heating-35" value="Zone Heating-36"/>
                  <parameter key="Zone Heating-34" value="Zone Heating-35"/>
                  <parameter key="Zone Heating-33" value="Zone Heating-34"/>
                  <parameter key="Zone Heating-32" value="Zone Heating-33"/>
                  <parameter key="Zone Heating-31" value="Zone Heating-32"/>
                  <parameter key="Zone Heating-30" value="Zone Heating-31"/>
                  <parameter key="Zone Heating-29" value="Zone Heating-30"/>
                  <parameter key="Zone Heating-28" value="Zone Heating-29"/>
                  <parameter key="Zone Heating-27" value="Zone Heating-28"/>
                  <parameter key="Zone Heating-26" value="Zone Heating-27"/>
                  <parameter key="Zone Heating-25" value="Zone Heating-26"/>
                  <parameter key="Zone Heating-24" value="Zone Heating-25"/>
                  <parameter key="Zone Heating-23" value="Zone Heating-24"/>
                  <parameter key="Zone Heating-22" value="Zone Heating-23"/>
                  <parameter key="Zone Heating-21" value="Zone Heating-22"/>
                  <parameter key="Zone Heating-20" value="Zone Heating-21"/>
                  <parameter key="Zone Heating-19" value="Zone Heating-20"/>
                  <parameter key="Zone Heating-18" value="Zone Heating-19"/>
                  <parameter key="Zone Heating-17" value="Zone Heating-18"/>
                  <parameter key="Zone Heating-16" value="Zone Heating-17"/>
                  <parameter key="Zone Heating-15" value="Zone Heating-16"/>
                  <parameter key="Zone Heating-14" value="Zone Heating-15"/>
                  <parameter key="Zone Heating-13" value="Zone Heating-14"/>
                  <parameter key="Zone Heating-12" value="Zone Heating-13"/>
                  <parameter key="Zone Heating-11" value="Zone Heating-12"/>
                  <parameter key="Zone Heating-10" value="Zone Heating-11"/>
                  <parameter key="Zone Heating-9" value="Zone Heating-10"/>
                  <parameter key="Zone Heating-8" value="Zone Heating-9"/>
                  <parameter key="Zone Heating-7" value="Zone Heating-8"/>
                  <parameter key="Zone Heating-6" value="Zone Heating-7"/>
                  <parameter key="Zone Heating-5" value="Zone Heating-6"/>
                  <parameter key="Zone Heating-4" value="Zone Heating-5"/>
                  <parameter key="Zone Heating-3" value="Zone Heating-4"/>
                  <parameter key="Zone Heating-2" value="Zone Heating-3"/>
                  <parameter key="Zone Heating-1" value="Zone Heating-2"/>
                  <parameter key="Zone Heating-0" value="Zone Heating-1"/>
                  <parameter key="prediction(label)" value="Zone Heating-0"/>
                </list>
              </operator>
              <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember (2)" width="90" x="447" y="289">
                <parameter key="name" value="data"/>
              </operator>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Multiply" to_port="input"/>
              <connect from_op="Multiply" from_port="output 1" to_port="output 1"/>
              <connect from_op="Multiply" from_port="output 2" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_op="Increase Date (2)" to_port="example set input"/>
              <connect from_op="Increase Date (2)" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Rename" to_port="example set input"/>
              <connect from_op="Rename" from_port="example set output" to_op="Remember (2)" to_port="store"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="1653" y="34"/>
          <connect from_op="Read Excel" from_port="output" to_op="Sort" to_port="example set input"/>
          <connect from_op="Sort" 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="Set Predictions_Params" to_port="in 1"/>
          <connect from_op="Set Predictions_Params" from_port="out 1" to_op="Set Role" to_port="example set input"/>
          <connect from_op="Set Role" 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="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
          <connect from_op="Parse Numbers" from_port="example set output" to_op="Windowing for Training" to_port="example set input"/>
          <connect from_op="Windowing for Training" from_port="example set output" to_op="Deep Learning" to_port="training set"/>
          <connect from_op="Windowing for Training" from_port="original" to_op="Windowing for Application" to_port="example set input"/>
          <connect from_op="Deep Learning" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Windowing for Application" from_port="example set output" to_op="Extract Example Count" to_port="example set"/>
          <connect from_op="Extract Example Count" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" 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>

    NB : I deleted the second row (the row with units) of your file because it caused trouble in the RapidMiner process.

     

    I hope it helps,

     

    Best regards,

     

     

    Lionel

  • elham_calm
    elham_calm New Altair Community Member

    Thanks alot,

    if I copy and paste in this version of RapidMiner that you did it

    @lionelderkrikor wrote:

    Hi again @elham_calm,

     

    Here a first element of response : I builded a first process with a SVM model, but the predictions were totally fanciful.

    I tried with a Deep Learning model and the predictions are more relevant. Here a screenshot of the predictions of Zone heating  for January 2003 : 

    heat_cooling_forecast.png

     

    However, this process is largely perfectible : I don't observe in these predictions, the same shape as the January 2002 curve.

    In deed, my window size is equal to 40 (hours) and the predictions are made on 1 month. So to improve the accuracy of the predictions

    a next step would be to increase the window size.

     

    You can find the process here : 

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>futureMonths</key>
            <value>15</value>
          </macro>
          <macro>
            <key>horizon</key>
            <value>1</value>
          </macro>
          <macro>
            <key>windowSize</key>
            <value>6</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="8.1.000" expanded="true" height="68" name="Read Excel" width="90" x="45" y="136">
            <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\heating and cooling\heating and cooling loads.xlsx"/>
            <parameter key="imported_cell_range" value="A1:D8762"/>
            <parameter key="first_row_as_names" value="false"/>
            <list key="annotations">
              <parameter key="0" value="Name"/>
            </list>
            <list key="data_set_meta_data_information">
              <parameter key="0" value="Date/Time.true.date_time.attribute"/>
              <parameter key="1" value="Sensible Cooling.true.polynominal.attribute"/>
              <parameter key="2" value="Total Cooling.true.polynominal.attribute"/>
              <parameter key="3" value="Zone Heating.true.polynominal.attribute"/>
            </list>
          </operator>
          <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="179" y="136">
            <parameter key="attribute_name" value="Date/Time"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename (2)" width="90" x="313" y="136">
            <parameter key="old_name" value="Date/Time"/>
            <parameter key="new_name" value="DateTime"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="subprocess" compatibility="8.1.000" expanded="true" height="82" name="Set Predictions_Params" width="90" x="447" y="136">
            <process expanded="true">
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Window_Size" width="90" x="45" y="34">
                <parameter key="macro" value="WindowSize"/>
                <parameter key="value" value="40"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Horizon" width="90" x="179" y="34">
                <parameter key="macro" value="horizon"/>
                <parameter key="value" value="1"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Future_Month" width="90" x="313" y="34">
                <parameter key="macro" value="futureMonth"/>
                <parameter key="value" value="720"/>
              </operator>
              <connect from_port="in 1" to_op="Set Window_Size" to_port="through 1"/>
              <connect from_op="Set Window_Size" from_port="through 1" to_op="Set Horizon" to_port="through 1"/>
              <connect from_op="Set Horizon" from_port="through 1" to_op="Set Future_Month" to_port="through 1"/>
              <connect from_op="Set Future_Month" from_port="through 1" 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"/>
            </process>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="581" y="136">
            <parameter key="attribute_name" value="DateTime"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="715" y="136">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Zone Heating"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="916" y="85">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" breakpoints="after" class="parse_numbers" compatibility="8.1.000" expanded="true" height="82" name="Parse Numbers" width="90" x="1050" y="136"/>
          <operator activated="true" breakpoints="after" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Training" width="90" x="1184" y="136">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Zone Heating"/>
            <parameter key="horizon" value="%{horizon}"/>
          </operator>
          <operator activated="true" class="h2o:deep_learning" compatibility="7.6.001" expanded="true" height="82" name="Deep Learning" width="90" x="1318" 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>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Application" width="90" x="1318" y="187">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="label_attribute" value="inputYt"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Example Count" width="90" x="1519" y="187">
            <parameter key="macro" value="exampleCount"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="1653" y="187">
            <parameter key="first_example" value="%{exampleCount}"/>
            <parameter key="last_example" value="%{exampleCount}"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="1787" y="187">
            <parameter key="name" value="data"/>
          </operator>
          <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="1519" y="34">
            <parameter key="iterations" value="%{futureMonth}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="136">
                <parameter key="name" value="data"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="179" y="30">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="multiply" compatibility="8.1.000" expanded="true" height="103" name="Multiply" width="90" x="447" y="30"/>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="179" y="165"/>
              <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Increase Date (2)" width="90" x="313" y="165">
                <list key="function_descriptions">
                  <parameter key="DateTime" value="date_add(DateTime, 1, DATE_UNIT_HOUR)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="165">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="179" y="289">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="Zone Heating-39"/>
                <parameter key="invert_selection" value="true"/>
              </operator>
              <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="313" y="289">
                <parameter key="old_name" value="Zone Heating-38"/>
                <parameter key="new_name" value="Zone Heating-39"/>
                <list key="rename_additional_attributes">
                  <parameter key="Zone Heating-37" value="Zone Heating-38"/>
                  <parameter key="Zone Heating-36" value="Zone Heating-37"/>
                  <parameter key="Zone Heating-35" value="Zone Heating-36"/>
                  <parameter key="Zone Heating-34" value="Zone Heating-35"/>
                  <parameter key="Zone Heating-33" value="Zone Heating-34"/>
                  <parameter key="Zone Heating-32" value="Zone Heating-33"/>
                  <parameter key="Zone Heating-31" value="Zone Heating-32"/>
                  <parameter key="Zone Heating-30" value="Zone Heating-31"/>
                  <parameter key="Zone Heating-29" value="Zone Heating-30"/>
                  <parameter key="Zone Heating-28" value="Zone Heating-29"/>
                  <parameter key="Zone Heating-27" value="Zone Heating-28"/>
                  <parameter key="Zone Heating-26" value="Zone Heating-27"/>
                  <parameter key="Zone Heating-25" value="Zone Heating-26"/>
                  <parameter key="Zone Heating-24" value="Zone Heating-25"/>
                  <parameter key="Zone Heating-23" value="Zone Heating-24"/>
                  <parameter key="Zone Heating-22" value="Zone Heating-23"/>
                  <parameter key="Zone Heating-21" value="Zone Heating-22"/>
                  <parameter key="Zone Heating-20" value="Zone Heating-21"/>
                  <parameter key="Zone Heating-19" value="Zone Heating-20"/>
                  <parameter key="Zone Heating-18" value="Zone Heating-19"/>
                  <parameter key="Zone Heating-17" value="Zone Heating-18"/>
                  <parameter key="Zone Heating-16" value="Zone Heating-17"/>
                  <parameter key="Zone Heating-15" value="Zone Heating-16"/>
                  <parameter key="Zone Heating-14" value="Zone Heating-15"/>
                  <parameter key="Zone Heating-13" value="Zone Heating-14"/>
                  <parameter key="Zone Heating-12" value="Zone Heating-13"/>
                  <parameter key="Zone Heating-11" value="Zone Heating-12"/>
                  <parameter key="Zone Heating-10" value="Zone Heating-11"/>
                  <parameter key="Zone Heating-9" value="Zone Heating-10"/>
                  <parameter key="Zone Heating-8" value="Zone Heating-9"/>
                  <parameter key="Zone Heating-7" value="Zone Heating-8"/>
                  <parameter key="Zone Heating-6" value="Zone Heating-7"/>
                  <parameter key="Zone Heating-5" value="Zone Heating-6"/>
                  <parameter key="Zone Heating-4" value="Zone Heating-5"/>
                  <parameter key="Zone Heating-3" value="Zone Heating-4"/>
                  <parameter key="Zone Heating-2" value="Zone Heating-3"/>
                  <parameter key="Zone Heating-1" value="Zone Heating-2"/>
                  <parameter key="Zone Heating-0" value="Zone Heating-1"/>
                  <parameter key="prediction(label)" value="Zone Heating-0"/>
                </list>
              </operator>
              <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember (2)" width="90" x="447" y="289">
                <parameter key="name" value="data"/>
              </operator>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Multiply" to_port="input"/>
              <connect from_op="Multiply" from_port="output 1" to_port="output 1"/>
              <connect from_op="Multiply" from_port="output 2" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_op="Increase Date (2)" to_port="example set input"/>
              <connect from_op="Increase Date (2)" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Rename" to_port="example set input"/>
              <connect from_op="Rename" from_port="example set output" to_op="Remember (2)" to_port="store"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="1653" y="34"/>
          <connect from_op="Read Excel" from_port="output" to_op="Sort" to_port="example set input"/>
          <connect from_op="Sort" 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="Set Predictions_Params" to_port="in 1"/>
          <connect from_op="Set Predictions_Params" from_port="out 1" to_op="Set Role" to_port="example set input"/>
          <connect from_op="Set Role" 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="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
          <connect from_op="Parse Numbers" from_port="example set output" to_op="Windowing for Training" to_port="example set input"/>
          <connect from_op="Windowing for Training" from_port="example set output" to_op="Deep Learning" to_port="training set"/>
          <connect from_op="Windowing for Training" from_port="original" to_op="Windowing for Application" to_port="example set input"/>
          <connect from_op="Deep Learning" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Windowing for Application" from_port="example set output" to_op="Extract Example Count" to_port="example set"/>
          <connect from_op="Extract Example Count" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" 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>

    NB : I deleted the second row (the row with units) of your file because it caused trouble in the RapidMiner process.

     

    I hope it helps,

     

    Best regards,

     

     

    Lionel

    @lionelderkrikor wrote:

    Hi again @elham_calm,

     

    Here a first element of response : I builded a first process with a SVM model, but the predictions were totally fanciful.

    I tried with a Deep Learning model and the predictions are more relevant. Here a screenshot of the predictions of Zone heating  for January 2003 : 

    heat_cooling_forecast.png

     

    However, this process is largely perfectible : I don't observe in these predictions, the same shape as the January 2002 curve.

    In deed, my window size is equal to 40 (hours) and the predictions are made on 1 month. So to improve the accuracy of the predictions

    a next step would be to increase the window size.

     

    You can find the process here : 

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>futureMonths</key>
            <value>15</value>
          </macro>
          <macro>
            <key>horizon</key>
            <value>1</value>
          </macro>
          <macro>
            <key>windowSize</key>
            <value>6</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="8.1.000" expanded="true" height="68" name="Read Excel" width="90" x="45" y="136">
            <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\heating and cooling\heating and cooling loads.xlsx"/>
            <parameter key="imported_cell_range" value="A1:D8762"/>
            <parameter key="first_row_as_names" value="false"/>
            <list key="annotations">
              <parameter key="0" value="Name"/>
            </list>
            <list key="data_set_meta_data_information">
              <parameter key="0" value="Date/Time.true.date_time.attribute"/>
              <parameter key="1" value="Sensible Cooling.true.polynominal.attribute"/>
              <parameter key="2" value="Total Cooling.true.polynominal.attribute"/>
              <parameter key="3" value="Zone Heating.true.polynominal.attribute"/>
            </list>
          </operator>
          <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="179" y="136">
            <parameter key="attribute_name" value="Date/Time"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename (2)" width="90" x="313" y="136">
            <parameter key="old_name" value="Date/Time"/>
            <parameter key="new_name" value="DateTime"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="subprocess" compatibility="8.1.000" expanded="true" height="82" name="Set Predictions_Params" width="90" x="447" y="136">
            <process expanded="true">
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Window_Size" width="90" x="45" y="34">
                <parameter key="macro" value="WindowSize"/>
                <parameter key="value" value="40"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Horizon" width="90" x="179" y="34">
                <parameter key="macro" value="horizon"/>
                <parameter key="value" value="1"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Future_Month" width="90" x="313" y="34">
                <parameter key="macro" value="futureMonth"/>
                <parameter key="value" value="720"/>
              </operator>
              <connect from_port="in 1" to_op="Set Window_Size" to_port="through 1"/>
              <connect from_op="Set Window_Size" from_port="through 1" to_op="Set Horizon" to_port="through 1"/>
              <connect from_op="Set Horizon" from_port="through 1" to_op="Set Future_Month" to_port="through 1"/>
              <connect from_op="Set Future_Month" from_port="through 1" 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"/>
            </process>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="581" y="136">
            <parameter key="attribute_name" value="DateTime"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="715" y="136">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Zone Heating"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="916" y="85">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" breakpoints="after" class="parse_numbers" compatibility="8.1.000" expanded="true" height="82" name="Parse Numbers" width="90" x="1050" y="136"/>
          <operator activated="true" breakpoints="after" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Training" width="90" x="1184" y="136">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Zone Heating"/>
            <parameter key="horizon" value="%{horizon}"/>
          </operator>
          <operator activated="true" class="h2o:deep_learning" compatibility="7.6.001" expanded="true" height="82" name="Deep Learning" width="90" x="1318" 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>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Application" width="90" x="1318" y="187">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="label_attribute" value="inputYt"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Example Count" width="90" x="1519" y="187">
            <parameter key="macro" value="exampleCount"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="1653" y="187">
            <parameter key="first_example" value="%{exampleCount}"/>
            <parameter key="last_example" value="%{exampleCount}"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="1787" y="187">
            <parameter key="name" value="data"/>
          </operator>
          <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="1519" y="34">
            <parameter key="iterations" value="%{futureMonth}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="136">
                <parameter key="name" value="data"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="179" y="30">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="multiply" compatibility="8.1.000" expanded="true" height="103" name="Multiply" width="90" x="447" y="30"/>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="179" y="165"/>
              <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Increase Date (2)" width="90" x="313" y="165">
                <list key="function_descriptions">
                  <parameter key="DateTime" value="date_add(DateTime, 1, DATE_UNIT_HOUR)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="165">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="179" y="289">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="Zone Heating-39"/>
                <parameter key="invert_selection" value="true"/>
              </operator>
              <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="313" y="289">
                <parameter key="old_name" value="Zone Heating-38"/>
                <parameter key="new_name" value="Zone Heating-39"/>
                <list key="rename_additional_attributes">
                  <parameter key="Zone Heating-37" value="Zone Heating-38"/>
                  <parameter key="Zone Heating-36" value="Zone Heating-37"/>
                  <parameter key="Zone Heating-35" value="Zone Heating-36"/>
                  <parameter key="Zone Heating-34" value="Zone Heating-35"/>
                  <parameter key="Zone Heating-33" value="Zone Heating-34"/>
                  <parameter key="Zone Heating-32" value="Zone Heating-33"/>
                  <parameter key="Zone Heating-31" value="Zone Heating-32"/>
                  <parameter key="Zone Heating-30" value="Zone Heating-31"/>
                  <parameter key="Zone Heating-29" value="Zone Heating-30"/>
                  <parameter key="Zone Heating-28" value="Zone Heating-29"/>
                  <parameter key="Zone Heating-27" value="Zone Heating-28"/>
                  <parameter key="Zone Heating-26" value="Zone Heating-27"/>
                  <parameter key="Zone Heating-25" value="Zone Heating-26"/>
                  <parameter key="Zone Heating-24" value="Zone Heating-25"/>
                  <parameter key="Zone Heating-23" value="Zone Heating-24"/>
                  <parameter key="Zone Heating-22" value="Zone Heating-23"/>
                  <parameter key="Zone Heating-21" value="Zone Heating-22"/>
                  <parameter key="Zone Heating-20" value="Zone Heating-21"/>
                  <parameter key="Zone Heating-19" value="Zone Heating-20"/>
                  <parameter key="Zone Heating-18" value="Zone Heating-19"/>
                  <parameter key="Zone Heating-17" value="Zone Heating-18"/>
                  <parameter key="Zone Heating-16" value="Zone Heating-17"/>
                  <parameter key="Zone Heating-15" value="Zone Heating-16"/>
                  <parameter key="Zone Heating-14" value="Zone Heating-15"/>
                  <parameter key="Zone Heating-13" value="Zone Heating-14"/>
                  <parameter key="Zone Heating-12" value="Zone Heating-13"/>
                  <parameter key="Zone Heating-11" value="Zone Heating-12"/>
                  <parameter key="Zone Heating-10" value="Zone Heating-11"/>
                  <parameter key="Zone Heating-9" value="Zone Heating-10"/>
                  <parameter key="Zone Heating-8" value="Zone Heating-9"/>
                  <parameter key="Zone Heating-7" value="Zone Heating-8"/>
                  <parameter key="Zone Heating-6" value="Zone Heating-7"/>
                  <parameter key="Zone Heating-5" value="Zone Heating-6"/>
                  <parameter key="Zone Heating-4" value="Zone Heating-5"/>
                  <parameter key="Zone Heating-3" value="Zone Heating-4"/>
                  <parameter key="Zone Heating-2" value="Zone Heating-3"/>
                  <parameter key="Zone Heating-1" value="Zone Heating-2"/>
                  <parameter key="Zone Heating-0" value="Zone Heating-1"/>
                  <parameter key="prediction(label)" value="Zone Heating-0"/>
                </list>
              </operator>
              <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember (2)" width="90" x="447" y="289">
                <parameter key="name" value="data"/>
              </operator>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Multiply" to_port="input"/>
              <connect from_op="Multiply" from_port="output 1" to_port="output 1"/>
              <connect from_op="Multiply" from_port="output 2" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_op="Increase Date (2)" to_port="example set input"/>
              <connect from_op="Increase Date (2)" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Rename" to_port="example set input"/>
              <connect from_op="Rename" from_port="example set output" to_op="Remember (2)" to_port="store"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="1653" y="34"/>
          <connect from_op="Read Excel" from_port="output" to_op="Sort" to_port="example set input"/>
          <connect from_op="Sort" 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="Set Predictions_Params" to_port="in 1"/>
          <connect from_op="Set Predictions_Params" from_port="out 1" to_op="Set Role" to_port="example set input"/>
          <connect from_op="Set Role" 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="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
          <connect from_op="Parse Numbers" from_port="example set output" to_op="Windowing for Training" to_port="example set input"/>
          <connect from_op="Windowing for Training" from_port="example set output" to_op="Deep Learning" to_port="training set"/>
          <connect from_op="Windowing for Training" from_port="original" to_op="Windowing for Application" to_port="example set input"/>
          <connect from_op="Deep Learning" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Windowing for Application" from_port="example set output" to_op="Extract Example Count" to_port="example set"/>
          <connect from_op="Extract Example Count" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" 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>

    NB : I deleted the second row (the row with units) of your file because it caused trouble in the RapidMiner process.

     

    I hope it helps,

     

    Best regards,

     

     

    Lionel

    @lionelderkrikor wrote:

    Hi again @elham_calm,

     

    Here a first element of response : I builded a first process with a SVM model, but the predictions were totally fanciful.

    I tried with a Deep Learning model and the predictions are more relevant. Here a screenshot of the predictions of Zone heating  for January 2003 : 

    heat_cooling_forecast.png

     

    However, this process is largely perfectible : I don't observe in these predictions, the same shape as the January 2002 curve.

    In deed, my window size is equal to 40 (hours) and the predictions are made on 1 month. So to improve the accuracy of the predictions

    a next step would be to increase the window size.

     

    You can find the process here : 

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>futureMonths</key>
            <value>15</value>
          </macro>
          <macro>
            <key>horizon</key>
            <value>1</value>
          </macro>
          <macro>
            <key>windowSize</key>
            <value>6</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="8.1.000" expanded="true" height="68" name="Read Excel" width="90" x="45" y="136">
            <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\heating and cooling\heating and cooling loads.xlsx"/>
            <parameter key="imported_cell_range" value="A1:D8762"/>
            <parameter key="first_row_as_names" value="false"/>
            <list key="annotations">
              <parameter key="0" value="Name"/>
            </list>
            <list key="data_set_meta_data_information">
              <parameter key="0" value="Date/Time.true.date_time.attribute"/>
              <parameter key="1" value="Sensible Cooling.true.polynominal.attribute"/>
              <parameter key="2" value="Total Cooling.true.polynominal.attribute"/>
              <parameter key="3" value="Zone Heating.true.polynominal.attribute"/>
            </list>
          </operator>
          <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="179" y="136">
            <parameter key="attribute_name" value="Date/Time"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename (2)" width="90" x="313" y="136">
            <parameter key="old_name" value="Date/Time"/>
            <parameter key="new_name" value="DateTime"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="subprocess" compatibility="8.1.000" expanded="true" height="82" name="Set Predictions_Params" width="90" x="447" y="136">
            <process expanded="true">
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Window_Size" width="90" x="45" y="34">
                <parameter key="macro" value="WindowSize"/>
                <parameter key="value" value="40"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Horizon" width="90" x="179" y="34">
                <parameter key="macro" value="horizon"/>
                <parameter key="value" value="1"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Future_Month" width="90" x="313" y="34">
                <parameter key="macro" value="futureMonth"/>
                <parameter key="value" value="720"/>
              </operator>
              <connect from_port="in 1" to_op="Set Window_Size" to_port="through 1"/>
              <connect from_op="Set Window_Size" from_port="through 1" to_op="Set Horizon" to_port="through 1"/>
              <connect from_op="Set Horizon" from_port="through 1" to_op="Set Future_Month" to_port="through 1"/>
              <connect from_op="Set Future_Month" from_port="through 1" 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"/>
            </process>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="581" y="136">
            <parameter key="attribute_name" value="DateTime"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="715" y="136">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Zone Heating"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="916" y="85">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" breakpoints="after" class="parse_numbers" compatibility="8.1.000" expanded="true" height="82" name="Parse Numbers" width="90" x="1050" y="136"/>
          <operator activated="true" breakpoints="after" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Training" width="90" x="1184" y="136">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Zone Heating"/>
            <parameter key="horizon" value="%{horizon}"/>
          </operator>
          <operator activated="true" class="h2o:deep_learning" compatibility="7.6.001" expanded="true" height="82" name="Deep Learning" width="90" x="1318" 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>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Application" width="90" x="1318" y="187">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="label_attribute" value="inputYt"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Example Count" width="90" x="1519" y="187">
            <parameter key="macro" value="exampleCount"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="1653" y="187">
            <parameter key="first_example" value="%{exampleCount}"/>
            <parameter key="last_example" value="%{exampleCount}"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="1787" y="187">
            <parameter key="name" value="data"/>
          </operator>
          <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="1519" y="34">
            <parameter key="iterations" value="%{futureMonth}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="136">
                <parameter key="name" value="data"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="179" y="30">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="multiply" compatibility="8.1.000" expanded="true" height="103" name="Multiply" width="90" x="447" y="30"/>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="179" y="165"/>
              <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Increase Date (2)" width="90" x="313" y="165">
                <list key="function_descriptions">
                  <parameter key="DateTime" value="date_add(DateTime, 1, DATE_UNIT_HOUR)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="165">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="179" y="289">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="Zone Heating-39"/>
                <parameter key="invert_selection" value="true"/>
              </operator>
              <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="313" y="289">
                <parameter key="old_name" value="Zone Heating-38"/>
                <parameter key="new_name" value="Zone Heating-39"/>
                <list key="rename_additional_attributes">
                  <parameter key="Zone Heating-37" value="Zone Heating-38"/>
                  <parameter key="Zone Heating-36" value="Zone Heating-37"/>
                  <parameter key="Zone Heating-35" value="Zone Heating-36"/>
                  <parameter key="Zone Heating-34" value="Zone Heating-35"/>
                  <parameter key="Zone Heating-33" value="Zone Heating-34"/>
                  <parameter key="Zone Heating-32" value="Zone Heating-33"/>
                  <parameter key="Zone Heating-31" value="Zone Heating-32"/>
                  <parameter key="Zone Heating-30" value="Zone Heating-31"/>
                  <parameter key="Zone Heating-29" value="Zone Heating-30"/>
                  <parameter key="Zone Heating-28" value="Zone Heating-29"/>
                  <parameter key="Zone Heating-27" value="Zone Heating-28"/>
                  <parameter key="Zone Heating-26" value="Zone Heating-27"/>
                  <parameter key="Zone Heating-25" value="Zone Heating-26"/>
                  <parameter key="Zone Heating-24" value="Zone Heating-25"/>
                  <parameter key="Zone Heating-23" value="Zone Heating-24"/>
                  <parameter key="Zone Heating-22" value="Zone Heating-23"/>
                  <parameter key="Zone Heating-21" value="Zone Heating-22"/>
                  <parameter key="Zone Heating-20" value="Zone Heating-21"/>
                  <parameter key="Zone Heating-19" value="Zone Heating-20"/>
                  <parameter key="Zone Heating-18" value="Zone Heating-19"/>
                  <parameter key="Zone Heating-17" value="Zone Heating-18"/>
                  <parameter key="Zone Heating-16" value="Zone Heating-17"/>
                  <parameter key="Zone Heating-15" value="Zone Heating-16"/>
                  <parameter key="Zone Heating-14" value="Zone Heating-15"/>
                  <parameter key="Zone Heating-13" value="Zone Heating-14"/>
                  <parameter key="Zone Heating-12" value="Zone Heating-13"/>
                  <parameter key="Zone Heating-11" value="Zone Heating-12"/>
                  <parameter key="Zone Heating-10" value="Zone Heating-11"/>
                  <parameter key="Zone Heating-9" value="Zone Heating-10"/>
                  <parameter key="Zone Heating-8" value="Zone Heating-9"/>
                  <parameter key="Zone Heating-7" value="Zone Heating-8"/>
                  <parameter key="Zone Heating-6" value="Zone Heating-7"/>
                  <parameter key="Zone Heating-5" value="Zone Heating-6"/>
                  <parameter key="Zone Heating-4" value="Zone Heating-5"/>
                  <parameter key="Zone Heating-3" value="Zone Heating-4"/>
                  <parameter key="Zone Heating-2" value="Zone Heating-3"/>
                  <parameter key="Zone Heating-1" value="Zone Heating-2"/>
                  <parameter key="Zone Heating-0" value="Zone Heating-1"/>
                  <parameter key="prediction(label)" value="Zone Heating-0"/>
                </list>
              </operator>
              <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember (2)" width="90" x="447" y="289">
                <parameter key="name" value="data"/>
              </operator>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Multiply" to_port="input"/>
              <connect from_op="Multiply" from_port="output 1" to_port="output 1"/>
              <connect from_op="Multiply" from_port="output 2" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_op="Increase Date (2)" to_port="example set input"/>
              <connect from_op="Increase Date (2)" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Rename" to_port="example set input"/>
              <connect from_op="Rename" from_port="example set output" to_op="Remember (2)" to_port="store"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="1653" y="34"/>
          <connect from_op="Read Excel" from_port="output" to_op="Sort" to_port="example set input"/>
          <connect from_op="Sort" 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="Set Predictions_Params" to_port="in 1"/>
          <connect from_op="Set Predictions_Params" from_port="out 1" to_op="Set Role" to_port="example set input"/>
          <connect from_op="Set Role" 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="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
          <connect from_op="Parse Numbers" from_port="example set output" to_op="Windowing for Training" to_port="example set input"/>
          <connect from_op="Windowing for Training" from_port="example set output" to_op="Deep Learning" to_port="training set"/>
          <connect from_op="Windowing for Training" from_port="original" to_op="Windowing for Application" to_port="example set input"/>
          <connect from_op="Deep Learning" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Windowing for Application" from_port="example set output" to_op="Extract Example Count" to_port="example set"/>
          <connect from_op="Extract Example Count" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" 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>

    NB : I deleted the second row (the row with units) of your file because it caused trouble in the RapidMiner process.

     

    I hope it helps,

     

    Best regards,

     

     

    Lionel




    , is it work and show result?

     

  • elham_calm
    elham_calm New Altair Community Member

    Is it possible that save in google drive and share to me ? 

    this codes is not complete.

    thanks

  • elham_calm
    elham_calm New Altair Community Member
    That's Great!
    Thanks
  • elham_calm
    elham_calm New Altair Community Member
    Hello @lionelderkrikor
    I am very grateful to introduce me a good resource so I can run other learning methods on this dataset and compare the results together.
  • lionelderkrikor
    lionelderkrikor New Altair Community Member

    Hi @elham_calm,

     

    You're welcome.

     

    Best regards,

     

    Lionel

  • elham_calm
    elham_calm New Altair Community Member
    Hello @lionelderkrikor
    In your code that you wrote I tested kNN algorithm, I got better numbers to predict on a new dataset. What is your opinion about this algorithm?
  • lionelderkrikor
    lionelderkrikor New Altair Community Member
    Answer ✓

    Hello @elham_calm,

     

    Abstract of this post : 

    1. By choosing kNN algorithm,  I think you had a good idea.

    2. Bug with Deep Learning model inside Sliding Window Validation.

     

    1. To answer to your question :

    My point of view is that an algorithm is not good or bad. It is adapted or not adapted to a problem. So you have to experiment

    several algorithms for a given problem (I think that's what you realized according to your posts) and to choose the best one.

    But to compare objectively some models, you need of a performance metrics. In case of a time series problem, like your case,

    the RMSE (Root Mean Squared Error) can be a good choice. Without going into details, this metrics calculate the total difference/distance between the data of your test set and the predictions of a model, so the lower this indicator, the better the model.

    To implement that in RapidMiner in your case, like said @Thomas_Ott, we use the Sliding Window Validation operator with inside

    the model to test and the Performance (Regression) operator (which calculate the RMSE).

     

    The results (mean value of RMSE) are the following : 

    RMSE(SVM) = 22,360

    RMSE(kNN) = 15,869

    RMSE(Deep Learning) = ?????

    We can conclude too that kNN is the best algorithm in your case (but you can continue your experimentations with other models).

     

    When running the process with the Deep Learning, the process raise the following error : 

    Model training error (H2O) : ....... response cannot be constant.

     

    Does anyone have an idea of the cause ?

     

    Thanks you,

     

    Here the process : 

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>futureMonths</key>
            <value>15</value>
          </macro>
          <macro>
            <key>horizon</key>
            <value>1</value>
          </macro>
          <macro>
            <key>windowSize</key>
            <value>6</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="8.1.000" expanded="true" height="68" name="Read Excel" width="90" x="45" y="136">
            <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\heating and cooling\heating and cooling loads.xlsx"/>
            <parameter key="imported_cell_range" value="A1:D8762"/>
            <parameter key="first_row_as_names" value="false"/>
            <list key="annotations">
              <parameter key="0" value="Name"/>
            </list>
            <list key="data_set_meta_data_information">
              <parameter key="0" value="Date/Time.true.date_time.attribute"/>
              <parameter key="1" value="Sensible Cooling.true.polynominal.attribute"/>
              <parameter key="2" value="Total Cooling.true.polynominal.attribute"/>
              <parameter key="3" value="Zone Heating.true.polynominal.attribute"/>
            </list>
          </operator>
          <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="179" y="136">
            <parameter key="attribute_name" value="Date/Time"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename (2)" width="90" x="313" y="136">
            <parameter key="old_name" value="Date/Time"/>
            <parameter key="new_name" value="DateTime"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="subprocess" compatibility="8.1.000" expanded="true" height="82" name="Set Predictions_Params" width="90" x="447" y="136">
            <process expanded="true">
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Window_Size" width="90" x="45" y="34">
                <parameter key="macro" value="WindowSize"/>
                <parameter key="value" value="40"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Horizon" width="90" x="179" y="34">
                <parameter key="macro" value="horizon"/>
                <parameter key="value" value="1"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Future_Month" width="90" x="313" y="34">
                <parameter key="macro" value="futureMonth"/>
                <parameter key="value" value="720"/>
              </operator>
              <connect from_port="in 1" to_op="Set Window_Size" to_port="through 1"/>
              <connect from_op="Set Window_Size" from_port="through 1" to_op="Set Horizon" to_port="through 1"/>
              <connect from_op="Set Horizon" from_port="through 1" to_op="Set Future_Month" to_port="through 1"/>
              <connect from_op="Set Future_Month" from_port="through 1" 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"/>
            </process>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="581" y="136">
            <parameter key="attribute_name" value="DateTime"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="715" y="136">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Zone Heating"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="916" y="85">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" class="parse_numbers" compatibility="8.1.000" expanded="true" height="82" name="Parse Numbers" width="90" x="1050" y="136"/>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Training" width="90" x="1184" y="136">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Zone Heating"/>
            <parameter key="horizon" value="%{horizon}"/>
          </operator>
          <operator activated="true" class="series:sliding_window_validation" compatibility="7.4.000" expanded="true" height="124" name="Validation" width="90" x="1318" y="34">
            <parameter key="training_window_width" value="40"/>
            <parameter key="test_window_width" value="20"/>
            <process expanded="true">
              <operator activated="true" class="h2o:deep_learning" compatibility="7.6.001" expanded="true" height="82" name="Deep Learning" width="90" x="179" 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.1.000" expanded="true" height="82" name="Apply Model (2)" width="90" x="112" y="34">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="performance_regression" compatibility="8.1.000" expanded="true" height="82" name="Performance" width="90" x="246" y="34"/>
              <connect from_port="model" to_op="Apply Model (2)" to_port="model"/>
              <connect from_port="test set" to_op="Apply Model (2)" to_port="unlabelled data"/>
              <connect from_op="Apply Model (2)" 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="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Application" width="90" x="1318" y="187">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="label_attribute" value="inputYt"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Example Count" width="90" x="1519" y="187">
            <parameter key="macro" value="exampleCount"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="1653" y="187">
            <parameter key="first_example" value="%{exampleCount}"/>
            <parameter key="last_example" value="%{exampleCount}"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="1787" y="187">
            <parameter key="name" value="data"/>
          </operator>
          <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="1519" y="34">
            <parameter key="iterations" value="%{futureMonth}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="136">
                <parameter key="name" value="data"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="179" y="30">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="multiply" compatibility="8.1.000" expanded="true" height="103" name="Multiply" width="90" x="447" y="30"/>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="179" y="165"/>
              <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Increase Date (2)" width="90" x="313" y="165">
                <list key="function_descriptions">
                  <parameter key="DateTime" value="date_add(DateTime, 1, DATE_UNIT_HOUR)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="165">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="179" y="289">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="Zone Heating-39"/>
                <parameter key="invert_selection" value="true"/>
              </operator>
              <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="313" y="289">
                <parameter key="old_name" value="Zone Heating-38"/>
                <parameter key="new_name" value="Zone Heating-39"/>
                <list key="rename_additional_attributes">
                  <parameter key="Zone Heating-37" value="Zone Heating-38"/>
                  <parameter key="Zone Heating-36" value="Zone Heating-37"/>
                  <parameter key="Zone Heating-35" value="Zone Heating-36"/>
                  <parameter key="Zone Heating-34" value="Zone Heating-35"/>
                  <parameter key="Zone Heating-33" value="Zone Heating-34"/>
                  <parameter key="Zone Heating-32" value="Zone Heating-33"/>
                  <parameter key="Zone Heating-31" value="Zone Heating-32"/>
                  <parameter key="Zone Heating-30" value="Zone Heating-31"/>
                  <parameter key="Zone Heating-29" value="Zone Heating-30"/>
                  <parameter key="Zone Heating-28" value="Zone Heating-29"/>
                  <parameter key="Zone Heating-27" value="Zone Heating-28"/>
                  <parameter key="Zone Heating-26" value="Zone Heating-27"/>
                  <parameter key="Zone Heating-25" value="Zone Heating-26"/>
                  <parameter key="Zone Heating-24" value="Zone Heating-25"/>
                  <parameter key="Zone Heating-23" value="Zone Heating-24"/>
                  <parameter key="Zone Heating-22" value="Zone Heating-23"/>
                  <parameter key="Zone Heating-21" value="Zone Heating-22"/>
                  <parameter key="Zone Heating-20" value="Zone Heating-21"/>
                  <parameter key="Zone Heating-19" value="Zone Heating-20"/>
                  <parameter key="Zone Heating-18" value="Zone Heating-19"/>
                  <parameter key="Zone Heating-17" value="Zone Heating-18"/>
                  <parameter key="Zone Heating-16" value="Zone Heating-17"/>
                  <parameter key="Zone Heating-15" value="Zone Heating-16"/>
                  <parameter key="Zone Heating-14" value="Zone Heating-15"/>
                  <parameter key="Zone Heating-13" value="Zone Heating-14"/>
                  <parameter key="Zone Heating-12" value="Zone Heating-13"/>
                  <parameter key="Zone Heating-11" value="Zone Heating-12"/>
                  <parameter key="Zone Heating-10" value="Zone Heating-11"/>
                  <parameter key="Zone Heating-9" value="Zone Heating-10"/>
                  <parameter key="Zone Heating-8" value="Zone Heating-9"/>
                  <parameter key="Zone Heating-7" value="Zone Heating-8"/>
                  <parameter key="Zone Heating-6" value="Zone Heating-7"/>
                  <parameter key="Zone Heating-5" value="Zone Heating-6"/>
                  <parameter key="Zone Heating-4" value="Zone Heating-5"/>
                  <parameter key="Zone Heating-3" value="Zone Heating-4"/>
                  <parameter key="Zone Heating-2" value="Zone Heating-3"/>
                  <parameter key="Zone Heating-1" value="Zone Heating-2"/>
                  <parameter key="Zone Heating-0" value="Zone Heating-1"/>
                  <parameter key="prediction(label)" value="Zone Heating-0"/>
                </list>
              </operator>
              <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember (2)" width="90" x="447" y="289">
                <parameter key="name" value="data"/>
              </operator>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Multiply" to_port="input"/>
              <connect from_op="Multiply" from_port="output 1" to_port="output 1"/>
              <connect from_op="Multiply" from_port="output 2" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_op="Increase Date (2)" to_port="example set input"/>
              <connect from_op="Increase Date (2)" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Rename" to_port="example set input"/>
              <connect from_op="Rename" from_port="example set output" to_op="Remember (2)" to_port="store"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="1653" y="34"/>
          <connect from_op="Read Excel" from_port="output" to_op="Sort" to_port="example set input"/>
          <connect from_op="Sort" 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="Set Predictions_Params" to_port="in 1"/>
          <connect from_op="Set Predictions_Params" from_port="out 1" to_op="Set Role" to_port="example set input"/>
          <connect from_op="Set Role" 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="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
          <connect from_op="Parse Numbers" from_port="example set output" to_op="Windowing for Training" to_port="example set input"/>
          <connect from_op="Windowing for Training" from_port="example set output" to_op="Validation" to_port="training"/>
          <connect from_op="Windowing for Training" from_port="original" to_op="Windowing for Application" to_port="example set input"/>
          <connect from_op="Validation" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Validation" from_port="averagable 1" to_port="result 2"/>
          <connect from_op="Windowing for Application" from_port="example set output" to_op="Extract Example Count" to_port="example set"/>
          <connect from_op="Extract Example Count" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" 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"/>
          <portSpacing port="sink_result 3" spacing="0"/>
        </process>
      </operator>
    </process>

     

     

     

    2. To have an idea of the relative performances of the models (and mostly the relative performance of Deep learning), I decided, exceptionally, to use the Cross Validation operator (instead Sliding Window Validation operator) .

    The results (mean value of RMSE) are the following : 

    RMSE(SVM) = 144,567

    RMSE(Deep Learning) = 34,355

    RMSE(kNN) = 13,174

     

    With these results, we can conclude too that kNN is the best algorithm in your case 

     

    NB : Thanks to the communauty, to correct me, if these method is not applicable to have an idea of the relativ

    performances of some models.

     

    You can find the process here :

     

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>futureMonths</key>
            <value>15</value>
          </macro>
          <macro>
            <key>horizon</key>
            <value>1</value>
          </macro>
          <macro>
            <key>windowSize</key>
            <value>6</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="8.1.000" expanded="true" height="68" name="Read Excel" width="90" x="45" y="136">
            <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\heating and cooling\heating and cooling loads.xlsx"/>
            <parameter key="imported_cell_range" value="A1:D8762"/>
            <parameter key="first_row_as_names" value="false"/>
            <list key="annotations">
              <parameter key="0" value="Name"/>
            </list>
            <list key="data_set_meta_data_information">
              <parameter key="0" value="Date/Time.true.date_time.attribute"/>
              <parameter key="1" value="Sensible Cooling.true.polynominal.attribute"/>
              <parameter key="2" value="Total Cooling.true.polynominal.attribute"/>
              <parameter key="3" value="Zone Heating.true.polynominal.attribute"/>
            </list>
          </operator>
          <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="179" y="136">
            <parameter key="attribute_name" value="Date/Time"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename (2)" width="90" x="313" y="136">
            <parameter key="old_name" value="Date/Time"/>
            <parameter key="new_name" value="DateTime"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="subprocess" compatibility="8.1.000" expanded="true" height="82" name="Set Predictions_Params" width="90" x="447" y="136">
            <process expanded="true">
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Window_Size" width="90" x="45" y="34">
                <parameter key="macro" value="WindowSize"/>
                <parameter key="value" value="40"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Horizon" width="90" x="179" y="34">
                <parameter key="macro" value="horizon"/>
                <parameter key="value" value="1"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="8.1.000" expanded="true" height="82" name="Set Future_Month" width="90" x="313" y="34">
                <parameter key="macro" value="futureMonth"/>
                <parameter key="value" value="720"/>
              </operator>
              <connect from_port="in 1" to_op="Set Window_Size" to_port="through 1"/>
              <connect from_op="Set Window_Size" from_port="through 1" to_op="Set Horizon" to_port="through 1"/>
              <connect from_op="Set Horizon" from_port="through 1" to_op="Set Future_Month" to_port="through 1"/>
              <connect from_op="Set Future_Month" from_port="through 1" 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"/>
            </process>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="581" y="136">
            <parameter key="attribute_name" value="DateTime"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="715" y="136">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Zone Heating"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="916" y="85">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" class="parse_numbers" compatibility="8.1.000" expanded="true" height="82" name="Parse Numbers" width="90" x="1050" y="136"/>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Training" width="90" x="1184" y="136">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Zone Heating"/>
            <parameter key="horizon" value="%{horizon}"/>
          </operator>
          <operator activated="true" class="concurrency:cross_validation" compatibility="8.1.000" expanded="true" height="145" name="Cross Validation" width="90" x="1318" y="34">
            <process expanded="true">
              <operator activated="true" class="k_nn" compatibility="8.1.000" expanded="true" height="82" name="k-NN" width="90" x="179" y="34"/>
              <connect from_port="training set" to_op="k-NN" to_port="training set"/>
              <connect from_op="k-NN" from_port="model" to_port="model"/>
              <portSpacing port="source_training set" 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.1.000" expanded="true" height="82" name="Apply Model (2)" width="90" x="112" y="34">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="performance_regression" compatibility="8.1.000" expanded="true" height="82" name="Performance" width="90" x="246" y="34"/>
              <connect from_port="model" to_op="Apply Model (2)" to_port="model"/>
              <connect from_port="test set" to_op="Apply Model (2)" to_port="unlabelled data"/>
              <connect from_op="Apply Model (2)" from_port="labelled data" to_op="Performance" to_port="labelled data"/>
              <connect from_op="Performance" from_port="performance" to_port="performance 1"/>
              <portSpacing port="source_model" spacing="0"/>
              <portSpacing port="source_test set" spacing="0"/>
              <portSpacing port="source_through 1" spacing="0"/>
              <portSpacing port="sink_test set results" spacing="0"/>
              <portSpacing port="sink_performance 1" spacing="0"/>
              <portSpacing port="sink_performance 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="series:windowing" compatibility="5.2.000" expanded="true" height="82" name="Windowing for Application" width="90" x="1318" y="187">
            <parameter key="window_size" value="%{WindowSize}"/>
            <parameter key="label_attribute" value="inputYt"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Example Count" width="90" x="1519" y="187">
            <parameter key="macro" value="exampleCount"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="1653" y="187">
            <parameter key="first_example" value="%{exampleCount}"/>
            <parameter key="last_example" value="%{exampleCount}"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="1787" y="187">
            <parameter key="name" value="data"/>
          </operator>
          <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="1519" y="34">
            <parameter key="iterations" value="%{futureMonth}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="136">
                <parameter key="name" value="data"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="179" y="30">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="multiply" compatibility="8.1.000" expanded="true" height="103" name="Multiply" width="90" x="447" y="30"/>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="179" y="165"/>
              <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Increase Date (2)" width="90" x="313" y="165">
                <list key="function_descriptions">
                  <parameter key="DateTime" value="date_add(DateTime, 1, DATE_UNIT_HOUR)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="447" y="165">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="179" y="289">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="Zone Heating-39"/>
                <parameter key="invert_selection" value="true"/>
              </operator>
              <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="313" y="289">
                <parameter key="old_name" value="Zone Heating-38"/>
                <parameter key="new_name" value="Zone Heating-39"/>
                <list key="rename_additional_attributes">
                  <parameter key="Zone Heating-37" value="Zone Heating-38"/>
                  <parameter key="Zone Heating-36" value="Zone Heating-37"/>
                  <parameter key="Zone Heating-35" value="Zone Heating-36"/>
                  <parameter key="Zone Heating-34" value="Zone Heating-35"/>
                  <parameter key="Zone Heating-33" value="Zone Heating-34"/>
                  <parameter key="Zone Heating-32" value="Zone Heating-33"/>
                  <parameter key="Zone Heating-31" value="Zone Heating-32"/>
                  <parameter key="Zone Heating-30" value="Zone Heating-31"/>
                  <parameter key="Zone Heating-29" value="Zone Heating-30"/>
                  <parameter key="Zone Heating-28" value="Zone Heating-29"/>
                  <parameter key="Zone Heating-27" value="Zone Heating-28"/>
                  <parameter key="Zone Heating-26" value="Zone Heating-27"/>
                  <parameter key="Zone Heating-25" value="Zone Heating-26"/>
                  <parameter key="Zone Heating-24" value="Zone Heating-25"/>
                  <parameter key="Zone Heating-23" value="Zone Heating-24"/>
                  <parameter key="Zone Heating-22" value="Zone Heating-23"/>
                  <parameter key="Zone Heating-21" value="Zone Heating-22"/>
                  <parameter key="Zone Heating-20" value="Zone Heating-21"/>
                  <parameter key="Zone Heating-19" value="Zone Heating-20"/>
                  <parameter key="Zone Heating-18" value="Zone Heating-19"/>
                  <parameter key="Zone Heating-17" value="Zone Heating-18"/>
                  <parameter key="Zone Heating-16" value="Zone Heating-17"/>
                  <parameter key="Zone Heating-15" value="Zone Heating-16"/>
                  <parameter key="Zone Heating-14" value="Zone Heating-15"/>
                  <parameter key="Zone Heating-13" value="Zone Heating-14"/>
                  <parameter key="Zone Heating-12" value="Zone Heating-13"/>
                  <parameter key="Zone Heating-11" value="Zone Heating-12"/>
                  <parameter key="Zone Heating-10" value="Zone Heating-11"/>
                  <parameter key="Zone Heating-9" value="Zone Heating-10"/>
                  <parameter key="Zone Heating-8" value="Zone Heating-9"/>
                  <parameter key="Zone Heating-7" value="Zone Heating-8"/>
                  <parameter key="Zone Heating-6" value="Zone Heating-7"/>
                  <parameter key="Zone Heating-5" value="Zone Heating-6"/>
                  <parameter key="Zone Heating-4" value="Zone Heating-5"/>
                  <parameter key="Zone Heating-3" value="Zone Heating-4"/>
                  <parameter key="Zone Heating-2" value="Zone Heating-3"/>
                  <parameter key="Zone Heating-1" value="Zone Heating-2"/>
                  <parameter key="Zone Heating-0" value="Zone Heating-1"/>
                  <parameter key="prediction(label)" value="Zone Heating-0"/>
                </list>
              </operator>
              <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember (2)" width="90" x="447" y="289">
                <parameter key="name" value="data"/>
              </operator>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Multiply" to_port="input"/>
              <connect from_op="Multiply" from_port="output 1" to_port="output 1"/>
              <connect from_op="Multiply" from_port="output 2" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_op="Increase Date (2)" to_port="example set input"/>
              <connect from_op="Increase Date (2)" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Rename" to_port="example set input"/>
              <connect from_op="Rename" from_port="example set output" to_op="Remember (2)" to_port="store"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="1653" y="34"/>
          <connect from_op="Read Excel" from_port="output" to_op="Sort" to_port="example set input"/>
          <connect from_op="Sort" 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="Set Predictions_Params" to_port="in 1"/>
          <connect from_op="Set Predictions_Params" from_port="out 1" to_op="Set Role" to_port="example set input"/>
          <connect from_op="Set Role" 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="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
          <connect from_op="Parse Numbers" from_port="example set output" to_op="Windowing for Training" to_port="example set input"/>
          <connect from_op="Windowing for Training" from_port="example set output" to_op="Cross Validation" to_port="example set"/>
          <connect from_op="Windowing for Training" from_port="original" to_op="Windowing for Application" to_port="example set input"/>
          <connect from_op="Cross Validation" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Cross Validation" from_port="performance 1" to_port="result 2"/>
          <connect from_op="Windowing for Application" from_port="example set output" to_op="Extract Example Count" to_port="example set"/>
          <connect from_op="Extract Example Count" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" 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"/>
          <portSpacing port="sink_result 3" spacing="0"/>
        </process>
      </operator>
    </process>

     

     

    I hope, that  I helped you find the best model for your project.

     

    Best regards,

     

    Lionel

     

     

     

     

     

     

     

     

  • elham_calm
    elham_calm New Altair Community Member

    Hi @lionelderkrikor

    Thank you vey much

    Elham

  • elham_calm
    elham_calm New Altair Community Member

    Hello again @lionelderkrikor and @Thomas_Ott

    My next question is, is the increase in the number of attributes affect the accuracy of the results?

    second Question :

    And what changes are needed to get better results from the SVM(RBF) algorithm?

    Thanks very much

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    @elham_calm

     

    More attributes are 'typically' helpful if their not highly correlated. Look to this thread for more of a discussion on time series, SVM, and the RBF kernel

     

    https://community.rapidminer.com/t5/RapidMiner-Studio-Forum/Financial-Time-Series-Prediction/m-p/33456#M23667

     

    and here

     

    https://community.rapidminer.com/t5/RapidMiner-Studio-Forum/Time-Series-using-Windowing-operator-in-RapidMiner/m-p/31791#M22779

     

     

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    @elham_calm and here is a process that you might want to use. It tries to generate the forecasts a few time units into the future. I would suggest you optimize the SVM kernel using an Optimize Parameter operator and do so with a RSME performance as @lionelderkrikor suggested.

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <context>
        <input/>
        <output/>
        <macros>
          <macro>
            <key>horizon</key>
            <value>5</value>
          </macro>
          <macro>
            <key>symbol</key>
            <value>^VIX</value>
          </macro>
          <macro>
            <key>start_date</key>
            <value>2016-01-01</value>
          </macro>
          <macro>
            <key>end_date</key>
            <value>2016-10-07</value>
          </macro>
        </macros>
      </context>
      <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
        <parameter key="encoding" value="SYSTEM"/>
        <process expanded="true">
          <operator activated="false" class="optimize_parameters_grid" compatibility="8.1.000" expanded="true" height="103" name="Optimize Parameters (Grid)" width="90" x="581" y="238">
            <list key="parameters">
              <parameter key="SVM.kernel_gamma" value="[0.001;1000;6;logarithmic]"/>
              <parameter key="SVM.C" value="[0;1000;10;linear]"/>
            </list>
            <process expanded="true">
              <operator activated="true" class="series:sliding_window_validation" compatibility="7.4.000" expanded="true" height="124" name="Validation" width="90" x="112" y="34">
                <parameter key="training_window_width" value="20"/>
                <parameter key="training_window_step_size" value="1"/>
                <parameter key="test_window_width" value="20"/>
                <parameter key="horizon" value="%{futureDays}"/>
                <process expanded="true">
                  <operator activated="true" class="support_vector_machine" compatibility="8.1.000" expanded="true" height="124" name="SVM" width="90" x="179" y="34"/>
                  <connect from_port="training" to_op="SVM" to_port="training set"/>
                  <connect from_op="SVM" 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.1.000" expanded="true" height="82" name="Apply Model (2)" 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="246" y="34">
                    <parameter key="horizon" value="%{futureDays}"/>
                    <parameter key="main_criterion" value="prediction_trend_accuracy"/>
                  </operator>
                  <connect from_port="model" to_op="Apply Model (2)" to_port="model"/>
                  <connect from_port="test set" to_op="Apply Model (2)" to_port="unlabelled data"/>
                  <connect from_op="Apply Model (2)" 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="log" compatibility="8.1.000" expanded="true" height="82" name="Log" width="90" x="313" y="85">
                <parameter key="filename" value="tmp"/>
                <list key="log">
                  <parameter key="Gamma" value="operator.SVM.parameter.kernel_gamma"/>
                  <parameter key="C" value="operator.SVM.parameter.C"/>
                  <parameter key="Forecast Perf" value="operator.Validation.value.performance"/>
                </list>
              </operator>
              <connect from_port="input 1" to_op="Validation" to_port="training"/>
              <connect from_op="Validation" from_port="averagable 1" to_op="Log" to_port="through 1"/>
              <connect from_op="Log" from_port="through 1" to_port="performance"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_performance" spacing="0"/>
              <portSpacing port="sink_result 1" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="retrieve" compatibility="8.1.000" expanded="true" height="68" name="Retrieve Lake Huron" width="90" x="45" y="34">
            <parameter key="repository_entry" value="//Time Series Extension Samples/data sets/Lake Huron"/>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="179" y="34">
            <parameter key="attribute_name" value="Date"/>
            <parameter key="target_role" value="id"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="179" y="136">
            <parameter key="old_name" value="Lake surface level / feet"/>
            <parameter key="new_name" value="Close"/>
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="179" y="238">
            <parameter key="attribute_filter_type" value="subset"/>
            <parameter key="attributes" value="Close|Date"/>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="179" y="340">
            <parameter key="condition_class" value="no_missing_attributes"/>
            <list key="filters_list"/>
          </operator>
          <operator activated="true" class="series:windowing" compatibility="7.4.000" expanded="true" height="82" name="Windowing" width="90" x="380" y="34">
            <parameter key="window_size" value="6"/>
            <parameter key="create_label" value="true"/>
            <parameter key="label_attribute" value="Close"/>
          </operator>
          <operator activated="true" class="series:windowing" compatibility="7.4.000" expanded="true" height="82" name="Windowing (2)" width="90" x="380" y="136">
            <parameter key="window_size" value="6"/>
            <parameter key="label_attribute" value="Close"/>
          </operator>
          <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Macro" width="90" x="380" y="238">
            <parameter key="macro" value="n_examples"/>
            <list key="additional_macros"/>
          </operator>
          <operator activated="true" class="generate_macro" compatibility="8.1.000" expanded="true" height="82" name="Generate Macro" width="90" x="380" y="340">
            <list key="function_descriptions">
              <parameter key="filter_range" value="eval(%{n_examples})-1"/>
            </list>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="380" y="442">
            <parameter key="first_example" value="1"/>
            <parameter key="last_example" value="%{filter_range}"/>
            <parameter key="invert_filter" value="true"/>
          </operator>
          <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="514" y="442">
            <parameter key="name" value="LastRow"/>
          </operator>
          <operator activated="true" class="series:sliding_window_validation" compatibility="7.4.000" expanded="true" height="124" name="Validation (2)" width="90" x="581" y="34">
            <parameter key="training_window_width" value="20"/>
            <parameter key="training_window_step_size" value="1"/>
            <parameter key="test_window_width" value="20"/>
            <parameter key="horizon" value="%{horizon}"/>
            <process expanded="true">
              <operator activated="true" class="support_vector_machine" compatibility="8.1.000" expanded="true" height="124" name="SVM (2)" width="90" x="179" y="34">
                <parameter key="kernel_type" value="radial"/>
              </operator>
              <connect from_port="training" to_op="SVM (2)" to_port="training set"/>
              <connect from_op="SVM (2)" 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.1.000" expanded="true" height="82" name="Apply Model (3)" 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 (2)" width="90" x="246" y="34">
                <parameter key="horizon" value="%{horizon}"/>
                <parameter key="main_criterion" value="prediction_trend_accuracy"/>
              </operator>
              <connect from_port="model" to_op="Apply Model (3)" to_port="model"/>
              <connect from_port="test set" to_op="Apply Model (3)" to_port="unlabelled data"/>
              <connect from_op="Apply Model (3)" from_port="labelled data" to_op="Performance (2)" to_port="labelled data"/>
              <connect from_op="Performance (2)" 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="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="782" y="34">
            <parameter key="set_iteration_macro" value="true"/>
            <parameter key="macro_name" value="loop_forecasts"/>
            <parameter key="iterations" value="%{horizon}"/>
            <process expanded="true">
              <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="85">
                <parameter key="name" value="LastRow"/>
                <parameter key="remove_from_store" value="false"/>
              </operator>
              <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="246" y="34">
                <list key="application_parameters"/>
              </operator>
              <operator activated="true" class="generate_attributes" compatibility="8.1.000" expanded="true" height="82" name="Generate Attributes" width="90" x="380" y="34">
                <list key="function_descriptions">
                  <parameter key="Date" value="date_add(Date,eval(%{loop_forecasts}),DATE_UNIT_DAY)"/>
                </list>
              </operator>
              <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="514" y="34">
                <parameter key="attribute_name" value="prediction(label)"/>
                <list key="set_additional_roles"/>
              </operator>
              <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="648" y="34">
                <parameter key="attribute_filter_type" value="single"/>
                <parameter key="attribute" value="prediction(label)"/>
              </operator>
              <operator activated="true" class="replace" compatibility="8.1.000" expanded="true" height="82" name="Replace" width="90" x="782" y="34">
                <parameter key="replace_what" value="Close"/>
                <parameter key="replace_by" value="$1-"/>
              </operator>
              <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="916" y="34"/>
              <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
              <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
              <connect from_op="Apply Model" from_port="labelled data" to_op="Generate Attributes" to_port="example set input"/>
              <connect from_op="Generate Attributes" 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="Select Attributes (3)" to_port="example set input"/>
              <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Replace" to_port="example set input"/>
              <connect from_op="Replace" from_port="example set output" to_op="Materialize Data (2)" to_port="example set input"/>
              <connect from_op="Materialize Data (2)" from_port="example set output" to_port="output 1"/>
              <portSpacing port="source_input 1" spacing="0"/>
              <portSpacing port="source_input 2" spacing="0"/>
              <portSpacing port="sink_output 1" spacing="0"/>
              <portSpacing port="sink_output 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="916" y="34"/>
          <connect from_op="Retrieve Lake Huron" from_port="output" 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="Select Attributes" to_port="example set input"/>
          <connect from_op="Select Attributes" from_port="example set output" to_op="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" 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 (2)" to_port="training"/>
          <connect from_op="Windowing" from_port="original" to_op="Windowing (2)" to_port="example set input"/>
          <connect from_op="Windowing (2)" from_port="example set output" to_op="Extract Macro" to_port="example set"/>
          <connect from_op="Extract Macro" from_port="example set" to_op="Generate Macro" to_port="through 1"/>
          <connect from_op="Generate Macro" from_port="through 1" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="Remember" to_port="store"/>
          <connect from_op="Validation (2)" from_port="model" to_op="Loop" to_port="input 1"/>
          <connect from_op="Validation (2)" from_port="averagable 1" to_port="result 2"/>
          <connect from_op="Loop" from_port="output 1" to_op="Append" to_port="example set 1"/>
          <connect from_op="Append" from_port="merged set" to_port="result 1"/>
          <portSpacing port="source_input 1" spacing="0"/>
          <portSpacing port="sink_result 1" spacing="0"/>
          <portSpacing port="sink_result 2" spacing="231"/>
          <portSpacing port="sink_result 3" spacing="0"/>
        </process>
      </operator>
    </process>
  • elham_calm
    elham_calm New Altair Community Member

    Hello @Thomas_Ott

    Thanks alot

    but I have Question : in this code Optimize parameter has not connection,please help me to connect it right

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    Connect the PER output from the Validation to the Optimize operator. 

  • elham_calm
    elham_calm New Altair Community Member

    Hello again @Thomas_Ott

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="retrieve" compatibility="8.1.000" expanded="true" height="68" name="Retrieve NeW" width="90" x="45" y="34">
        <parameter key="repository_entry" value="//Local Repository/NeW"/>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role" width="90" x="179" y="34">
        <parameter key="attribute_name" value="Date/Time"/>
        <parameter key="target_role" value="id"/>
        <list key="set_additional_roles"/>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="rename" compatibility="8.1.000" expanded="true" height="82" name="Rename" width="90" x="179" y="136">
        <parameter key="old_name" value="Date/Time"/>
        <parameter key="new_name" value="Date.Time"/>
        <list key="rename_additional_attributes"/>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes" width="90" x="179" y="238">
        <parameter key="attribute_filter_type" value="subset"/>
        <parameter key="attribute" value=""/>
        <parameter key="attributes" value="Direct Normal Solar|Zone Sensible Heating"/>
        <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>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="filter_examples" compatibility="6.4.000" expanded="true" height="103" name="Filter Examples" width="90" x="179" y="340">
        <parameter key="parameter_expression" value=""/>
        <parameter key="condition_class" value="no_missing_attributes"/>
        <parameter key="invert_filter" value="false"/>
        <list key="filters_list"/>
        <parameter key="filters_logic_and" value="true"/>
        <parameter key="filters_check_metadata" value="true"/>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="series:windowing" compatibility="7.4.000" expanded="true" height="82" name="Windowing" width="90" x="380" y="34">
        <parameter key="series_representation" value="encode_series_by_examples"/>
        <parameter key="window_size" value="6"/>
        <parameter key="step_size" value="1"/>
        <parameter key="create_single_attributes" value="true"/>
        <parameter key="create_label" value="true"/>
        <parameter key="select_label_by_dimension" value="false"/>
        <parameter key="label_attribute" value="Zone Sensible Heating"/>
        <parameter key="horizon" value="1"/>
        <parameter key="add_incomplete_windows" value="false"/>
        <parameter key="stop_on_too_small_dataset" value="true"/>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="optimize_parameters_grid" compatibility="8.1.000" expanded="true" height="103" name="Optimize Parameters (Grid)" width="90" x="581" y="238">
        <list key="parameters">
          <parameter key="SVM.kernel_gamma" value="[0.001;1000;6;logarithmic]"/>
          <parameter key="SVM.C" value="[0;1000;10;linear]"/>
        </list>
        <parameter key="error_handling" value="fail on error"/>
        <process expanded="true">
          <operator activated="true" class="series:sliding_window_validation" compatibility="7.4.000" expanded="true" height="124" name="Validation" width="90" x="112" y="34">
            <parameter key="create_complete_model" value="false"/>
            <parameter key="training_window_width" value="20"/>
            <parameter key="training_window_step_size" value="1"/>
            <parameter key="test_window_width" value="20"/>
            <parameter key="horizon" value="%{horizon}"/>
            <parameter key="cumulative_training" value="false"/>
            <parameter key="average_performances_only" value="true"/>
            <process expanded="true">
              <operator activated="true" class="support_vector_machine" compatibility="8.1.000" expanded="true" height="124" name="SVM" width="90" x="179" y="34">
                <parameter key="kernel_type" value="dot"/>
                <parameter key="kernel_gamma" value="0.001"/>
                <parameter key="kernel_sigma1" value="1.0"/>
                <parameter key="kernel_sigma2" value="0.0"/>
                <parameter key="kernel_sigma3" value="2.0"/>
                <parameter key="kernel_shift" value="1.0"/>
                <parameter key="kernel_degree" value="2.0"/>
                <parameter key="kernel_a" value="1.0"/>
                <parameter key="kernel_b" value="0.0"/>
                <parameter key="kernel_cache" value="200"/>
                <parameter key="C" value="100.0"/>
                <parameter key="convergence_epsilon" value="0.001"/>
                <parameter key="max_iterations" value="100000"/>
                <parameter key="scale" value="true"/>
                <parameter key="calculate_weights" value="true"/>
                <parameter key="return_optimization_performance" value="true"/>
                <parameter key="L_pos" value="1.0"/>
                <parameter key="L_neg" value="1.0"/>
                <parameter key="epsilon" value="0.0"/>
                <parameter key="epsilon_plus" value="0.0"/>
                <parameter key="epsilon_minus" value="0.0"/>
                <parameter key="balance_cost" value="false"/>
                <parameter key="quadratic_loss_pos" value="false"/>
                <parameter key="quadratic_loss_neg" value="false"/>
                <parameter key="estimate_performance" value="false"/>
              </operator>
              <connect from_port="training" to_op="SVM" to_port="training set"/>
              <connect from_op="SVM" 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.1.000" expanded="true" height="82" name="Apply Model (2)" width="90" x="45" y="34">
                <list key="application_parameters"/>
                <parameter key="create_view" value="false"/>
              </operator>
              <operator activated="true" class="series:forecasting_performance" compatibility="7.4.000" expanded="true" height="82" name="Performance" width="90" x="246" y="34">
                <parameter key="horizon" value="%{horizon}"/>
                <parameter key="main_criterion" value="prediction_trend_accuracy"/>
                <parameter key="prediction_trend_accuracy" value="true"/>
                <parameter key="skip_undefined_labels" value="true"/>
                <parameter key="use_example_weights" value="true"/>
              </operator>
              <connect from_port="model" to_op="Apply Model (2)" to_port="model"/>
              <connect from_port="test set" to_op="Apply Model (2)" to_port="unlabelled data"/>
              <connect from_op="Apply Model (2)" 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="log" compatibility="8.1.000" expanded="true" height="82" name="Log" width="90" x="313" y="85">
            <parameter key="filename" value="tmp"/>
            <list key="log">
              <parameter key="Gamma" value="operator.SVM.parameter.kernel_gamma"/>
              <parameter key="C" value="operator.SVM.parameter.C"/>
              <parameter key="Forecast Perf" value="operator.Validation.value.performance"/>
            </list>
            <parameter key="sorting_type" value="none"/>
            <parameter key="sorting_k" value="100"/>
            <parameter key="persistent" value="false"/>
          </operator>
          <connect from_port="input 1" to_op="Validation" to_port="training"/>
          <connect from_op="Validation" from_port="averagable 1" to_op="Log" to_port="through 1"/>
          <connect from_op="Log" from_port="through 1" to_port="performance"/>
          <portSpacing port="source_input 1" spacing="0"/>
          <portSpacing port="source_input 2" spacing="0"/>
          <portSpacing port="sink_performance" spacing="0"/>
          <portSpacing port="sink_result 1" spacing="0"/>
        </process>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="series:windowing" compatibility="7.4.000" expanded="true" height="82" name="Windowing (2)" width="90" x="380" y="136">
        <parameter key="series_representation" value="encode_series_by_examples"/>
        <parameter key="window_size" value="6"/>
        <parameter key="step_size" value="1"/>
        <parameter key="create_single_attributes" value="true"/>
        <parameter key="create_label" value="false"/>
        <parameter key="select_label_by_dimension" value="false"/>
        <parameter key="label_attribute" value="Close"/>
        <parameter key="horizon" value="1"/>
        <parameter key="add_incomplete_windows" value="false"/>
        <parameter key="stop_on_too_small_dataset" value="true"/>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="extract_macro" compatibility="8.1.000" expanded="true" height="68" name="Extract Macro" width="90" x="380" y="238">
        <parameter key="macro" value="n_examples"/>
        <parameter key="macro_type" value="number_of_examples"/>
        <parameter key="statistics" value="average"/>
        <parameter key="attribute_name" value=""/>
        <list key="additional_macros"/>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="generate_macro" compatibility="8.1.000" expanded="true" height="82" name="Generate Macro" width="90" x="380" y="340">
        <list key="function_descriptions">
          <parameter key="filter_range" value="eval(%{n_examples})-1"/>
        </list>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="filter_example_range" compatibility="8.1.000" expanded="true" height="82" name="Filter Example Range" width="90" x="380" y="442">
        <parameter key="first_example" value="1"/>
        <parameter key="last_example" value="%{filter_range}"/>
        <parameter key="invert_filter" value="true"/>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="remember" compatibility="8.1.000" expanded="true" height="68" name="Remember" width="90" x="514" y="442">
        <parameter key="name" value="LastRow"/>
        <parameter key="io_object" value="ExampleSet"/>
        <parameter key="store_which" value="1"/>
        <parameter key="remove_from_process" value="true"/>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="series:sliding_window_validation" compatibility="7.4.000" expanded="true" height="124" name="Validation (2)" width="90" x="581" y="34">
        <parameter key="create_complete_model" value="false"/>
        <parameter key="training_window_width" value="20"/>
        <parameter key="training_window_step_size" value="1"/>
        <parameter key="test_window_width" value="20"/>
        <parameter key="horizon" value="%{horizon}"/>
        <parameter key="cumulative_training" value="false"/>
        <parameter key="average_performances_only" value="true"/>
        <process expanded="true">
          <operator activated="true" class="support_vector_machine" compatibility="8.1.000" expanded="true" height="124" name="SVM (2)" width="90" x="179" y="34">
            <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_shift" value="1.0"/>
            <parameter key="kernel_degree" value="2.0"/>
            <parameter key="kernel_a" value="1.0"/>
            <parameter key="kernel_b" value="0.0"/>
            <parameter key="kernel_cache" value="200"/>
            <parameter key="C" value="0.0"/>
            <parameter key="convergence_epsilon" value="0.001"/>
            <parameter key="max_iterations" value="100000"/>
            <parameter key="scale" value="true"/>
            <parameter key="calculate_weights" value="true"/>
            <parameter key="return_optimization_performance" value="true"/>
            <parameter key="L_pos" value="1.0"/>
            <parameter key="L_neg" value="1.0"/>
            <parameter key="epsilon" value="0.0"/>
            <parameter key="epsilon_plus" value="0.0"/>
            <parameter key="epsilon_minus" value="0.0"/>
            <parameter key="balance_cost" value="false"/>
            <parameter key="quadratic_loss_pos" value="false"/>
            <parameter key="quadratic_loss_neg" value="false"/>
            <parameter key="estimate_performance" value="false"/>
          </operator>
          <connect from_port="training" to_op="SVM (2)" to_port="training set"/>
          <connect from_op="SVM (2)" 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.1.000" expanded="true" height="82" name="Apply Model (3)" width="90" x="45" y="34">
            <list key="application_parameters"/>
            <parameter key="create_view" value="false"/>
          </operator>
          <operator activated="true" class="series:forecasting_performance" compatibility="7.4.000" expanded="true" height="82" name="Performance (2)" width="90" x="246" y="34">
            <parameter key="horizon" value="%{horizon}"/>
            <parameter key="main_criterion" value="prediction_trend_accuracy"/>
            <parameter key="prediction_trend_accuracy" value="true"/>
            <parameter key="skip_undefined_labels" value="true"/>
            <parameter key="use_example_weights" value="true"/>
          </operator>
          <connect from_port="model" to_op="Apply Model (3)" to_port="model"/>
          <connect from_port="test set" to_op="Apply Model (3)" to_port="unlabelled data"/>
          <connect from_op="Apply Model (3)" from_port="labelled data" to_op="Performance (2)" to_port="labelled data"/>
          <connect from_op="Performance (2)" 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>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="loop" compatibility="8.1.000" expanded="true" height="82" name="Loop" width="90" x="782" y="34">
        <parameter key="set_iteration_macro" value="true"/>
        <parameter key="macro_name" value="loop_forecasts"/>
        <parameter key="macro_start_value" value="1"/>
        <parameter key="iterations" value="%{horizon}"/>
        <parameter key="limit_time" value="false"/>
        <parameter key="timeout" value="1"/>
        <process expanded="true">
          <operator activated="true" class="recall" compatibility="8.1.000" expanded="true" height="68" name="Recall" width="90" x="45" y="85">
            <parameter key="name" value="LastRow"/>
            <parameter key="io_object" value="ExampleSet"/>
            <parameter key="remove_from_store" value="false"/>
          </operator>
          <operator activated="true" class="apply_model" compatibility="7.1.001" expanded="true" height="82" name="Apply Model" width="90" x="246" y="34">
            <list key="application_parameters"/>
            <parameter key="create_view" value="false"/>
          </operator>
          <operator activated="true" class="generate_attributes" compatibility="8.1.000" expanded="true" height="82" name="Generate Attributes" width="90" x="380" y="34">
            <list key="function_descriptions">
              <parameter key="Date" value="date_add(Date,eval(%{loop_forecasts}),DATE_UNIT_DAY)"/>
            </list>
            <parameter key="keep_all" value="true"/>
          </operator>
          <operator activated="true" class="set_role" compatibility="5.3.013" expanded="true" height="82" name="Set Role (2)" width="90" x="514" y="34">
            <parameter key="attribute_name" value="prediction(label)"/>
            <parameter key="target_role" value="regular"/>
            <list key="set_additional_roles"/>
          </operator>
          <operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (3)" width="90" x="648" y="34">
            <parameter key="attribute_filter_type" value="single"/>
            <parameter key="attribute" value="prediction(label)"/>
            <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="replace" compatibility="8.1.000" expanded="true" height="82" name="Replace" width="90" x="782" y="34">
            <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="nominal"/>
            <parameter key="use_value_type_exception" value="false"/>
            <parameter key="except_value_type" value="file_path"/>
            <parameter key="block_type" value="single_value"/>
            <parameter key="use_block_type_exception" value="false"/>
            <parameter key="except_block_type" value="single_value"/>
            <parameter key="invert_selection" value="false"/>
            <parameter key="include_special_attributes" value="false"/>
            <parameter key="replace_what" value="Close"/>
            <parameter key="replace_by" value="$1-"/>
          </operator>
          <operator activated="true" class="materialize_data" compatibility="8.1.000" expanded="true" height="82" name="Materialize Data (2)" width="90" x="916" y="34">
            <parameter key="datamanagement" value="double_array"/>
            <parameter key="data_management" value="auto"/>
          </operator>
          <connect from_port="input 1" to_op="Apply Model" to_port="model"/>
          <connect from_op="Recall" from_port="result" to_op="Apply Model" to_port="unlabelled data"/>
          <connect from_op="Apply Model" from_port="labelled data" to_op="Generate Attributes" to_port="example set input"/>
          <connect from_op="Generate Attributes" 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="Select Attributes (3)" to_port="example set input"/>
          <connect from_op="Select Attributes (3)" from_port="example set output" to_op="Replace" to_port="example set input"/>
          <connect from_op="Replace" from_port="example set output" to_op="Materialize Data (2)" to_port="example set input"/>
          <connect from_op="Materialize Data (2)" from_port="example set output" to_port="output 1"/>
          <portSpacing port="source_input 1" spacing="0"/>
          <portSpacing port="source_input 2" spacing="0"/>
          <portSpacing port="sink_output 1" spacing="0"/>
          <portSpacing port="sink_output 2" spacing="0"/>
        </process>
      </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.000">
      <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="916" y="34">
        <parameter key="datamanagement" value="double_array"/>
        <parameter key="data_management" value="auto"/>
        <parameter key="merge_type" value="all"/>
      </operator>
    </proces

     

    Is It correct? this is not complete:smileysad:

    I send my data set by zip

    please help me 

    Thanks alot

    Elham

     

    NeW.zip 121.5K

Categories