The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 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.
Options

Pivot with multiple group attributes

hanni_eulerhanni_euler Member Posts: 2 Contributor I
edited November 2018 in Help

Hi everyone,

I'm new to Rapidminer, so my question might be super easy.

 

I have a data set with the following Attributes:

  • Model Code (identifies a group of cars)
  • VIN (identifies cars)
  • Part (identifies part of the car: Fender or door)
  • Measuring Point (identifies measuring points at the part)
  • Station (IFC or FQC -> two times of measurements)
  • Rating (Green: 1, Yellow: 2, Red: 3)

I want to get the IFC and FQC rating of one measuring point in one row (--> have 2 new attributes: IFC_Rating & FQC_Rating.

My problem is that the group attribute in the "Pivot" operator can only be one attribute.

What can I do?

 

Thank you in advance. Johannes

 

Best Answer

  • Options
    hanni_eulerhanni_euler Member Posts: 2 Contributor I
    Solution Accepted

    Thank you for your reply, T-Bone.

     

    I solved it now this way:

    1. Filter for two example sets (1. all Examples with IFC 2. all Examples with FQC).
    2. Rename "Rating" in both exampleSets
    3. Join them with key attributes VIN, part, side, model code, measuring point

     

    Best regards.

Answers

  • Options
    Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    Did you take a look at the Aggregate operator too? That allows you to group multiple attributes.

Sign In or Register to comment.