Extreme Optimization™: Complexity made simple.

Math and Statistics
Libraries for .NET

  • Home
  • Features
    • Math Library
    • Vector and Matrix Library
    • Statistics Library
    • Performance
    • Usability
  • Documentation
    • Introduction
    • Math Library User's Guide
    • Vector and Matrix Library User's Guide
    • Data Analysis Library User's Guide
    • Statistics Library User's Guide
    • Reference
  • Resources
    • Downloads
    • QuickStart Samples
    • Sample Applications
    • Frequently Asked Questions
    • Technical Support
  • Blog
  • Order
  • Company
    • About us
    • Testimonials
    • Customers
    • Press Releases
    • Careers
    • Partners
    • Contact us
Introduction
Deployment Guide
Configuration
Using Parallelism
Expand Mathematics Library User's GuideMathematics Library User's Guide
Expand Vector and Matrix Library User's GuideVector and Matrix Library User's Guide
Expand Data Analysis Library User's GuideData Analysis Library User's Guide
Expand Statistics Library User's GuideStatistics Library User's Guide
Expand Data Access Library User's GuideData Access Library User's Guide
Expand ReferenceReference
  • Extreme Optimization
    • Features
    • Solutions
    • Documentation
    • QuickStart Samples
    • Sample Applications
    • Downloads
    • Technical Support
    • Download trial
    • How to buy
    • Blog
    • Company
    • Resources
  • Documentation
    • Introduction
    • Deployment Guide
    • 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.Mathematics
    • Extreme.Mathematics.Algorithms
    • Extreme.Mathematics.Calculus
    • Extreme.Mathematics.Calculus.OrdinaryDifferentialEquations
    • Extreme.Mathematics.Curves
    • Extreme.Mathematics.Curves.Nonlinear
    • Extreme.Mathematics.Distributed
    • Extreme.Mathematics.Distributed.Cuda
    • Extreme.Mathematics.EquationSolvers
    • Extreme.Mathematics.FSharp
    • Extreme.Mathematics.Generic
    • Extreme.Mathematics.Generic.LinearAlgebra
    • Extreme.Mathematics.Generic.LinearAlgebra.Implementation
    • Extreme.Mathematics.Generic.LinearAlgebra.Providers
    • Extreme.Mathematics.Generic.SignalProcessing
    • Extreme.Mathematics.Implementation
    • Extreme.Mathematics.LinearAlgebra
    • Extreme.Mathematics.LinearAlgebra.Complex
    • Extreme.Mathematics.LinearAlgebra.Complex.Decompositions
    • Extreme.Mathematics.LinearAlgebra.Implementation
    • Extreme.Mathematics.LinearAlgebra.IO
    • Extreme.Mathematics.LinearAlgebra.IterativeSolvers
    • Extreme.Mathematics.LinearAlgebra.IterativeSolvers.Preconditioners
    • Extreme.Mathematics.LinearAlgebra.Providers
    • Extreme.Mathematics.LinearAlgebra.Sparse
    • Extreme.Mathematics.Optimization
    • Extreme.Mathematics.Optimization.Genetic
    • Extreme.Mathematics.Optimization.LineSearches
    • Extreme.Mathematics.Random
    • Extreme.Mathematics.SignalProcessing
    • Extreme.Numerics.FSharp
    • Extreme.Statistics
    • Extreme.Statistics.Distributions
    • Extreme.Statistics.IO
    • Extreme.Statistics.Linq
    • Extreme.Statistics.Multivariate
    • Extreme.Statistics.Random
    • Extreme.Statistics.Tests
    • Extreme.Statistics.TimeSeriesAnalysis
  • Extreme.Collections
    • Aggregator(T, U) Class
    • Aggregator2(T, U) Class
    • Aggregator2Group Class
    • Aggregator2Group(T) Class
    • AggregatorExtensions Class
    • AggregatorGroup Class
    • AggregatorGroup(T) Class
    • Aggregators Class
    • Array1D(T) Structure
    • Array2D(T) Structure
    • ArraySlice(T) Structure
    • DataFrame Class
    • DataFrame(R, C) Class
    • DataFrameRow(R, C) Class
    • DateTimeUnit Enumeration
    • Direction Enumeration
    • Grouping Class
    • Grouping(TKey) Class
    • IAccumulator(T, U) Interface
    • IAccumulator2(T, U) Interface
    • IAccumulator2(T, U, V) Interface
    • IAggregator Interface
    • IAggregator(T) Interface
    • IAggregator2 Interface
    • IAggregator2(T) Interface
    • ICategoricalVector Interface
    • IDataFrame Interface
    • IGrouping Interface
    • IIndex Interface
    • Index Class
    • Index(T) Class
    • IPivot Interface
    • IVector Interface
    • JoinType Enumeration
    • NativeArray1D(T) Structure
    • NativeArray2D(T) Structure
    • NativeArraySlice(T) Structure
    • Pivot Class
    • Pivot(R, C) Class
    • Recurrence Class
    • SortOrder Enumeration
    • TypedVectorWrapper(K, T) Structure
  • DataFrame(R, C) Class
    • DataFrame(R, C) Constructor
    • Properties
    • Methods
    • Operators
  • Methods
    • AddColumn Method Overloads
    • Aggregate Method Overloads
    • AggregateBy Method Overloads
    • Append Method
    • ApplyToColumns(T) Method
    • ApplyWith(T) Method
    • AsMatrix(T) Method
    • Clone Method
    • CombineWith(T) Method
    • FillMissingValues Method Overloads
    • GetColumn Method Overloads
    • GetColumns Method Overloads
    • GetEnumerator Method
    • GetNearestRow Method
    • GetNearestRowAs(T) Method
    • GetNearestRows Method
    • GetRow Method
    • GetRowAs Method Overloads
    • GetRows Method Overloads
    • GroupBy Method Overloads
    • GroupedBy(R1) Method
    • Head Method
    • JoinOnIndexWith Method
    • JoinWith Method Overloads
    • Pivot Method Overloads
    • PivotBy(R1, C1) Method
    • RemoveColumn Method
    • RemoveColumnAt Method
    • RemoveRows Method
    • RemoveRowsWithMissingValues Method Overloads
    • SelectRows Method Overloads
    • SortBy Method Overloads
    • SortByRowIndex Method
    • Stack Method
    • Summarize Method Overloads
    • Tail Method
    • ToMatrix(T) Method
    • ToString Method
    • ToVariableCollection Method
    • TransformColumns Method Overloads
    • TryGetRow Method
    • WithColumnIndex(C1) Method
    • WithRowIndex Method Overloads
  • AggregateBy Method Overloads
    • AggregateBy(R1) Method (IList(R1), AggregatorGroup[])
    • AggregateBy(R1, T) Method (IList(R1), AggregatorGroup(T))
    • AggregateBy(R1) Method (IList(R1), Tuple(C, AggregatorGroup)[])
    • AggregateBy(R1) Method (C, AggregatorGroup[])
    • AggregateBy(R1, T) Method (C, AggregatorGroup(T))
    • AggregateBy(R1, T, U) Method (C, Func(Vector(T), U))
    • AggregateBy(R1) Method (C, Tuple(C, AggregatorGroup)[])
    • AggregateBy(R1) Method (Grouping(R1), AggregatorGroup[])
    • AggregateBy(R1, T) Method (Grouping(R1), AggregatorGroup(T))
    • AggregateBy(R1) Method (Grouping(R1), Tuple(C, AggregatorGroup)[])
    • AggregateBy(R1) Method (IGrouping, AggregatorGroup[])
    • AggregateBy(R1, T) Method (IGrouping, AggregatorGroup(T))
    • AggregateBy(R1) Method (IGrouping, Tuple(C, AggregatorGroup)[])
  • AggregateBy(R1) Method (IList(R1), Tuple(C, AggregatorGroup)[])
DataFrameR, CAggregateByR1 Method (IListR1, TupleC, AggregatorGroup)Extreme Optimization Numerical Libraries for .NET Professional
Returns a new data frame that aggregates the columns grouped by the specified vector.

Namespace: Extreme.Collections
Assembly: Extreme.Numerics.Net40 (in Extreme.Numerics.Net40.dll) Version: 6.0.16073.0 (6.0.16312.0)
Syntax

C#
VB
C++
F#
Copy
public DataFrame<R1, Tuple<C, string>> AggregateBy<R1>(
	IList<R1> groupingVector,
	params Tuple<C, AggregatorGroup>[] aggregators
)
Public Function AggregateBy(Of R1) ( 
	groupingVector As IList(Of R1),
	ParamArray aggregators As Tuple(Of C, AggregatorGroup)()
) As DataFrame(Of R1, Tuple(Of C, String))
public:
generic<typename R1>
DataFrame<R1, Tuple<C, String^>^>^ AggregateBy(
	IList<R1>^ groupingVector, 
	... array<Tuple<C, AggregatorGroup^>^>^ aggregators
)
member AggregateBy : 
        groupingVector : IList<'R1> * 
        aggregators : Tuple<'C, AggregatorGroup>[] -> DataFrame<'R1, Tuple<'C, string>> 

Parameters

groupingVector
Type: System.Collections.GenericIListR1
A list that specifies group membership.
aggregators
Type: SystemTupleC, AggregatorGroup
One or more aggregators to apply to each group.

Type Parameters

R1
The element type of the grouping column.

Return Value

Type: DataFrameR1, TupleC, String
A new data frame with values the result of applying aggregators to each group of the remaining columns. The rows are indexed by the unique elements of the grouping vector. The columns are indexed by a multi-level index consisting of the original column key and the name of the aggregator.
Version Information

Numerical Libraries

Supported in: 5.x
See Also

Reference

DataFrameR, C Class
AggregateBy Overload
Extreme.Collections Namespace

Copyright (c) 2004-2016 ExoAnalytics Inc.

Send comments on this topic to support@extremeoptimization.com

Copyright © 2004-2018, 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.