Collective2 Explorer
Namespaces
Deedle
FrameModule Class
FrameModule Methods
AddColumn(C, R, V) Method
AggregateRowsBy(C, R, V1, V2) Method
ApplyLevel(R, K, T, C) Method
Columns(R, C) Method
CountColumns(R, C) Method
CountRows(R, C) Method
CountValues(R, C) Method
DenseColumns(R, C) Method
DenseRows(R, C) Method
Diff(R, C) Method
DropColumn(C, R) Method
DropSparseColumns(R, C) Method
DropSparseRows(R, C) Method
ExpandAllColumns(R) Method
ExpandColumns(R) Method
FillErrorsWith(T, R, C) Method
FillMissing(R, C) Method
FillMissingUsing(R, T, C) Method
FillMissingWith(T, R, C) Method
GetColumn(C, R, V) Method
GetColumns(R, C, T) Method
GetNumericColumns(R, C) Method
GetRow(R, C, a) Method
GetRows(R, C, T) Method
GroupRowsBy(C, R, K) Method
GroupRowsByBool(C, R) Method
GroupRowsByIndex(R, K, C) Method
GroupRowsByInt(C, R) Method
GroupRowsByObj(C, R) Method
GroupRowsByString(C, R) Method
GroupRowsUsing(R, C, K) Method
IndexColumnsWith(C2, R, C1) Method
IndexRows(C, R1, R2) Method
IndexRowsByDateTime(C, R1) Method
IndexRowsByDateTimeOffset(C, R1) Method
IndexRowsByInt(C, R1) Method
IndexRowsByObject(C, R1) Method
IndexRowsByString(C, R1) Method
IndexRowsOrdinally(TRowKey, TColumnKey) Method
IndexRowsUsing(C, R2, R1) Method
IndexRowsWith(R2, R1, C) Method
Join(R, C) Method
JoinAlign(R, C) Method
LookupColumn(C, R, V) Method
LookupRow(R, C, a) Method
map(R, C, a, b) Method
MapValues(a, b, R, C) Method
MaxRowBy(C, R) Method
Merge(R, C) Method
MergeAll(R, C) Method
MinRowBy(C, R) Method
Nest(R1, R2, C) Method
NestBy(K2, K1, C) Method
PivotTable(R, C, RNew, CNew, T) Method
RealignRows(R, C) Method
ReduceLevel(R, K, T, C) Method
ReduceValues(T, R, C) Method
ReplaceColumn(C, R) Method
Rows(R, C) Method
SelectColumnKeys(C, a, R) Method
SelectColumns(C, R, a, b) Method
SelectColumnValues(R, a, b, C) Method
SelectRowKeys(R1, R2, C) Method
SelectRows(R, C, V) Method
SelectRowValues(C, V, R) Method
Shift(R, C) Method
Skip(R, C) Method
SkipLast(R, C) Method
SliceCols(C, R) Method
SliceRows(R, C) Method
SortColumnsByKey(R, C) Method
SortRowBy(C, T, V, R) Method
SortRows(C, R) Method
SortRowsByKey(R, C) Method
SortRowsWith(C, a, R) Method
Stack(R, C) Method
Take(R, C) Method
TakeLast(R, C) Method
ToArray2D(R, C) Method
Transpose(R, TColumnKey) Method
TryLookupColObservation(C, R, a) Method
TryLookupColumn(C, R, V) Method
TryLookupRow(R, C, a) Method
TryLookupRowObservation(R, C, a) Method
TryMapRows(R, C, V) Method
TryValues(R, C) Method
Unnest(R1, R2, C) Method
Unstack(O, R, C) Method
WhereColumns(C, R) Method
WhereColumnValues(R, C) Method
WhereRows(R, C) Method
WhereRowsBy(C, V, R) Method
WhereRowValues(C, R) Method
Window(R, C) Method
WindowInto(R, C, a) Method
ZipAlignInto(V1, V2, V, R, C) Method
ZipInto(V1, V2, V, R, C) Method
Click or drag to resize
FrameModulePivotTableR, C, RNew, CNew, T Method
Creates a new data frame resulting from a 'pivot' operation. Consider a denormalized data frame representing a table: column labels are field names & table values are observations of those fields. pivotTable buckets the rows along two axes, according to the results of the functions `rowGrp` and `colGrp`; and then computes a value for the frame of rows that land in each bucket. ## Parameters - `rowGrp` - A function from rowkey & row to group value for the resulting row index - `colGrp` - A function from rowkey & row to group value for the resulting col index - `op` - A function computing a value from the corresponding bucket frame [category:Grouping, windowing and chunking]

Namespace:  Deedle
Assembly:  Deedle (in Deedle.dll) Version: 1.2
Syntax
C#
Copy
public static Frame<RNew, CNew> PivotTable<R, C, RNew, CNew, T>(
	FSharpFunc<R, FSharpFunc<ObjectSeries<C>, RNew>> rowGrp,
	FSharpFunc<R, FSharpFunc<ObjectSeries<C>, CNew>> colGrp,
	FSharpFunc<Frame<R, C>, T> op,
	Frame<R, C> frame
)

Parameters

rowGrp
Type: Microsoft.FSharp.CoreFSharpFuncR, FSharpFuncObjectSeriesC, RNew

[Missing <param name="rowGrp"/> documentation for "M:Deedle.FrameModule.PivotTable``5(Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``2}},Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``3}},Microsoft.FSharp.Core.FSharpFunc{Deedle.Frame{``0,``1},``4},Deedle.Frame{``0,``1})"]

colGrp
Type: Microsoft.FSharp.CoreFSharpFuncR, FSharpFuncObjectSeriesC, CNew

[Missing <param name="colGrp"/> documentation for "M:Deedle.FrameModule.PivotTable``5(Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``2}},Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``3}},Microsoft.FSharp.Core.FSharpFunc{Deedle.Frame{``0,``1},``4},Deedle.Frame{``0,``1})"]

op
Type: Microsoft.FSharp.CoreFSharpFuncFrameR, C, T

[Missing <param name="op"/> documentation for "M:Deedle.FrameModule.PivotTable``5(Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``2}},Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``3}},Microsoft.FSharp.Core.FSharpFunc{Deedle.Frame{``0,``1},``4},Deedle.Frame{``0,``1})"]

frame
Type: DeedleFrameR, C

[Missing <param name="frame"/> documentation for "M:Deedle.FrameModule.PivotTable``5(Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``2}},Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``3}},Microsoft.FSharp.Core.FSharpFunc{Deedle.Frame{``0,``1},``4},Deedle.Frame{``0,``1})"]

Type Parameters

R
C
RNew
CNew
T

Return Value

Type: FrameRNew, CNew

[Missing <returns> documentation for "M:Deedle.FrameModule.PivotTable``5(Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``2}},Microsoft.FSharp.Core.FSharpFunc{``0,Microsoft.FSharp.Core.FSharpFunc{Deedle.ObjectSeries{``1},``3}},Microsoft.FSharp.Core.FSharpFunc{Deedle.Frame{``0,``1},``4},Deedle.Frame{``0,``1})"]

See Also