The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Export Summary Statistics from Results view to Excel

khannadhkhannadh Member Posts: 10 Contributor II
edited November 2018 in Help
Hi Everyone,

I have an excel file in Rapidminer. I have run the file and I get the summary statistics in the results tab. Is there a way to export the summary statistics for each attribute from the results tab into Excel?

Any help is appreciated.

Thank You
Tagged:

Answers

  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 Unicorn
    The Reporting extension used to be able to do this as you could export just the Meta data.  Not tested with 7.1 though so don't know if it's still compatible. 

    Give it a shot. 
  • khannadhkhannadh Member Posts: 10 Contributor II
    Hi Jedward. How do you use the reporting extension? Where do I go for that?
    Could you please let me know?

    Thank you.
  • earmijoearmijo Member Posts: 271 Unicorn
    Go the menu Extension, select Marketplace. Now search for Reporting Extension.
  • khannadhkhannadh Member Posts: 10 Contributor II
    Ok thanks for that. I installed the reporting extension. How do I export the results now? Thanks for your help.
  • batstache611batstache611 Member Posts: 45 Maven

    Oh man I've been having the same issue. Now I keep getting a blank report but here's what I did- drag your dataset to the process design panel, or drag a read csv/ read excep operator -> Generate Reports operator -> Reports operator. Make sure that the name of the report in both Generate Reports and Reports is same. Select the type of report you want in Generate Reports and provide a suitable location for the output. Under the parameters for Report operator, click Configure Report and Select Reportable Type - "Data Table", Select Reportable View - "Metadata View". 

    In theory this should work. But I keep getting a blank report everytime. Why is RapidMiner never very straightforward!?!?! :smileymad::womanmad::manmad::catmad:

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    The Reporting extension is a bit clunky and hard to use. It's from the v5.3 era where things weren't as streamlined as they are now. It does need to be updated but there is no timeline to do that. 

     

    If the general Aggregate operator doesn't work for you, have you checked out the Generate Aggregation operator? It allows you to do statistics across examples (rows).

Sign In or Register to comment.