Export Summary Statistics from Results view to Excel

khannadh

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

JEdward

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. 

khannadh

Hi Jedward. How do you use the reporting extension? Where do I go for that?
Could you please let me know?

Thank you.

earmijo

Go the menu Extension, select Marketplace. Now search for Reporting Extension.

khannadh

Ok thanks for that. I installed the reporting extension. How do I export the results now? Thanks for your help.

batstache611

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_Ott

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).