"Filter data (file.xls) as a function of five parameters (attributes)"

MattMatt MemberPosts:2Contributor I
edited May 2019 inHelp
HI,

Is there any possibilty in RapidMiner5 to filter data (file.xls) as a function of five parameters (attributes)? I am looking for the number of machines being equipped with both item 1 and 2 having respectively the length X and Y.

attribute 1: item 1
attribute 2: feature of item 1 (e.g. length X)
attribute 3: item 2
attribute 4: feature of item 2 (e.g. length Y)
attribute 5: serial number of the machine

Result: number of machines responding to the same criteria ( item 1 length X + item 2 length Y).

I got a whole bunch of items and the user should be able to choose whatever two items (having different specifications) and get as result the number of machines equipped with these two items.

Do I useGenerate AttributeorLoopor whatever?

Is RapidMiner the right tool for this query?
I am newbie.
Would be glad about any return.
Thanks
Tagged:

Answers

  • MattMatt MemberPosts:2Contributor I
    Hello,

    Has no one gotten the slightest idea?

    随时回答在德国!
  • awchisholmawchisholm RapidMiner Certified Expert, MemberPosts:458Unicorn
    Hello

    The filter examples operator might do what you want although it seems to be limited to logical ANDs with two conditions.










    < = " re参数的关键pository_entry" value="//Samples/data/Iris"/>













    regards

    Andrew
  • SkirzynskiSkirzynski MemberPosts:164Maven
    Hi,

    i don't know exactly what you want to do, but filtering data is possible of course.

    At first you have to load your data into RapidMiner with the 'Read Excel' operator for example. Now you can filter your data with theFilter Exampleoperator. If you choose 'attribute_value_filter' as the condition class you can type "att1 > 20", so that every example will be filtered out if its attribute 'att1' is bigger than 20. Use the operator 'Generate Attribute' to create a new attribute which is the sum of two attributes.

    After that you can aggregate the filtered examples with theAggregateoperator which works similar to SQL-aggregation. So to get the number of examples you have to use the aggregation function "count".

    I hope this could help you. Otherwise try to post a minimal example dataset and the desired result.

    Regards
    Marcin
Sign InorRegisterto comment.