Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Join: Inner/Outer left/right?
Contributor II
I am slightly confused by the join operator.
There are 4 types. For clarity what does each join type preform?
When only adding attributes to a small number of samples to a large group should 'outer' or 'left/right' be used?
???
Thanks,
-Gagi
There are 4 types. For clarity what does each join type preform?
When only adding attributes to a small number of samples to a large group should 'outer' or 'left/right' be used?
???
Thanks,
-Gagi
Tagged:
0
Answers
I think these types are equivalent to what is used in the database domain. Please take a look at http://en.wikipedia.org/wiki/Join_(SQL).
Greetings,
Sebastian
Inner Join = Only add attributes for matching IDs (intersection of IDs) (may remove some samples)
Left/Right Join = Only adds attributes to samples contained in the left/right data sets (keeps all samples from left or right) (can add missing values)
Outer Join = Joins all records from both datasets and adds missing values for attributes not shared between samples.
Hope this helps someone. Maybe we should add a wiki link in the help of this operator.
-Gagi