"discovering association rules"

zainab2013
zainab2013 New Altair Community Member
edited November 5 in Community Q&A
hi all,
please I need emergent help in discovering association rules in a dataset.
\i have created a process but the returned results have something wrong, I don't know what the problem is.
here is the results I get for the Iris dataset :
1 sepal width sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
2 sepal length sepal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
3 sepal width petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
4 petal width sepal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
5 sepal width petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
6 petal length sepal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
7 sepal length petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
8 petal width sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
9 sepal length petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
10 petal length sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
11 petal width petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
12 petal length petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
13 sepal width sepal length, petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
14 sepal length sepal width, petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
15 sepal width, sepal length petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
16 petal width sepal width, sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
17 sepal width, petal width sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
18 sepal length, petal width sepal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
19 sepal width sepal length, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
20 sepal length sepal width, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
21 sepal width, sepal length petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
22 petal length sepal width, sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
23 sepal width, petal length sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
24 sepal length, petal length sepal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
25 sepal width petal width, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
26 petal width sepal width, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
27 sepal width, petal width petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
28 petal length sepal width, petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
29 sepal width, petal length petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
30 petal width, petal length sepal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
31 sepal length petal width, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
32 petal width sepal length, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
33 sepal length, petal width petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
34 petal length sepal length, petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
35 sepal length, petal length petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
36 petal width, petal length sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
37 sepal width sepal length, petal width, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
38 sepal length sepal width, petal width, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
39 sepal width, sepal length petal width, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
40 petal width sepal width, sepal length, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
41 sepal width, petal width sepal length, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
42 sepal length, petal width sepal width, petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
43 sepal width, sepal length, petal width petal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
44 petal length sepal width, sepal length, petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
45 sepal width, petal length sepal length, petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
46 sepal length, petal length sepal width, petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
47 sepal width, sepal length, petal length petal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
48 petal width, petal length sepal width, sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
49 sepal width, petal width, petal length sepal length 1.0 1.0 1.0 -1.0 0.0 1.0 NaN
50 sepal length, petal width, petal length sepal width 1.0 1.0 1.0 -1.0 0.0 1.0 NaN

Answers

  • MariusHelf
    MariusHelf New Altair Community Member
    Hi,

    please post the XML of your process.

    Best regards,
    Marius
  • zainab2013
    zainab2013 New Altair Community Member
       <?xml version="1.0" encoding="UTF-8" standalone="no" ?> 
    - <process version="6.0.002">
    - <context>
      <input />
      <output />
      <macros />
      </context>
    - <operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
      <parameter key="logverbosity" value="init" />
      <parameter key="random_seed" value="2001" />
      <parameter key="send_mail" value="never" />
      <parameter key="notification_email" value="" />
      <parameter key="process_duration_for_mail" value="30" />
      <parameter key="encoding" value="SYSTEM" />
    - <process expanded="true">
    - <operator activated="true" class="read_arff" compatibility="6.0.002" expanded="true" height="60" name="Read ARFF" width="90" x="45" y="75">
      <parameter key="data_file" value="C:\Users\Admin\Desktop\iris.arff" />
      <parameter key="encoding" value="SYSTEM" />
      <parameter key="read_not_matching_values_as_missings" value="true" />
      <list key="data_set_meta_data_information" />
      <parameter key="attribute_names_already_defined" value="false" />
      <parameter key="decimal_character" value="." />
      <parameter key="grouped_digits" value="false" />
      <parameter key="grouping_character" value="," />
      </operator>
    - <operator activated="true" class="numerical_to_binominal" compatibility="6.0.002" expanded="true" height="76" name="Numerical to Binominal" width="90" x="179" y="210">
      <parameter key="attribute_filter_type" value="all" />
      <parameter key="attribute" value="" />
      <parameter key="attributes" value="" />
      <parameter key="use_except_expression" value="false" />
      <parameter key="value_type" value="numeric" />
      <parameter key="use_value_type_exception" value="false" />
      <parameter key="except_value_type" value="real" />
      <parameter key="block_type" value="value_series" />
      <parameter key="use_block_type_exception" value="false" />
      <parameter key="except_block_type" value="value_series_end" />
      <parameter key="invert_selection" value="false" />
      <parameter key="include_special_attributes" value="false" />
      <parameter key="min" value="0.0" />
      <parameter key="max" value="0.0" />
      </operator>
    - <operator activated="true" class="fp_growth" compatibility="6.0.002" expanded="true" height="76" name="FP-Growth" width="90" x="380" y="255">
      <parameter key="find_min_number_of_itemsets" value="true" />
      <parameter key="min_number_of_itemsets" value="100" />
      <parameter key="max_number_of_retries" value="15" />
      <parameter key="min_support" value="0.95" />
      <parameter key="max_items" value="-1" />
      <parameter key="keep_example_set" value="false" />
      </operator>
    - <operator activated="true" class="create_association_rules" compatibility="6.0.002" expanded="true" height="76" name="Create Association Rules" width="90" x="514" y="75">
      <parameter key="criterion" value="confidence" />
      <parameter key="min_confidence" value="0.8" />
      <parameter key="min_criterion_value" value="0.8" />
      <parameter key="gain_theta" value="2.0" />
      <parameter key="laplace_k" value="1.0" />
      </operator>
      <connect from_op="Read ARFF" from_port="output" to_op="Numerical to Binominal" to_port="example set input" />
      <connect from_op="Numerical to Binominal" from_port="example set output" to_op="FP-Growth" to_port="example set" />
      <connect from_op="FP-Growth" from_port="frequent sets" to_op="Create Association Rules" to_port="item sets" />
      <connect from_op="Create Association Rules" from_port="rules" to_port="result 1" />
      <portSpacing port="source_input 1" spacing="0" />
      <portSpacing port="sink_result 1" spacing="0" />
      <portSpacing port="sink_result 2" spacing="0" />
      </process>
      </operator>
      </process>
    dvdvideosoft_test_buttondvdvideosoft_youtube_video_downloader_buttondvdvideosoft_youtube_mp3_downloader_buttondvdvideosoft_youtube_iphone_downloader_buttondvdvideosoft_youtube_ipod_downloader_buttondvdvideosoft_youtube_dvd_downloader_buttondvdvideosoft_youtube_video_downloader_ex_buttondvdvideosoft_youtube_mp3_downloader_ex_buttondvdvideosoft_youtube_iphone_downloader_ex_buttondvdvideosoft_youtube_ipod_downloader_ex_buttondvdvideosoft_youtube_dvd_downloader_ex_buttondvdvideosoft_youtube_video_downloader_put_url_buttondvdvideosoft_youtube_mp3_downloader_put_url_buttondvdvideosoft_youtube_iphone_downloader_put_url_buttondvdvideosoft_youtube_ipod_downloader_put_url_buttondvdvideosoft_youtube_dvd_downloader_put_url_button [ /code]