"exporting and filtering Covariance matrix"

aagraw02aagraw02 MemberPosts:2Contributor I
edited June 2019 inHelp
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, MemberPosts:1,869Unicorn
    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





    <宏/ >
















    <参数键= " max_row”value="2147483647"/>















  • aagraw02aagraw02 MemberPosts:2Contributor 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 InorRegisterto comment.