Collective2 Explorer
Namespaces
Deedle
FrameExtensions Class
FrameExtensions Methods
CountColumns(R, C) Method
CountRows(R, C) Method
Diff(TRowKey, TColumnKey) Method
DropSparseColumns(TRowKey, TColumnKey) Method
DropSparseRows(TRowKey, TColumnKey) Method
ExpandColumns Method
FillMissing Method
FilterRowsBy(TRowKey, TColumnKey, V) Method
GetRows(TRowKey, TColumnKey) Method
GetRowsAt(TRowKey, TColumnKey) Method
GetSlice Method
IndexColumnsWith(R, C, TNewRowIndex) Method
IndexRowsOrdinally(TRowKey, TColumnKey) Method
IndexRowsUsing(R, C, R2) Method
IndexRowsWith(R, C, TNewRowIndex) Method
Merge(TRowKey, TColumnKey) Method
Nest(TRowKey1, TRowKey2, TColumnKey) Method
NestBy(TRowKey1, TColumnKey, TRowKey2) Method
OrderColumns(TRowKey, TColumnKey) Method
OrderRows(TRowKey, TColumnKey) Method
PivotTable(R, C, RNew, CNew, T) Method
Print Method
RealignRows(R, C) Method
Reduce(TRowKey, TColumnKey, T) Method
SaveCsv Method
Select Method
SelectColumnKeys(TRowKey, TColumnKey, a) Method
SelectRowKeys(TRowKey, TColumnKey, a) Method
Shift(TRowKey, TColumnKey) Method
SortByColKey(TRowKey, TColumnKey) Method
SortByRowKey(TRowKey, TColumnKey) Method
SortColumnsByKey(TRowKey, TColumnKey) Method
SortRows(TRowKey, TColumnKey) Method
SortRowsBy(TRowKey, TColumnKey, V, V2) Method
SortRowsByKey(TRowKey, TColumnKey) Method
SortRowsWith(TRowKey, TColumnKey, V) Method
Sum(R, C) Method
ToDataTable(R, C) Method
Transpose(TRowKey, TColumnKey) Method
Unnest(TRowKey1, TRowKey2, TColumnKey) Method
Where Method
Window Method
Click or drag to resize
FrameExtensionsPivotTableR, 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 values of the columns `r` and `c`; and then computes a value for the frame of rows that land in each bucket. ## Parameters - `r` - A column key to group on for the resulting row index - `c` - A column key to group on for the resulting col index - `op` - A function computing a value from the corresponding bucket frame [category:Frame operations]

Namespace:  Deedle
Assembly:  Deedle (in Deedle.dll) Version: 1.2
Syntax
C#
Copy
public static Frame<RNew, CNew> PivotTable<R, C, RNew, CNew, T>(
	this Frame<R, C> frame,
	C r,
	C c,
	Func<Frame<R, C>, T> op
)

Parameters

frame
Type: DeedleFrameR, C

[Missing <param name="frame"/> documentation for "M:Deedle.FrameExtensions.PivotTable``5(Deedle.Frame{``0,``1},``1,``1,System.Func{Deedle.Frame{``0,``1},``4})"]

r
Type: C

[Missing <param name="r"/> documentation for "M:Deedle.FrameExtensions.PivotTable``5(Deedle.Frame{``0,``1},``1,``1,System.Func{Deedle.Frame{``0,``1},``4})"]

c
Type: C

[Missing <param name="c"/> documentation for "M:Deedle.FrameExtensions.PivotTable``5(Deedle.Frame{``0,``1},``1,``1,System.Func{Deedle.Frame{``0,``1},``4})"]

op
Type: SystemFuncFrameR, C, T

[Missing <param name="op"/> documentation for "M:Deedle.FrameExtensions.PivotTable``5(Deedle.Frame{``0,``1},``1,``1,System.Func{Deedle.Frame{``0,``1},``4})"]

Type Parameters

R
C
RNew
CNew
T

Return Value

Type: FrameRNew, CNew

[Missing <returns> documentation for "M:Deedle.FrameExtensions.PivotTable``5(Deedle.Frame{``0,``1},``1,``1,System.Func{Deedle.Frame{``0,``1},``4})"]

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type FrameR, C. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).
See Also