RapidMiner

RapidMiner

Write Excel - generate "excel file name"/"sheet name" from parameter?

Contributor

Write Excel - generate "excel file name"/"sheet name" from parameter?

Hey there!

Is it possible to incorporate the "sample ratio" from "Sample" into the Excel file path/sheet name?
Is there a function or at least a workaround to do that?

My process looks like this:
I read my ExampleSet from the repository and go into "Loop parameter".
In this loop, the ExampleSet goes into "Sample"; the looped parameter is the sample ratio.

From this sampled ExampleSet, a model (Linear Regression) is built and evaluated.
The performance is transformed to data with "Performance to Data" and written with "Write Excel".

Best regards,
Flouyd
1 REPLY
Contributor

Re: Write Excel - generate "excel file name"/"sheet name" from parameter?

Solution found!

Based on this reply from awchisholm (http://rapid-i.com/rapidforum/index.php?action=profile;u=118), thank you by the way!

Hello

You could modify this example

http://rapidminernotes.blogspot.co.uk/2012/07/chopping-files-into-smaller-bits.html


regards

Andrew


I created a "set macro" with the macroname "sampleratio" and value "0.05" right after the data retrieval!
Afterwards I went into my loop and implemented a "generate macro" with the name "sampleratio" and function expression "%{sampleratio}+0.05" that adds to this macro!
In naming the files, espacially "Write Excel" you can access this macro by %{sampleratio}.
My sheetname looks like this "Sheet_%{sampleratio}_raw" and returns Sheet_0.05_raw > Sheet_0.1_raw and so on!