Preprocessing: Select attributes from the knowledge of an other table

User: "MoWei"
New Altair Community Member
Updated by Jocelyn

Hello everybody,

I have only recently started working with RapidMiner and am quite new in the field of machine learning. For a project at my university I'm mainly concerned with the preprocessing of data.

At the moment I am asking myself if it is possible to link two tables so that one table can take "knowledge" from the other table. I don't want to join them. Afterwards I would like to have further two single tables. A concrete example: I add a large dataset (from now on called dataset 1) that contains numerous attributes and examples. Furthermore I add a table in which all available attributes which are shown in the dataset 1 are listed (from now on called process value table). For the analysis of a certain question (from now on called analyse 1), however, I usually only need a small number of the given attributes. In the process value table the rows contain all attributes from dataset 1 and there is a column called "Required for analysis 1". If the value of this column is set to "Yes" for an attribute, then this attribute is needed for "Analysis 1". Now I would like to build my model so that I can say: All attributes where the word "Yes" is written in the column "Required for analysis 1" of the process value table should be selected from data set 1 and played back in order to start the analysis with the selected data afterwards.

I tried do showed it better with some pics, but I can't upload picture at the moment. I have to spend more time here, the system says :(

Does anyone have an idea how to implement this in RapidMiner? Maybe about some detours, transforming the process value table or something else?

I would be very grateful if someone can help me.

Many thanks in advance

Best regards

Moritz

Find more posts tagged with