Pages: [1]
  Print  
Author Topic: Filter text processing output results to excel  (Read 754 times)
anjiang
Newbie
*
Posts: 1


« on: December 19, 2012, 04:40:17 PM »

Hi All,

I am trying to figure out how to restrict the output that I export to excel after running my model. It's just a simple categorization where I apply a model to a new spreadsheet to categorize the contents of each cell. The spreadsheet has about 200 rows and when I try to export it to excel, it includes all the confidence level data for each prediction. Is it possible to only display the prediction results and exclude the confidence levels from the export?


Hi All,

I am trying to figure out how to restrict the output that I export to excel after running my model. It's just a simple categorization where I apply a model to a new spreadsheet to categorize the contents of each cell. The spreadsheet has about 200 rows and when I try to export it to excel, it includes all the confidence level data for each prediction which gets represented by a column and populates all the rows with the confidence. Is it possible to only display the prediction results and exclude the confidence levels from the export?


Thanks,

Tony

Logged
Marius
Administrator
Hero Member
*****
Posts: 1794



WWW
« Reply #1 on: January 02, 2013, 10:07:41 AM »

Hi,

you can use Select Attributes for that. Since you want to handle (i.e. select/remove) the confidence values, which are actually special attributes, please be sure to tick the "include special attributes" parameter.

Best regards,
Marius
Logged

Please add [SOLVED] to the topic title when your problem has been solved! (do so by editing the first post in the thread and modifying the title)
Please click here before posting.
Himmat
Newbie
*
Posts: 1


« Reply #2 on: September 25, 2013, 09:13:33 AM »

Are you able to export data into excel
Logged
sridhar
Newbie
*
Posts: 2


« Reply #3 on: December 21, 2013, 07:34:37 AM »

hi i'm trying to export the Exampleset (process document) result view into excel, can any one help me from this.. here im getting porblem with excel. when i'm going to export the data using "Write Excel" node its shows "Memory buffered file". can any one suggest me better way to get the result in excel file. Thanks
Logged
Marius
Administrator
Hero Member
*****
Posts: 1794



WWW
« Reply #4 on: December 23, 2013, 11:19:41 AM »

Hi Himmat and sridar,

the original post was about *filtering* the output.

To get RapidMiner exporting data to Excel in first place you can use the Write Excel operator. In most situations you must *not* connect the fil-output of that operator. Otherwise you have the problem that Himmat described. If you disconnect the port you can select the target file in the operator parameters.

Best regards,
Marius
Logged

Please add [SOLVED] to the topic title when your problem has been solved! (do so by editing the first post in the thread and modifying the title)
Please click here before posting.
Pages: [1]
  Print  
 
Jump to: