Pivot

Definition

Transform selected column in multiple column for each different value.

Parameters

1. Group by (+add):

   • Def: Specify the columns for grouping element.

2. Pivot column:

   • Def: Specify the column to transform in multiple column.

3. Function:

   • Def: Specify the function to apply in the groupBy.

4. Column input:

   • Def: Specify the column to apply the function.

Additionnal Comments

Functions:

1. count:

   • Def: Count the element in the Column input for each group.
     Link to the Count page.

2. countNotNull:

   • Def: Count the non-null element in the Column input for each group.
     Link to the Count page.

3. CountNull:

   • Def: Count the null element in the Column input for each group.
     Link to the Count page.

4. sum:

   • Def: Sum all the element of the Column input for each group.
     Link to the Sum page.

5. avg:

   • Def: Returns the average of the Column input for each group.
     Link to the Average page.

6. mean:

   • Def: Returns the mean of the Column input for each group.

7. var:

   • Def: Returns the variance of the Column input for each group.
     Link to the Var page.

8. std:

   • Def: Returns the standart deviation of the Column input for each group.

9. max:

   • Def: Returns the maximum value of the Column input for each group.
     Link to the Max page.

10. min:

    • Def: Returns the maximum value of the Column input for each group.
      Link to the Min page.

11. distinct:

    • Def: Returns all the distinct element of the Column input for each group in a single array.

12. all:

    • Def: Returns all the element of the Column input for each group in a single array. (let the duplicated element).