[SOLVED] Logging regression coefficients

Hi,

I have a loop that is running linear regressions for all iterations of a specific attribute. Each of the iterations delivers a new linear model. I am interested in extracting and logging the coefficients of each iterated regression model, but I haven't found a way to do this.

Any ideas?

Thanks!!

Find more posts tagged with

AI Studio

Regression

Accepted answers

All comments

MartinLiebig

Have you considered to save the weights comming out of linear regression into your repository? Together with Generate Macro or %{a} you can choose different names.

~Martin

JEdward

I actually ran into similar problems as I was trying to extract the entire coefficients table (not just the weights) to use in a report.
I tried exporting as a formula, apparently linear regression isn't setup for formula generation yet.
I also tried the reporting extension also, but the **** in the Code attribute stops this table exporting.

So the only solution I found was exporting the linear model to disk using Write Model and then using the Read XML operator to translate the model back into a data table.
I put this together as a very quick example, but you'll want to do it a bit neater for a robust option. We I get time (probably in 6 months) I'll make an operator to do this.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="7.0.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="7.0.001" expanded="true" name="Process">
    <process expanded="true">
      <operator activated="true" class="advanced_file_connectors:read_xml" compatibility="7.0.001" expanded="true" height="68" name="Read XML" width="90" x="112" y="34">
        <parameter key="file" value="C:\Users\user\Desktop\linearRegression.mod"/>
        <parameter key="xpath_for_examples" value="//object-stream/LinearRegressionModel/LinearRegressionModel"/>
        <enumeration key="xpaths_for_attributes">
          <parameter key="xpath_for_attribute" value="default[1]/attributeNames[1]/string[1]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/attributeNames[1]/string[2]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/attributeNames[1]/string[3]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/attributeNames[1]/string[4]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/attributeNames[1]/string[5]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/coefficients[1]/double[1]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/coefficients[1]/double[2]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/coefficients[1]/double[3]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/coefficients[1]/double[4]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/pValues[1]/double[1]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/pValues[1]/double[2]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/pValues[1]/double[3]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/pValues[1]/double[4]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/selectedAttributes[1]/boolean[1]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/selectedAttributes[1]/boolean[2]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/selectedAttributes[1]/boolean[3]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/selectedAttributes[1]/boolean[4]/text()"/>
          <parameter key="xpath_for_attribute" value="default[1]/selectedAttributes[1]/boolean[5]/text()"/>
        </enumeration>
        <list key="namespaces"/>
        <parameter key="use_default_namespace" value="false"/>
        <list key="annotations"/>
        <list key="data_set_meta_data_information">
          <parameter key="0" value="default[1]/attributeNames[1]/string[1]/text().true.attribute_value.attribute"/>
          <parameter key="1" value="default[1]/attributeNames[1]/string[2]/text().true.attribute_value.attribute"/>
          <parameter key="2" value="default[1]/attributeNames[1]/string[3]/text().true.attribute_value.attribute"/>
          <parameter key="3" value="default[1]/attributeNames[1]/string[4]/text().true.attribute_value.attribute"/>
          <parameter key="4" value="default[1]/attributeNames[1]/string[5]/text().true.attribute_value.attribute"/>
          <parameter key="5" value="default[1]/coefficients[1]/double[1]/text().true.attribute_value.attribute"/>
          <parameter key="6" value="default[1]/coefficients[1]/double[2]/text().true.attribute_value.attribute"/>
          <parameter key="7" value="default[1]/coefficients[1]/double[3]/text().true.attribute_value.attribute"/>
          <parameter key="8" value="default[1]/coefficients[1]/double[4]/text().true.attribute_value.attribute"/>
          <parameter key="9" value="default[1]/pValues[1]/double[1]/text().true.attribute_value.attribute"/>
          <parameter key="10" value="default[1]/pValues[1]/double[2]/text().true.attribute_value.attribute"/>
          <parameter key="11" value="default[1]/pValues[1]/double[3]/text().true.attribute_value.attribute"/>
          <parameter key="12" value="default[1]/pValues[1]/double[4]/text().true.attribute_value.attribute"/>
          <parameter key="13" value="default[1]/selectedAttributes[1]/boolean[1]/text().true.attribute_value.attribute"/>
          <parameter key="14" value="default[1]/selectedAttributes[1]/boolean[2]/text().true.attribute_value.attribute"/>
          <parameter key="15" value="default[1]/selectedAttributes[1]/boolean[3]/text().true.attribute_value.attribute"/>
          <parameter key="16" value="default[1]/selectedAttributes[1]/boolean[4]/text().true.attribute_value.attribute"/>
          <parameter key="17" value="default[1]/selectedAttributes[1]/boolean[5]/text().true.attribute_value.attribute"/>
        </list>
      </operator>
      <connect from_op="Read XML" from_port="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>

juanm_encinas

An operator for this purpose will be great !

Thanks