groupByOther

Groups the rows of this Pivot into a PivotGroupBy based on the values of all columns except the pivot key columns. For example, if a DataFrame has columns "a", "b", "c", "d" and is pivoted by "a" and "c", then this Pivot will be grouped by the remaining columns "b" and "d".

PivotGroupBy is a dataframe-like structure that combines Pivot and GroupBy, representing a matrix table with vertical Pivot groups (as columns) and horizontal GroupBy groups (as rows), where each cell represents a group corresponding to both the GroupBy and Pivot key.

Reversed order of pivot and groupBy (i.e., DataFrame.pivot + Pivot.groupBy or DataFrame.groupBy + GroupBy.pivot) will produce the same result.

PivotGroupBy can be reduced or aggregated into a DataFrame.

Check out PivotGroupBy Grammar.

For more information: See "pivot + groupBy" on the documentation website.