Group by

Definition

Combines rows into groups based on matching values in specified columns.

Parameters

1. Group by:

   • Def: Specify the columns for grouping element.

2. Functions (+add):

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

2.1. Column input:

• Def: Specify the name of the column.

2.2. Column output:

• Def: Specify the name of the column.

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. median:

    • Def: Returns the median of the Column input for each group.
      Link to the Median page.

12. distinct:

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

13. all:

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

14. firstValue:

    • Def: Returns the first value of the Column input for each group (you need to order one field).

15. lastValue:

    • Def: Returns the last value of the Column input for each group (you need to order one field).

OrderBy:

1. desc_null_first:

   • Descending order with the nulls in first position.

2. asc_null_first:

   • Ascending order with the nulls in first position.

3. desc_null_last:

   • Descending order with the nulls in last position.

4. asc_null_last:

   • Ascending order with the nulls in last position.