My auto model is showing error for all models

ming7012
ming7012 New Altair Community Member
edited November 5 in Community Q&A
These data comes from my simulation done in Abaqus for my engineering FYP. I'm trying to use machine learning to predict the behaviour of the results. I'm suppose to predict the results for column G, H, I, J, K using inputs from column B, C, D, E, F (100 rows of results). However, auto model is unable to generate any results and it keeps showing error across all models and in some instances showing the same classification errors across all models. I don't think my data has any issues so what would be the problem?
and some are showing these,


Tagged:

Best Answer

  • jwpfau
    jwpfau New Altair Community Member
    Answer ✓
    Hi,

    Row 18 (in Excel) of the Maximum COPEN column contains a String value instead of a number so you end up with a bunch of unique categorical values.

    Here is a process to fix the typo
    <?xml version="1.0" encoding="UTF-8"?><process version="10.1.002">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="10.1.002" expanded="true" name="Process">
    <parameter key="logverbosity" value="init"/>
    <parameter key="random_seed" value="2001"/>
    <parameter key="send_mail" value="never"/>
    <parameter key="notification_email" value=""/>
    <parameter key="process_duration_for_mail" value="30"/>
    <parameter key="encoding" value="SYSTEM"/>
    <process expanded="true">
      <operator activated="true" class="read_excel" compatibility="10.1.002" expanded="true" height="68" name="Read Excel" width="90" x="45" y="34">
        <parameter key="excel_file" value="https://us.v-cdn.net/6030995/uploads/editor/oc/6bviq02jf4cf.xlsx"/>
        <parameter key="sheet_selection" value="sheet number"/>
        <parameter key="sheet_number" value="1"/>
        <parameter key="imported_cell_range" value="B2:K102"/>
        <parameter key="encoding" value="SYSTEM"/>
        <parameter key="first_row_as_names" value="true"/>
        <list key="annotations"/>
        <parameter key="date_format" value=""/>
        <parameter key="time_zone" value="SYSTEM"/>
        <parameter key="locale" value="English (United States)"/>
        <parameter key="read_all_values_as_polynominal" value="false"/>
        <list key="data_set_meta_data_information">
          <parameter key="0" value="Thickness .true.real.attribute"/>
          <parameter key="1" value="Width .true.integer.attribute"/>
          <parameter key="2" value="Friction Coefficient.true.real.attribute"/>
          <parameter key="3" value="Displacement .true.real.attribute"/>
          <parameter key="4" value="Modulus of Elasticity .true.integer.attribute"/>
          <parameter key="5" value="Maximum COPEN.true.polynominal.attribute"/>
          <parameter key="6" value="Maximum Von Mises.true.integer.attribute"/>
          <parameter key="7" value="Maximum CShear-1 .true.real.attribute"/>
          <parameter key="8" value="Maximum CShear-2 .true.real.attribute"/>
          <parameter key="9" value="Maximum SDEG.true.real.attribute"/>
        </list>
        <parameter key="read_not_matching_values_as_missings" value="false"/>
      </operator>
      <operator activated="true" class="replace" compatibility="10.1.002" expanded="true" height="82" name="Replace" width="90" x="246" y="34">
        <parameter key="attribute_filter_type" value="single"/>
        <parameter key="attribute" value="Maximum COPEN"/>
        <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="\^"/>
      </operator>
      <operator activated="true" class="guess_types" compatibility="10.1.002" expanded="true" height="82" name="Guess Types" width="90" x="447" y="34">
        <parameter key="attribute_filter_type" value="single"/>
        <parameter key="attribute" value="Maximum COPEN"/>
        <parameter key="attributes" value=""/>
        <parameter key="use_except_expression" value="false"/>
        <parameter key="value_type" value="attribute_value"/>
        <parameter key="use_value_type_exception" value="false"/>
        <parameter key="except_value_type" value="time"/>
        <parameter key="block_type" value="attribute_block"/>
        <parameter key="use_block_type_exception" value="false"/>
        <parameter key="except_block_type" value="value_matrix_row_start"/>
        <parameter key="invert_selection" value="false"/>
        <parameter key="include_special_attributes" value="false"/>
        <parameter key="decimal_point_character" value="."/>
      </operator>
      <connect from_op="Read Excel" from_port="output" to_op="Replace" to_port="example set input"/>
      <connect from_op="Replace" from_port="example set output" to_op="Guess Types" to_port="example set input"/>
      <connect from_op="Guess Types" from_port="example set output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>

    Greetings,
    Jonas

Answers

  • jwpfau
    jwpfau New Altair Community Member
    Answer ✓
    Hi,

    Row 18 (in Excel) of the Maximum COPEN column contains a String value instead of a number so you end up with a bunch of unique categorical values.

    Here is a process to fix the typo
    <?xml version="1.0" encoding="UTF-8"?><process version="10.1.002">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="10.1.002" expanded="true" name="Process">
    <parameter key="logverbosity" value="init"/>
    <parameter key="random_seed" value="2001"/>
    <parameter key="send_mail" value="never"/>
    <parameter key="notification_email" value=""/>
    <parameter key="process_duration_for_mail" value="30"/>
    <parameter key="encoding" value="SYSTEM"/>
    <process expanded="true">
      <operator activated="true" class="read_excel" compatibility="10.1.002" expanded="true" height="68" name="Read Excel" width="90" x="45" y="34">
        <parameter key="excel_file" value="https://us.v-cdn.net/6030995/uploads/editor/oc/6bviq02jf4cf.xlsx"/>
        <parameter key="sheet_selection" value="sheet number"/>
        <parameter key="sheet_number" value="1"/>
        <parameter key="imported_cell_range" value="B2:K102"/>
        <parameter key="encoding" value="SYSTEM"/>
        <parameter key="first_row_as_names" value="true"/>
        <list key="annotations"/>
        <parameter key="date_format" value=""/>
        <parameter key="time_zone" value="SYSTEM"/>
        <parameter key="locale" value="English (United States)"/>
        <parameter key="read_all_values_as_polynominal" value="false"/>
        <list key="data_set_meta_data_information">
          <parameter key="0" value="Thickness .true.real.attribute"/>
          <parameter key="1" value="Width .true.integer.attribute"/>
          <parameter key="2" value="Friction Coefficient.true.real.attribute"/>
          <parameter key="3" value="Displacement .true.real.attribute"/>
          <parameter key="4" value="Modulus of Elasticity .true.integer.attribute"/>
          <parameter key="5" value="Maximum COPEN.true.polynominal.attribute"/>
          <parameter key="6" value="Maximum Von Mises.true.integer.attribute"/>
          <parameter key="7" value="Maximum CShear-1 .true.real.attribute"/>
          <parameter key="8" value="Maximum CShear-2 .true.real.attribute"/>
          <parameter key="9" value="Maximum SDEG.true.real.attribute"/>
        </list>
        <parameter key="read_not_matching_values_as_missings" value="false"/>
      </operator>
      <operator activated="true" class="replace" compatibility="10.1.002" expanded="true" height="82" name="Replace" width="90" x="246" y="34">
        <parameter key="attribute_filter_type" value="single"/>
        <parameter key="attribute" value="Maximum COPEN"/>
        <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="\^"/>
      </operator>
      <operator activated="true" class="guess_types" compatibility="10.1.002" expanded="true" height="82" name="Guess Types" width="90" x="447" y="34">
        <parameter key="attribute_filter_type" value="single"/>
        <parameter key="attribute" value="Maximum COPEN"/>
        <parameter key="attributes" value=""/>
        <parameter key="use_except_expression" value="false"/>
        <parameter key="value_type" value="attribute_value"/>
        <parameter key="use_value_type_exception" value="false"/>
        <parameter key="except_value_type" value="time"/>
        <parameter key="block_type" value="attribute_block"/>
        <parameter key="use_block_type_exception" value="false"/>
        <parameter key="except_block_type" value="value_matrix_row_start"/>
        <parameter key="invert_selection" value="false"/>
        <parameter key="include_special_attributes" value="false"/>
        <parameter key="decimal_point_character" value="."/>
      </operator>
      <connect from_op="Read Excel" from_port="output" to_op="Replace" to_port="example set input"/>
      <connect from_op="Replace" from_port="example set output" to_op="Guess Types" to_port="example set input"/>
      <connect from_op="Guess Types" from_port="example set output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>

    Greetings,
    Jonas
  • ming7012
    ming7012 New Altair Community Member
    Thanks for the help, I've managed to run the model without error now

Categories