"Filter text processing output results to excel"

anjiang

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

MariusHelf

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

Himmat

Are you able to export data into excel

sridhar

Himmat wrote:
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

MariusHelf

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