🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"exporting and filtering Covariance matrix"

User: "aagraw02"
aagraw02
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

AI Studio
Filtering
Sort by:
1 - 2 of 21
    User: "MariusHelf"
    MariusHelf
    New Altair Community Member
    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>
    User: "aagraw02"
    aagraw02
    New Altair Community Member
    OP
    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
Quick Links