# "Write a Numeric Matrix to CSV"

In a RapidMiner process, I am creating a numeric correlation matrix that I would like to write to a file. I can't write to an Excel file because the matrix is 2500 X 2500. I'm trying to use the "Write CSV" operator but the operator gives me an error saying that the input is of the wrong type.

How do I write this matrix to a CSV file?

Thank you

How do I write this matrix to a CSV file?

Thank you

Tagged:

0

## Answers

1,869UnicornAs a workaround, you can view the matrix in the results view, select all of its entries with Ctrl-A, then press Ctrl-C to copy the entries and paste them into a text editor. That should create a tab-separated file. I am not sure, however, if that works with such a large dataset.

Best regards,

Marius

7Contributor IIThank you for the response.

Is there any way to convert the numeric correlation matrix to a pairwise table? If I could do that, then I could write the pairwise table to Excel.

Jerry

1,869UnicornBest regards,

Marius