How to export the RM results?

tinasister
tinasister New Altair Community Member
edited November 5 in Community Q&A
Hi, I'm planning to analyze the result from RM by another tool, I'm expecting .xlsx or .txt results. But the RM
results saved in repository is .md, how could I save the results in another format? Thanks
Tagged:

Best Answer

Answers

  • tinasister
    tinasister New Altair Community Member
    Hi, Thanks a lot. I tried and it worked but when I check the exported .xls document, I found only part of the columns of the example set were stored. I also tried write .csv but the same happend. Can you tell me how can I export the whole results? BTW, my result example set contains about 700 attributes.
  • chanelops
    chanelops New Altair Community Member
    If you've got an older version of Excel, that might be the problem.  Excel versions before 2007 would only handle 256 columns.

    Also, I guess it's possible that the RM export function might be designed for that limit, although that would be strange, so I doubt it.

    The fact that it also happened with csv leads me to think it might be an Excel limit.  Can you look at the csv file with something like Notepad and see how many columns are actually being exported into the text file?  You don't have to count them all, but just get an idea if it's closer to 250 or  more like 700.  That could give you a pointer as to where the problem is.
  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Hello,

    RapidMiner Write Excel operator creates a .xls file, which is limited to 256 columns and there is no way around that limit. Older versions of Excel up until 2003 could not handle more columns. So to create an excel file with with more than 256 columns, one would either need to use .xlsx format or create a new sheet in the .xls file for each batch of 256 columns.
    .xlsx is currently not supported for a variety of reasons, but maybe we can look into adding an option to create more sheets if the column count is > 256. I don't know right now if that's a practical solution though, so no promises there.

    In regards to your .csv problem: chanelops should be correct. Excel 2003 and older are only capable of handling up to 256 columns, so if you open the .csv file with another tool or Excel 2007 and later, you will see that all columns are actually there.

    Regards,
    Marco
  • JonB
    JonB New Altair Community Member
    When I add a "write excel" operator, I get a tab in the results for the excel sheet but all it says in it is "memory buffered file".
    How do I get to my excel sheet?
  • MariusHelf
    MariusHelf New Altair Community Member
    Hi,

    probably the "fil" output port of the Write Excel operator is connected to something. Please delete this connection, then you can choose the file to be written in the operator parameters.

    Best, Marius

Categories