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.DataAnalysis
    • Accumulator 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
    • Pivot Class
    • Pivot(R, C) Class
    • RankTiebreaker Enumeration
    • Recurrence Class
    • SortOrder Enumeration
    • SpecialBins Enumeration
    • Subset Class
    • TypePreservingAggregatorGroup Class
    • VectorExtensions Class
  • DataFrame Class
    • Properties
    • Methods
  • Methods
    • Append Method Overloads
    • Apply(R, C, T) Method
    • CreateEmpty(R, C) Method
    • FromColumns Method Overloads
    • FromDataTable Method Overloads
    • FromMatrix Method Overloads
    • FromObjects Method Overloads
    • GetRows Method Overloads
    • Join Method Overloads
    • JoinOnNearest(R, C) Method
    • JoinOnSharedColumns(R1, R2, C) Method
    • ReadCsv Method Overloads
    • ReadDelimited Method
    • Resample Method Overloads
    • Stack Method Overloads
    • Unstack Method Overloads
    • WriteCsv(R, C) Method
DataFrame MethodsExtreme Optimization Numerical Libraries for .NET Professional

The DataFrame type exposes the following members.

Methods

  NameDescription
Public methodStatic memberAppendR, C(DataFrameR, C)
Combines data frames by appending the rows of the other data frame to the rows of this data frame.
Public methodStatic memberAppendR, C(IEnumerableDataFrameR, C, IndexC, Boolean)
Combines data frames by appending the rows of the other data frame to the rows of this data frame.
Public methodStatic memberAppendR, C(IEnumerableDataFrameR, C, JoinType, Boolean)
Combines data frames by appending the rows of the other data frame to the rows of this data frame.
Public methodStatic memberApplyR, C, T
Applies the specified matrix function to two data frames and returns the result.
Public methodStatic memberCreateEmptyR, C
Constructs an empty data frame.
Public methodStatic memberFromColumnsC(IDictionaryC, Object)
Constructs a new data frame from a dictionary of columns using a default index.
Public methodStatic memberFromColumnsC(TupleC, Object)
Constructs a new data frame from an array of tuples of key / column pairs using a default index.
Public methodStatic memberFromColumnsC(IEnumerableIVector, IndexC)
Constructs a new data frame from the specified columns and column index.
Public methodStatic memberFromColumnsC(IEnumerableIVector, IEnumerableC)
Creates a new data frame from the specified column labels and data.
Public methodStatic memberFromColumnsR, C(IDictionaryC, Object)
Constructs a new data frame from a dictionary of columns.
Public methodStatic memberFromColumnsR, C(IDictionaryC, Object, IndexR)
Constructs a new data frame from a dictionary of columns using the specified row index.
Public methodStatic memberFromColumnsR, C(IDictionaryC, Object, IndexR, IndexC)
Constructs a new data frame from a dictionary of columns using the specified row index.
Public methodStatic memberFromColumnsR, C(IEnumerableIVector, IndexR, IndexC)
Constructs a new data frame from the specified columns, row and column indexes.
Public methodStatic memberFromDataTable(DataTable)
Constructs a data frame from a data table.
Public methodStatic memberFromDataTable(DataTable, IEnumerableString)
Constructs a data frame from the specified columns in a data table.
Public methodStatic memberFromDataTableR(DataTable, String)
Constructs a data frame from a data table using the specified key column.
Public methodStatic memberFromDataTableR(DataTable, String, IEnumerableString)
Constructs a data frame from the specified columns in a data table using the specified key column.
Public methodStatic memberFromMatrixC, T(MatrixT, IndexC)
Constructs a new data frame from a matrix with a default row index.
Public methodStatic memberFromMatrixR, C, T(MatrixT, IndexR, IndexC)
Constructs a new data frame from a matrix.
Public methodStatic memberFromObjectsT(IEnumerableT)
Creates a new data frame containing the public properties of a sequence of objects.
Public methodStatic memberFromObjectsT(IEnumerableT, String)
Creates a new data frame containing the specified properties of a sequence of objects.
Public methodStatic memberFromObjectsT, R(IEnumerableT, String)
Creates a new data frame containing the public properties of a sequence of objects.
Public methodStatic memberFromObjectsT, R(IEnumerableT, String)
Creates a new data frame containing the specified properties of a sequence of objects.
Public methodStatic memberGetRowsR1, R2, C(DataFrameTupleR1, R2, C, R1)
Returns a data frame containing the rows where the first level of the index has the specified value.
Public methodStatic memberGetRowsR1, R2, R3, C(DataFrameTupleR1, R2, R3, C, R1)
Returns a data frame containing the rows where the first level of the index has the specified value.
Public methodStatic memberGetRowsR1, R2, R3, C(DataFrameTupleR1, R2, R3, C, R1, R2)
Returns a data frame containing the rows where the first two levels of the index have the specified values.
Public methodStatic memberJoinR(DataFrameR, String, DataFrameR, String, JoinType, String, String)
Returns a new data frame by joining this data frame with another data frame on the data frames' indexes.
Public methodStatic memberJoinR, C(DataFrameR, C, JoinType, DataFrameR, C, FuncC, C, FuncC, C)
Returns a new data frame by joining two data frames on their row indexes.
Public methodStatic memberJoinR1, R2(DataFrameR1, String, JoinType, DataFrameR2, String, IListString, String, String)
Returns a new data frame by joining this data frame with another data frame on the data frame's indexes.
Public methodStatic memberJoinR1, R2(DataFrameR1, String, JoinType, DataFrameR2, String, String, String, String)
Returns a new data frame by joining this data frame with another data frame on the data frame's row index.
Public methodStatic memberJoinR1, R2, C(DataFrameR1, C, JoinType, DataFrameR2, C, Boolean, C, C)
Returns a new data frame by joining two data frames on the specified columns in each data frame.
Public methodStatic memberJoinR1, R2, C(DataFrameR1, C, JoinType, DataFrameR2, C, IListC, FuncC, C, FuncC, C)
Returns a new data frame by joining a data frame to another on the specified columns of the left data frame and the row index of the right data frame.
Public methodStatic memberJoinR1, R2, C(DataFrameR1, C, JoinType, DataFrameR2, C, C, FuncC, C, FuncC, C)
Returns a new data frame by joining a data frame to another on the specified columns of the left data frame and the row index of the right data frame.
Public methodStatic memberJoinOnNearestR, C
Returns a new data frame by joining a data frames on the nearest keys in their row indexes.
Public methodStatic memberJoinOnSharedColumnsR1, R2, C
Returns a new data frame by joining two data frames on their shared columns.
Public methodStatic memberReadCsv(StreamReader, Boolean, Int32, CultureInfo, Boolean, Int32)
Reads a data frame from a CSV file.
Public methodStatic memberReadCsv(String, Boolean, Int32, CultureInfo, Boolean, Int32)
Reads a data frame from a CSV file.
Public methodStatic memberReadCsvR(StreamReader, String, Boolean, Boolean, Int32, CultureInfo, Boolean, Int32)
Reads a data frame from a CSV file and uses the specified column as the row index.
Public methodStatic memberReadCsvR(String, String, Boolean, Boolean, Int32, CultureInfo, Boolean, Int32)
Reads a data frame from a CSV file and uses the specified column as the row index.
Public methodStatic memberReadDelimited
Reads a data frame from a delimited text file.
Public methodStatic memberResampleC(DataFrameDateTime, C, Recurrence, IDictionaryC, AggregatorGroup, Direction)
Resamples the rows of the data frame according to the specified recurrence.
Public methodStatic memberResampleC(DataFrameDateTime, C, Recurrence, IListAggregatorGroup, Direction)
Resamples the rows of the data frame according to the specified recurrence.
Public methodStatic memberResampleC, C1(DataFrameDateTime, C, Recurrence, IEnumerableTupleC, AggregatorGroup, IndexC1, Direction)
Resamples the rows of the data frame according to the specified recurrence.
Public methodStatic memberStackR(DataFrameR, String, IEnumerableString, IEnumerableString, String, String)
Returns a data frame containing all values in the data frame as row-column-value pairs.
Public methodStatic memberStackR, C(DataFrameR, C, Boolean)
Transforms a data frame so that the column index is nested into the row index.
Public methodStatic memberStackR1, R2, C(DataFrameTupleR1, R2, C, Boolean)
Transforms a data frame so that the column index is nested into the row index.
Public methodStatic memberStackR, C1, C2(DataFrameR, TupleC1, C2, Boolean)
Transforms a data frame so that the second level of a two-level column index is nested into the row index.
Public methodStatic memberUnstackR, C(IVector)
Transforms a vector with a two-level index into a data frame whose columns correspond to the second level in the index.
Public methodStatic memberUnstackR1, R2, C(DataFrameTupleR1, R2, C)
Transforms a data frame with a two-level row index into a data frame whose columns correspond to the second level in the index.
Public methodStatic memberUnstackR1, R2, R3, C(DataFrameTupleR1, R2, R3, C)
Transforms a data frame with a three-level row index into a data frame whose columns correspond to the third level in the index.
Public methodStatic memberWriteCsvR, C
Writes a data frame to a CSV file.
Top
See Also

Reference

DataFrame Class
Extreme.DataAnalysis 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.