"Write Excel - generate excel file name / sheet name from parameter?"
Flouyd
New Altair Community Member
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
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
0
Answers
-
Solution found!
Based on this reply from awchisholm (http://rapid-i.com/rapidforum/index.php?action=profile;u=118), thank you by the way!
I created a "set macro" with the macroname "sampleratio" and value "0.05" right after the data retrieval!Hello
You could modify this example
http://rapidminernotes.blogspot.co.uk/2012/07/chopping-files-into-smaller-bits.html
regards
Andrew
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!
0