"exporting and filtering Covariance matrix"

aagraw02aagraw02 Member Posts: 2 Contributor I
edited June 2019 in Help
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
Tagged:

Answers

  • MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869 Unicorn
    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>
  • aagraw02aagraw02 Member Posts: 2 Contributor I
    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
Sign In or Register to comment.