Options

"Finding a relation between two attributes of a database"

duyguduygu Member Posts: 12 Contributor II
edited June 2019 in Help
Hi everyone,

my 'learning process' continues! I have a database with 2 columns. One of them contains diagnosis of some diseases. The other one contains treatment for these diseases.
Now the thing that i wan to do is to find a relation between these 2 columns. For example; diagnosis is "fever" and treatment for this diagnosis is "take a cold shower". Another; diagnosis is "fever" again but this time treatment is "pill". And goes on like this.

Like in the association examples can I find a relation like "fever->pill" ?

Can we say that "WHEN THERE IS FEVER IN DIAGNOSIS WE MOSTLY SEE PILL AS A TREATMENT".


I hope i can explain  :D
Duygu.
Tagged:

Answers

  • Options
    bkrieverbkriever RapidMiner Certified Analyst, Member Posts: 11 Contributor II
    If you are just looking for the most used treatment use the aggregate operator.  For 'Group by Attributes' select Diagnosis' and for 'Aggregation Attributes' select Treatment with the aggregation function set to Mode.
Sign In or Register to comment.