"Finding a relation between two attributes of a database"

duyguduygu MemberPosts:12Contributor I
edited June 2019 inHelp
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 these2 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 WEMOSTLYSEE PILL AS A TREATMENT".


I hope i can explain:D
Duygu.
Tagged:

Answers

  • bkrieverbkriever RapidMiner Certified Analyst, MemberPosts:11Contributor 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 InorRegisterto comment.