• Extreme Optimization
  • Features
  • Solutions
  • Documentation
  • QuickStart Samples
  • Sample Applications
  • Downloads
  • Technical Support
  • Download trial
  • How to buy
  • Blog
  • Company
  • Resources
• Documentation
  • Introduction
  • Deployment Guide
  • Nuget packages
  • Configuration
  • Using Parallelism
  • Mathematics Library User's Guide
  • Vector and Matrix Library User's Guide
  • Data Analysis Library User's Guide
  • Statistics Library User's Guide
  • Data Access Library User's Guide
  • Reference
• Reference
  • Extreme
  • Extreme.Collections
  • Extreme.Data
  • Extreme.Data.Json
  • Extreme.Data.Matlab
  • Extreme.Data.R
  • Extreme.Data.Stata
  • Extreme.Data.Text
  • Extreme.DataAnalysis
  • Extreme.DataAnalysis.Linq
  • Extreme.DataAnalysis.Models
  • Extreme.Mathematics
  • Extreme.Mathematics.Algorithms
  • Extreme.Mathematics.Calculus
  • Extreme.Mathematics.Calculus.OrdinaryDifferentialEquations
  • Extreme.Mathematics.Curves
  • Extreme.Mathematics.Curves.Nonlinear
  • Extreme.Mathematics.Distributed
  • Extreme.Mathematics.EquationSolvers
  • Extreme.Mathematics.Generic
  • Extreme.Mathematics.LinearAlgebra
  • Extreme.Mathematics.LinearAlgebra.Implementation
  • Extreme.Mathematics.LinearAlgebra.IterativeSolvers
  • Extreme.Mathematics.LinearAlgebra.IterativeSolvers.Preconditioners
  • Extreme.Mathematics.Optimization
  • Extreme.Mathematics.Optimization.LineSearches
  • Extreme.Mathematics.Random
  • Extreme.Mathematics.SignalProcessing
  • Extreme.Providers
  • Extreme.Providers.InteropServices
  • Extreme.Statistics
  • Extreme.Statistics.Distributions
  • Extreme.Statistics.Multivariate
  • Extreme.Statistics.Tests
  • Extreme.Statistics.TimeSeriesAnalysis
• Extreme.DataAnalysis
  • Accumulator(T, U) Class
  • Aggregator(T, U) Class
  • Aggregator2(T, U) Class
  • Aggregator2Group Class
  • Aggregator2Group(T) Class
  • AggregatorGroup Class
  • AggregatorGroup(T) Class
  • Aggregators Class
  • BoundaryIntervalBehavior Enumeration
  • CategoricalEncoding Class
  • DataFrame Class
  • DataFrame(R, C) Class
  • DataFrameRow(R, C) Class
  • DateTimeExtensions Class
  • DateTimeUnit Enumeration
  • Direction Enumeration
  • Grouping Class
  • Grouping(TKey) Class
  • Histogram Class
  • Histogram(T) Class
  • IAccumulator(T, U) Interface
  • IAccumulator2(T, U) Interface
  • IAccumulator2(T, U, V) Interface
  • IAggregator Interface
  • IAggregator(T) Interface
  • IAggregator2 Interface
  • IAggregator2(T) Interface
  • IDataFrame Interface
  • IGrouping Interface
  • IIndex Interface
  • Index Class
  • Index(T) Class
  • IntervalIndex(T) Class
  • IPivot Interface
  • JoinIndex Class
  • JoinType Enumeration
  • MissingValueAction Enumeration
  • MissingValueException Class
  • MultipleMissingValueAction Enumeration
  • Parameter(T) Class
  • ParameterVector(T) Class
  • Pivot Class
  • Pivot(R, C) Class
  • RankTiebreaker Enumeration
  • Recurrence Class
  • SortOrder Enumeration
  • SpecialBins Enumeration
  • Subset Class
  • TransformedParameter(T) Class
  • TypePreservingAggregatorGroup Class
  • VectorExtensions Class
• Pivot Class
  • Pivot Constructor
  • Properties
  • Methods

Pivot Class

Extreme Optimization Numerical Libraries for .NET Professional

Represents a two-dimensional grouping of data.

Inheritance Hierarchy

---

SystemObject
  Extreme.DataAnalysisPivot
    Extreme.DataAnalysisPivotR, C

Namespace:  Extreme.DataAnalysis
Assembly:  Extreme.Numerics (in Extreme.Numerics.dll) Version: 8.1.1

Syntax

---

C#

VB

C++

F#

Copy

public class Pivot : IPivot, IGrouping

Public Class Pivot
	Implements IPivot, IGrouping

public ref class Pivot : IPivot, IGrouping

type Pivot =  
    class
        interface IPivot
        interface IGrouping
    end

The Pivot type exposes the following members.

Constructors

---

	Name	Description
	Pivot	Constructs a new pivot object, taking row and column keys from the specified vectors.

Top

Properties

---

	Name	Description
	ColumnIndex	Gets the index that contains the column keys to the groups.
	Count	Gets the number of groups.
	RowIndex	Gets the index that contains the row keys to the groups.

Top

Methods

---

	Name	Description
	AggregateIntoT, U(VectorT, AggregatorT, U, VectorU)	Applies the specified aggregator to the elements of a vector according to the current grouping.
	AggregateIntoT, U(VectorT, VectorT, Aggregator2T, U, VectorU)	Applies the specified aggregator to the elements of a vector according to the current grouping.
	CountsMatrix	Returns a matrix that contains the counts of the elements in each pivot cell.
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetCounts	Returns a histogram of the number of observations in each group.
	GetHashCode	Serves as the default hash function. (Inherited from Object.)
	GetIndexes(Int32)	Returns the sequence of indexes for the specified group.
	GetIndexes(Int32, Int32)	Gets a sequence of indexes for the grouping.
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	ToString	Returns a string that represents the current object. (Inherited from Object.)

Top

See Also

---

Reference

Extreme.DataAnalysis Namespace

Copyright © 2004-2021, Extreme Optimization. All rights reserved.
Extreme Optimization, Complexity made simple, M#, and M Sharp are trademarks of ExoAnalytics Inc.
Microsoft, Visual C#, Visual Basic, Visual Studio, Visual Studio.NET, and the Optimized for Visual Studio logo
are registered trademarks of Microsoft Corporation.