"Writing Associations rules to Excel"

tinkerztinkerz Member Posts: 5 Contributor II
edited May 2019 in Help
I can copy the text view to excel and export the result writer to a file, but i would like to
send the complete table view to excel with all the extra tables on it

How do I do that, and I am now 100% sure about sending results to excel or a CSV file is there a tutorial on it

Thanks

Neil


<operator name="Root" class="Process" expanded="yes">
    <description text="#ylt#p#ygt#This process uses two important preprocessing operators: First the frequency discretization operator,  which discretizes numerical attributes by putting the values into bins of equal size. Second, the filter operator nominal to binominal creates for each possible nominal value of a polynominal attribute a new binominal (binary) feature which is true if the example had the particular nominal value.#ylt#/p#ygt##ylt#p#ygt#These preprocessing operators are necessary since particular learning schemes can not handle attributes  of certain value types. For example, the very efficient frequent item set mining operator FPGrowth used in this process setup can only handle binominal features and no numerical or polynominal ones.#ylt#/p#ygt##ylt#p#ygt#The next operator is the frequent item set mining operator FPGrowth. This operator  efficiently calculates attribute value sets often occuring together. From these  so called frequent item sets the most confident rules are calculated. with the association rule generator.#ylt#/p#ygt# #ylt#p#ygt# The result will be displayed in a rule browser where desired conclusion can be selected in a selection list on the left side. As for all other tables available in RapidMiner you can sort the columns by clicking on the column header. Pressing CTRL during these clicks allows the selection for up to three sorting columns. #ylt#/p#ygt# "/>
    <parameter key="logverbosity" value="warning"/>
    <operator name="ExampleSource" class="ExampleSource">
        <parameter key="attributes" value="C:\Documents and Settings\Neil3\My Documents\rm_workspace\Neil\Volatility\CCnum8082005.aml"/>
    </operator>
    <operator name="Preprocessing" class="OperatorChain" expanded="yes">
        <operator name="Numerical2Binominal" class="Numerical2Binominal">
        </operator>
    </operator>
    <operator name="FPGrowth" class="FPGrowth">
        <parameter key="find_min_number_of_itemsets" value="false"/>
        <parameter key="min_number_of_itemsets" value="20"/>
        <parameter key="positive_value" value="true"/>
        <parameter key="min_support" value="0.1"/>
    </operator>
    <operator name="AssociationRuleGenerator" class="AssociationRuleGenerator">
        <parameter key="keep_frequent_item_sets" value="true"/>
        <parameter key="min_confidence" value="0.5"/>
    </operator>
    <operator name="ResultWriter" class="ResultWriter">
        <parameter key="result_file" value="C:\Documents and Settings\Neil3\My Documents\rm_workspace\Neil\123.res"/>
    </operator>
    <operator name="ExcelExampleSetWriter" class="ExcelExampleSetWriter">
        <parameter key="excel_file" value="C:\Documents and Settings\All Users\Documents\Volatilityfolder\atest.xls"/>
    </operator>
</operator>
Tagged:

Answers

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn
    Hi Neil,
    this functionality is part of the enterprise version only. There you can export every table format into an excel sheet...

    Greetings,
      Sebastian
Sign In or Register to comment.