SOLVED
Contributor II

# Pivot

Hello eveyone

The attributes of my table are the following

I would like to calculate the average grade and standard deviation for each of my students in each subject on several years. I though that the PIVOT operator was the right one for that. But whatever  the weight aggregation (sum, standard deviation) I always obtain the highest grade for each student, not the average one or the standard deviation.

Could you help ?

Jean Claude

1 ACCEPTED SOLUTION

Accepted Solutions
RMStaff
Solution
Accepted by topic author jean_claude_van
2 weeks ago

## Re: Pivot

Hi,

Please have a look at the Aggregate operator. This looks like what you want to have. Please note that there is a difference between excel pivot and rapidminer pivot.

RapidMiner implements pivot like in Databases. The Excel pivot is in rapidminer language a Pivot + Aggregate.

Best,

Martin

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
3 REPLIES
Super Contributor

## Re: Pivot

Hi,

I think this is something that can be easier achieved using the "Generate Attribute" operator. For the average, you can just use the "avg" function as a function expression in this operator's panel. In terms of standard deviation, I don't think the "Generate Attribute" operator has a built-in function for this, but you can easily write it yourself.

RMStaff
Solution
Accepted by topic author jean_claude_van
2 weeks ago

## Re: Pivot

Hi,

Please have a look at the Aggregate operator. This looks like what you want to have. Please note that there is a difference between excel pivot and rapidminer pivot.

RapidMiner implements pivot like in Databases. The Excel pivot is in rapidminer language a Pivot + Aggregate.

Best,

Martin

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
Highlighted
Contributor II

## Re: Pivot

Thanks a lot

The aggregate operator is perfect for what I want to do

Jean claude