Constructs a new data frame using the specified columns as row and column indexes
and aggregates the values corresponding to each row-column pair.
Namespace:
Extreme.DataAnalysis
Assembly:
Extreme.Numerics (in Extreme.Numerics.dll) Version: 8.1.1
public DataFrame<R1, C1> Pivot<R1, C1, T>(
C rows,
C columns,
C values,
AggregatorGroup<T> aggregator
)
Public Function Pivot(Of R1, C1, T) (
rows As C,
columns As C,
values As C,
aggregator As AggregatorGroup(Of T)
) As DataFrame(Of R1, C1)
public:
generic<typename R1, typename C1, typename T>
DataFrame<R1, C1>^ Pivot(
C rows,
C columns,
C values,
AggregatorGroup<T>^ aggregator
)
member Pivot :
rows : 'C *
columns : 'C *
values : 'C *
aggregator : AggregatorGroup<'T> -> DataFrame<'R1, 'C1>
Parameters
- rows
- Type: C
The key of the column that contains the row indexes. - columns
- Type: C
The key of the column that contains the column indexes. - values
- Type: C
The key of the column that contains the values. - aggregator
- Type: Extreme.DataAnalysisAggregatorGroupT
An aggregator to apply to each group.
Type Parameters
- R1
- The element type of the column that contains the row indexes.
- C1
- The element type of the column that contains the column indexes.
- T
- The element type of the column that contains the values.
Return Value
Type:
DataFrameR1,
C1A new data frame with
rows indexed by the unique values in the column with key
rows,
columns indexed by the unique values in the column with key
columns,
and values the result of aggregating the values in the column with key
values
grouped by the keys in these columns using
aggregator.
| Exception | Condition |
|---|
| KeyNotFoundException | The value rows could not be found in the data frame's column index. -or- The value columns could not be found in the data frame's column index. -or- The value values could not be found in the data frame's column index. |
| InvalidCastException | The column with key rows could not be cast to type R1. -or- The column with key columns could not be cast to type C1. |
Reference