"exporting and filtering Covariance matrix"

aagraw02

Hi I have an output from of the Covariance matrix which is really huge. has around 600 columns and around 1000 rows.
I wanted to export that as an .xlsx file. But I figured it cant be done. Is there a way to do this, even csv would do.  And just to make it more clear. The Covariance matrix gives out two outputs, "Example set: exa " and "Covariance matrix itselt: cov ". I want the "cov" as a csv file or .xlsx file.


In that matrix I have many -ve values. Now i want to filter out the -ve values and only keep +ve ones. How can i do that.

Please help.

Thanks

Ashish

MariusHelf

Hi,

we are still missing a Matrix to Data operator, but with the help of the Reporting extension you can get it into an Excel sheet nevertheless. Please have a look at the attached process.

Best, Marius

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.2.006">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="5.2.006" expanded="true" name="Process">
    <process expanded="true" height="512" width="770">
      <operator activated="true" class="generate_data" compatibility="5.2.006" expanded="true" height="60" name="Generate Data" width="90" x="45" y="30"/>
      <operator activated="true" class="covariance_matrix" compatibility="5.2.006" expanded="true" height="76" name="Covariance Matrix" width="90" x="179" y="30"/>
      <operator activated="true" class="reporting:generate_report" compatibility="5.2.000" expanded="true" height="76" name="Generate Report" width="90" x="313" y="75">
        <parameter key="report_name" value="grzn"/>
        <parameter key="format" value="Excel"/>
        <parameter key="excel_output_file" value="C:\Users\mhelf\Desktop\grzn.xls"/>
      </operator>
      <operator activated="true" class="reporting:report" compatibility="5.2.000" expanded="true" height="60" name="Report" width="90" x="447" y="75">
        <parameter key="specified" value="true"/>
        <parameter key="reportable_type" value="Numerical Matrix"/>
        <parameter key="renderer_name" value="Table View"/>
        <list key="parameters">
          <parameter key="min_row" value="1"/>
          <parameter key="max_row" value="2147483647"/>
          <parameter key="min_column" value="1"/>
          <parameter key="max_column" value="2147483647"/>
        </list>
      </operator>
      <connect from_op="Generate Data" from_port="output" to_op="Covariance Matrix" to_port="example set"/>
      <connect from_op="Covariance Matrix" from_port="example set" to_port="result 1"/>
      <connect from_op="Covariance Matrix" from_port="covariance" to_op="Generate Report" to_port="through 1"/>
      <connect from_op="Generate Report" from_port="through 1" to_op="Report" to_port="reportable in"/>
      <connect from_op="Report" from_port="reportable out" to_port="result 2"/>
      <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>

aagraw02

Hi ,

Thanks for the help.
But this only outputs 256 columns  and I have 600 columns .. how do i output al the columns in one .csv file or .xls or .xlsx file ?

thank a lot

Ashish