The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"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

  • 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.