"discovering association rules"

zainab2013

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

MariusHelf

Hi,

please post the XML of your process.

Best regards,
Marius

zainab2013

   <?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]