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.
Extract a subset of examples by using a list of IDs from a different ExampleSet
Learner III
Hi,
I have two ExampleSets which both have a different set of attributes, but the same IDs (as a string value). I import these data from csv-files. I want to get IDs from one ExampleSet by checking for a certain value for an attribute and use this list of IDs to filter Examples from the other ExampleSet.
In SQL Syntax it would be something like this:
SELECT * FROM table_1 WHERE table_1.id IN (SELECT id FROM table_2 WHERE table_2.attribute = value)
Is it possible to somehow save multiple values to a macro and loop over these to filter the examples from the other ExampleSet or what would be the best way to perform this task in RapidMiner?
Or would it be wise to code my own operator to do the operation or to perform this operation outside of RapidMiner? (E.g. by writing the data to an SQL-Database first)
btw: I am using the Community Edition of RapidMiner.
I have two ExampleSets which both have a different set of attributes, but the same IDs (as a string value). I import these data from csv-files. I want to get IDs from one ExampleSet by checking for a certain value for an attribute and use this list of IDs to filter Examples from the other ExampleSet.
In SQL Syntax it would be something like this:
SELECT * FROM table_1 WHERE table_1.id IN (SELECT id FROM table_2 WHERE table_2.attribute = value)
Is it possible to somehow save multiple values to a macro and loop over these to filter the examples from the other ExampleSet or what would be the best way to perform this task in RapidMiner?
Or would it be wise to code my own operator to do the operation or to perform this operation outside of RapidMiner? (E.g. by writing the data to an SQL-Database first)
btw: I am using the Community Edition of RapidMiner.
0
Answers
The Join operator works the same way as the SQL JOIN statement.
Best regards,
Marius