How to export the correlation matrix results?

funnyhat
funnyhat New Altair Community Member
edited November 2024 in Community Q&A
I made a correlation matrix, and attributes weight list, However, I found I can not  export the list to a excel file, the only possible is a jpg file as current winodw?  Besides, I am really eager of RM 5.0 manual, otherwise I have to start to learn german to read the german version  :'(

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • SebastianLoh
    SebastianLoh New Altair Community Member
    Hi funnyhat,

    learning German is definitely an option. However, here is some help now: you can export the correlation matrix by generating a report and write the report to an Excel file. Sounds complicated but is not. The process below shows you how to do this.

    Due to your request we also found a tiny bug. Unfortunatly you'll need to close RM to open the written report Excel file without a write protection. This bug is fixed in the svn repository version now and the fix will be part of the next RM update.

    Ciao Sebastian

    Link to the MyExperiment.org workflow: http://www.myexperiment.org/workflows/1279 also accessible threw the RM community plugin.
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="5.0">
     <context>
       <input/>
       <output/>
       <macros/>
     </context>
     <operator activated="true" class="process" expanded="true" name="Process">
       <process expanded="true" height="341" width="614">
         <operator activated="true" class="generate_data" expanded="true" height="60" name="Generate Data" width="90" x="45" y="30"/>
         <operator activated="true" class="correlation_matrix" expanded="true" height="94" name="Correlation Matrix" width="90" x="179" y="75"/>
         <operator activated="true" class="reporting:generate_report" expanded="true" height="76" name="Generate Report" width="90" x="313" y="30">
           <parameter key="report_name" value="Excel"/>
           <parameter key="format" value="Excel"/>
           <parameter key="excel_output_file" value="C:\ExcelReport.xls"/>
         </operator>
         <operator activated="true" class="reporting:report" expanded="true" height="60" name="Report" width="90" x="447" y="30">
           <parameter key="report_name" value="Excel"/>
           <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="Correlation Matrix" to_port="example set"/>
         <connect from_op="Correlation Matrix" from_port="matrix" to_op="Generate Report" to_port="through 1"/>
         <connect from_op="Correlation Matrix" from_port="weights" to_port="result 2"/>
         <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 1"/>
         <portSpacing port="source_input 1" spacing="0"/>
         <portSpacing port="sink_result 1" spacing="0"/>
         <portSpacing port="sink_result 2" spacing="180"/>
         <portSpacing port="sink_result 3" spacing="18"/>
       </process>
     </operator>
    </process>
  • funnyhat
    funnyhat New Altair Community Member
    Thanks!! you are always so helpful.
  • qwertz
    qwertz New Altair Community Member
    It seems that this bug also appears in version 6. If I let RM write a report it cannot be opened while running the same process again.
    However, this is still a work-around. An operator which can handle matrix elements would be sooo handy :)

    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="6.0.003">
     <context>
       <input/>
       <output/>
       <macros/>
     </context>
     <operator activated="true" class="process" compatibility="6.0.003" expanded="true" name="Process">
       <process expanded="true">
         <operator activated="true" class="generate_data" compatibility="6.0.003" expanded="true" height="60" name="Generate Data" width="90" x="45" y="30">
           <parameter key="number_of_attributes" value="25"/>
         </operator>
         <operator activated="true" class="correlation_matrix" compatibility="6.0.003" expanded="true" height="94" name="Correlation Matrix" width="90" x="179" y="30"/>
         <operator activated="true" class="reporting:generate_report" compatibility="5.3.000" expanded="true" height="76" name="Generate Report" width="90" x="313" y="30">
           <parameter key="report_name" value="report"/>
           <parameter key="format" value="Excel"/>
           <parameter key="excel_output_file" value="C:\report.xls"/>
         </operator>
         <operator activated="true" class="reporting:report" compatibility="5.3.000" expanded="true" height="60" name="Report" width="90" x="447" y="30">
           <parameter key="report_name" value="report"/>
           <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>
         <operator activated="true" class="read_excel" compatibility="6.0.003" expanded="true" height="60" name="Read Excel" width="90" x="45" y="165">
           <parameter key="excel_file" value="C:\report.xls"/>
           <parameter key="imported_cell_range" value="A3:Z28"/>
           <parameter key="first_row_as_names" value="false"/>
           <list key="annotations">
             <parameter key="0" value="Name"/>
           </list>
           <list key="data_set_meta_data_information">
             <parameter key="0" value="Attributes.true.text.id"/>
             <parameter key="1" value="att1.true.real.attribute"/>
             <parameter key="2" value="att2.true.real.attribute"/>
             <parameter key="3" value="att3.true.real.attribute"/>
             <parameter key="4" value="att4.true.real.attribute"/>
             <parameter key="5" value="att5.true.real.attribute"/>
             <parameter key="6" value="att6.true.real.attribute"/>
             <parameter key="7" value="att7.true.real.attribute"/>
             <parameter key="8" value="att8.true.real.attribute"/>
             <parameter key="9" value="att9.true.real.attribute"/>
             <parameter key="10" value="att10.true.real.attribute"/>
             <parameter key="11" value="att11.true.real.attribute"/>
             <parameter key="12" value="att12.true.real.attribute"/>
             <parameter key="13" value="att13.true.real.attribute"/>
             <parameter key="14" value="att14.true.real.attribute"/>
             <parameter key="15" value="att15.true.real.attribute"/>
             <parameter key="16" value="att16.true.real.attribute"/>
             <parameter key="17" value="att17.true.real.attribute"/>
             <parameter key="18" value="att18.true.real.attribute"/>
             <parameter key="19" value="att19.true.real.attribute"/>
             <parameter key="20" value="att20.true.real.attribute"/>
             <parameter key="21" value="att21.true.real.attribute"/>
             <parameter key="22" value="att22.true.real.attribute"/>
             <parameter key="23" value="att23.true.real.attribute"/>
             <parameter key="24" value="att24.true.real.attribute"/>
             <parameter key="25" value="att25.true.real.attribute"/>
           </list>
         </operator>
         <connect from_op="Generate Data" from_port="output" to_op="Correlation Matrix" to_port="example set"/>
         <connect from_op="Correlation Matrix" from_port="matrix" 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="Read Excel" from_port="output" to_port="result 1"/>
         <portSpacing port="source_input 1" spacing="0"/>
         <portSpacing port="sink_result 1" spacing="144"/>
         <portSpacing port="sink_result 2" spacing="0"/>
       </process>
     </operator>
    </process>

    EDIT: Even more weird... I tried it a second time with exactely the same setup and now it works?!? Well, seems that the rootcause was probably something else with my computer. However, I still consider an operator to process matrix elements is still an important feature.


    Best
    Sachs
  • qwertz2
    qwertz2 New Altair Community Member

     

    Hi,

     

    Seems that this little bug is still in version 7: I have to end the process first before I can access the report file :(

     

    Best regards

  • MartinLiebig
    MartinLiebig
    Altair Employee

    Hallo unvergessbar,

     

    schön dich im Forum zu haben!

     

    we have created a new operator called Matrix to Exampleset which is available in the Converters Extension. This makes your life easier :).

     

    See: https://marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_converters

     

    Best,

    Martin

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.