Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Export Example set and Performance Vector

Anna_May1Anna_May1 Member Posts: 14 Learner I
edited December 2020 in Help
Hi guys, 

as part of my sentiment analysis I am receiving results in the "Results" tab, which are named "PerformanceVector (Performance)" and "ExampleSet (Apply Model(2)).
I want to export them into an Excel file exactly as shown in the two pictures below, so exactly the way they are in the Results tab.

But when I e.g. use the Write Excel operator behind apply model, the columns "prediction" both "confidence" columns and the "text" column are gone and I need them in my exported file. The results are then like this: 


Have you guys got any solution for that issue?

Cheers!
Tagged:

Best Answer

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,531 RM Data Scientist
    Solution Accepted
    Hi,
    are you sure that the two columns aren't by accident on the far right of your dataset?

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany

Answers

  • Anna_May1Anna_May1 Member Posts: 14 Learner I
    Hi @mschmitz,

    you're totally right! It was there! Thanks a lot!

    Still, when extracting "PerformanceVector (Performance)" in Excel, there are not all the results shown:

    Do you have any idea why that might be the case?
    I have used the "Confusion Matrix to ExampleSet" Operator in front of the "Write Excel" Operator.

    Cheers!
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,531 RM Data Scientist
    Hi,
    likely you want to use also performance to data, to convert the performance measures so that you can then write them away?
    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Anna_May1Anna_May1 Member Posts: 14 Learner I
    Hi @mschmitz , 

    I tried that, once with"Perfomance to data" on its ows before "Write Excel" and once in combination with "Confusion Matrix to ExampleSet". This was the Excel Output: 

    Cheers! 
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,531 RM Data Scientist
    Hi,
    so what is wrong with this?

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.