Help! i have a question

fanoos
fanoos New Altair Community Member
edited November 2024 in Community Q&A

Hi dear friends

 

theses days i was working on a data mining project for the first time and i faced with a problem

 

my data set was included of the result of 3 questions about 7 kind of sofa 

for example:

which sofa do you prefer from quality aspect??

the answer could be from 1 to 7

and

which sofa do you prefer from price aspect??

and 3rd one was about color

 

so the result was a matrix of 100 people which were asked these questions with 3 column that were integer numbers from 1 to 7

 

now i wanted to apply association rule on this data set in rapid miner 
and i expected to have such results : people have chosen first sofa from quality aspect usually have chosen third sofa from price aspect

 

but it was impossible because association rule module in rapid miner only works with Binominal data sets as you know ...

do you have any idea how can i solve this problem???

thanks for your help




 

 

Best Answer

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    Answer ✓

    You'll have to convert your data set using the Nominal to Numerical operator, set at Dummy Coding. That will create new attribute columns but with 1's and 0's. From there you can use the Numerical to Binominal operator to convert them to true and falses.

Answers

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    This question should be moved to the Getting Started forum.

    I would look at using the Numerical to Nominal operator.
  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    This question should be moved to the Getting Started forum.

    I would look at using the Numerical to Nominal operator.
  • fanoos
    fanoos New Altair Community Member
    Hi dear Thomas
    i added the question on the forum u said .
    about your suggestion i couldn't find the operator u introduced
    anyway it cant solve the problem because being nominal dose not concern with my problem
    if you want i can share data set with you which may helps understanding ...
    thanks for your help
    Rearguards
  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    Answer ✓

    You'll have to convert your data set using the Nominal to Numerical operator, set at Dummy Coding. That will create new attribute columns but with 1's and 0's. From there you can use the Numerical to Binominal operator to convert them to true and falses.

  • fanoos
    fanoos New Altair Community Member

    Hi dear Thomas 

    Thanks a million. It worked!:smileyvery-happy:

    But I can’t understand the method and why I have used these operators. In fact I don’t know about Dummy Coding concept. Would you pls introduce me an article or sth which makes it clear for me??

    Thanks again

    Regards