DataFrame<R, C> Methods

Methods

AddColumn(C, IVector) Adds a column to the data frame.
AddColumn<T>(C, Vector<T>) Adds a column to the data frame.
AddColumn<T>(C, IList<T>) Adds a column to the data frame.
Aggregate<COut>(Aggregation<C, COut>[]) Aggregates selected columns using typed aggregation descriptors.
Aggregate<T>(AggregatorGroup<T>) Applies the specified aggregator to all the columns in the data frame.
Aggregate<T>(AggregatorGroup<T>[]) Applies the specified aggregators to all the columns in the data frame.
Aggregate<COut>(IEnumerable<Aggregation<C, COut>>) Aggregates selected columns using typed aggregation descriptors.
Aggregate<T, TResult>(Func<Vector<T>, TResult>) Applies the specified aggregators to all the columns in the data frame.
Aggregate<TKey, COut>(Grouping<TKey>, Aggregation<C, COut>[]) Aggregates selected columns over an existing grouping using typed aggregation descriptors.
Aggregate<TKey, COut>(Grouping<TKey>, IEnumerable<Aggregation<C, COut>>) Aggregates selected columns over an existing grouping using typed aggregation descriptors.
Aggregate<TKey, COut>(GroupingTemplate<TKey>, Aggregation<C, COut>[]) Aggregates selected columns over a grouping template using typed aggregation descriptors.
Aggregate<TKey, COut>(GroupingTemplate<TKey>, IEnumerable<Aggregation<C, COut>>) Aggregates selected columns over a grouping template using typed aggregation descriptors.
Aggregate<T1, T2, TResult>(Func<Vector<T1>, TResult>, Func<Vector<T2>, TResult>) Applies the specified aggregators to all the columns in the data frame.
Aggregate<T1, T2, T3, TResult>(Func<Vector<T1>, TResult>, Func<Vector<T2>, TResult>, Func<Vector<T3>, TResult>) Applies the specified aggregators to all the columns in the data frame.
AggregateBy<R1>(C, AggregatorGroup[]) Returns a new data frame that aggregates the columns grouped by the specified column.
AggregateBy<R1>(C, ValueTuple<C, AggregatorGroup>[]) Returns a new data frame that aggregates the columns grouped by the specified column.
AggregateBy<R1>(Grouping<R1>, AggregatorGroup[]) Returns a new data frame that aggregates the columns according to the specified grouping.
AggregateBy<R1>(Grouping<R1>, IDictionary<C, AggregatorGroup>) Applies the aggregators from a dictionary to selected columns in the data frame.
AggregateBy<R1>(Grouping<R1>, ValueTuple<C, AggregatorGroup>[]) Returns a new data frame that aggregates the columns according to the specified grouping.
AggregateBy<R1>(GroupingTemplate<R1>, AggregatorGroup[]) Returns a new data frame that aggregates all columns according to a dataframe grouping template.
AggregateBy<R1>(GroupingTemplate<R1>, IDictionary<C, AggregatorGroup>) Applies the aggregators from a dictionary to selected columns grouped by a dataframe grouping template.
AggregateBy<R1>(GroupingTemplate<R1>, ValueTuple<C, AggregatorGroup>[]) Returns a new data frame that aggregates selected columns according to a dataframe grouping template.
AggregateBy<R1>(IGrouping, AggregatorGroup[]) Returns a new data frame that aggregates the columns according to the specified grouping.
AggregateBy<R1>(IGrouping, ValueTuple<C, AggregatorGroup>[]) Returns a new data frame that aggregates the columns according to the specified grouping.
AggregateBy<R1>(IList<R1>, AggregatorGroup[]) Returns a new data frame that aggregates the columns grouped by the specified vector.
AggregateBy<R1>(IList<R1>, ValueTuple<C, AggregatorGroup>[]) Returns a new data frame that aggregates the columns grouped by the specified vector.
AggregateBy<R1, T>(C, AggregatorGroup<T>) Returns a new data frame that aggregates the columns grouped by the specified column.
AggregateBy<R1, T>(Grouping<R1>, AggregatorGroup<T>) Returns a new data frame that aggregates the columns according to the specified grouping.
AggregateBy<R1, T>(GroupingTemplate<R1>, AggregatorGroup<T>) Returns a new data frame that aggregates the columns according to a dataframe grouping template.
AggregateBy<R1, T>(IGrouping, AggregatorGroup<T>) Returns a new data frame that aggregates the columns according to the specified grouping.
AggregateBy<R1, T>(IList<R1>, AggregatorGroup<T>) Returns a new data frame that aggregates the columns grouped by the specified vector.
AggregateBy<R1, C1>(Grouping<R1>, IEnumerable<ValueTuple<C, AggregatorGroup>>, Index<C1>) Applies the specified aggregators to all the columns in the data frame.
AggregateBy<R1, C1>(GroupingTemplate<R1>, IEnumerable<ValueTuple<C, AggregatorGroup>>, Index<C1>) Applies the specified aggregators to selected columns grouped by a dataframe grouping template.
AggregateBy<R1, T, U>(C, Func<Vector<T>, U>) Applies the specified aggregation function to the values in each column grouped by the specified grouping column.
Append(DataFrame<R, C>, Index<C>, Boolean) Combines two data frames by appending the rows of the right data frame to the rows of this data frame.
Append(DataFrame<R, C>, JoinType, Boolean) Combines two data frames by appending the rows of the right data frame to the rows of this data frame.
ApplyWith<T> Applies a matrix function to this data frame and another and returns the result as a data frame.
ClearColumnRole(ColumnSelector) Clears explicit roles assigned to columns selected by a selector.
ClearColumnRole(C) Clears any explicit role assigned to the specified column.
ClearColumnSemantics Clears explicit semantic metadata assigned to the specified column.
Clone Makes a copy of the data frame.
CombineWith<T> Combines the data frame with another data frame, aligning the two data frames and using the specified function to generate the value for common values.
Describe Returns a data frame containing descriptive statistics for each column in the data frame.
EqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
FinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object)
GetColumn(C) Gets the specified column as a Double vector.
GetColumn<T>(C) Gets the specified column as a strongly typed vector.
GetColumnRole Gets the role assigned to the specified column.
GetColumns(ColumnSelector) Returns a new data frame that contains columns selected by a column selector.
GetColumns(C[]) Returns a new data frame that contains only the specified columns.
GetColumns(IEnumerable<C>) Returns a new data frame that contains only the specified columns.
GetColumnsAt(IEnumerable<Int32>) Returns a new data frame that contains only the specified columns.
GetColumnsAt(Int32[]) Returns a new data frame that contains only the specified columns.
GetColumnSemantics Gets semantic metadata assigned to the specified column.
GetEnumerator Gets an enumerator for the rows of the data frame.
GetHashCodeServes as the default hash function.
(Inherited from Object)
GetNearestRow Gets the row nearest to the specified row key.
GetNearestRowAs<T> Gets the row at the specified row index as a vector of the specified type.
GetNearestRows Returns a new data frame that contains only the rows in the specified sequence.
GetRow Gets the row with the specified row key.
GetRowAs<T> Gets the row at the specified row index as a vector of the specified type.
GetRowAt Gets the row with the specified row key.
GetRowAtAs<T> Gets the row at the specified row index.
GetRows(R[]) Returns a new data frame that contains only the rows with keys in the specified array.
GetRows(IEnumerable<R>) Returns a new data frame that contains only the rows in the specified sequence.
GetRows(Subset) Returns a new data frame that contains only the rows in the specified subset.
GetRows(Vector<Boolean>) Returns a new data frame that contains only the rows specified by a boolean mask.
GetRows(R, R) Returns a new data frame that contains only the rows specified by a range.
GetRowsAt Returns a new data frame that contains only the rows in the specified sequence.
GetSchema Gets a read-only snapshot of the data frame schema.
GetTypeGets the Type of the current instance.
(Inherited from Object)
GroupBy<R1>(C) Returns a hierarchical index consisting of the current index grouped by the specified column.
GroupBy<R1>(IList<R1>) Returns a hierarchical grouping consisting of the current index grouped by the specified grouping values.
GroupBy<R1, R2>(C, C) Returns a hierarchical grouping on two columns.
GroupedBy<R1> Returns a new data frame by grouping the index by the specified column.
Head Returns the first few rows of the data frame.
MakeCategorical(C) Marks the specified column as containing categorical data.
MakeCategorical(C[]) Marks the specified columns as containing categorical data.
MakeCategorical<T>(C, Index<T>, Boolean) Marks the specified column as containing categorical data.
MakeCategoricalAt(Int32) Marks the column at the specified index as containing categorical data.
MakeCategoricalAt<T>(Int32, Index<T>, Boolean) Marks the column at the specified index as containing categorical data.
Map(IList<C>, Func<IVector, IVector>, IList<C>) Applies the specified function to selected columns and returns the result in a new data frame.
Map(IList<C>, Func<IVector, IVector>, Func<C, C>) Applies the specified function to selected columns and returns the result in a new data frame.
Map<T>(Func<Vector<T>, IVector>) Applies the specified function to all columns with the specified element type and returns the result in a new data frame.
Map<T>(IList<C>, Func<Vector<T>, IVector>, IList<C>) Applies the specified function to selected columns.
Map<T>(IList<C>, Func<Vector<T>, IVector>, Func<C, C>) Applies the specified function to selected columns.
MapAndAppend(C, Func<IVector, IVector>, C) Applies the specified function to selected columns and appends the results to the end of the data frame.
MapAndAppend(IList<C>, Func<IVector, IVector>, IList<C>) Applies the specified function to selected columns and appends the results to the end of the data frame.
MapAndAppend(IList<C>, Func<IVector, IVector>, Func<C, C>) Applies the specified function to selected columns.
MapAndAppend<T>(C, Func<Vector<T>, IVector>, C) Applies the specified function to selected columns and appends the results to the end of the data frame.
MapAndAppend<T>(IList<C>, Func<Vector<T>, IVector>, IList<C>) Applies the specified function to selected columns and appends the results to the end of the data frame.
MapAndAppend<T>(IList<C>, Func<Vector<T>, IVector>, Func<C, C>) Applies the specified function to selected columns.
MapAndInsertAfter(C, Func<IVector, IVector>, C) Applies the specified function to selected columns.
MapAndInsertAfter(IList<C>, Func<IVector, IVector>, IList<C>) Applies the specified function to selected columns and inserts the result after each mapped column in the data frame.
MapAndInsertAfter(IList<C>, Func<IVector, IVector>, Func<C, C>) Applies the specified function to selected columns.
MapAndInsertAfter<T>(C, Func<Vector<T>, IVector>, C) Applies the specified function to selected columns.
MapAndInsertAfter<T>(IList<C>, Func<Vector<T>, IVector>, IList<C>) Applies the specified function to selected columns and inserts the result after each mapped column in the data frame.
MapAndInsertAfter<T>(IList<C>, Func<Vector<T>, IVector>, Func<C, C>) Applies the specified function to selected columns.
MapAndReplace(C, Func<IVector, IVector>, C) Applies the specified function to selected columns.
MapAndReplace(IList<C>, Func<IVector, IVector>, IList<C>) Applies the specified function to selected columns and replaces the columns with the mapped columns.
MapAndReplace(IList<C>, Func<IVector, IVector>, Func<C, C>) Applies the specified function to selected columns.
MapAndReplace<T>(C, Func<Vector<T>, IVector>, C) Applies the specified function to selected columns.
MapAndReplace<T>(IList<C>, Func<Vector<T>, IVector>, IList<C>) Applies the specified function to selected columns and replaces the columns with the mapped columns.
MapAndReplace<T>(IList<C>, Func<Vector<T>, IVector>, Func<C, C>) Applies the specified function to selected columns.
MemberwiseCloneCreates a shallow copy of the current Object.
(Inherited from Object)
Pivot<R1, C1, T>(C, C, C) Constructs a new data frame using the specified columns as row and column indexes.
Pivot<R1, C1, T>(C, C, C, AggregatorGroup<T>) Constructs a new data frame using the specified columns as row and column indexes and aggregates the values corresponding to each row-column pair.
PivotBy<R1, C1> Returns a two-dimensional grouping on the specified columns.
RemoveColumn Removes the specified column from the data frame.
RemoveColumnAt Removes the column at the specified position from the data frame.
RemoveColumns Removes all columns selected by a column selector from the data frame.
RemoveColumnsAt Removes the columns at the specified positions from the data frame.
RemoveColumnsWithMissingValues Returns a new data frame with any columns containing missing values removed.
RemoveRowIndex() Returns a new data frame that has a default numeric row index. The row index is discarded.
RemoveRowIndex(C) Returns a new data frame that has a default numeric row index. The row index is moved to a new column in the data frame.
RemoveRows(IEnumerable<R>) Returns a new data frame that has the specified rows removed.
RemoveRows(Vector<Boolean>) Returns a new data frame that has the specified rows removed.
RemoveRowsAt Returns a new data frame that has the specified rows removed.
RemoveRowsWithMissingValues() Returns a new data frame with any rows containing missing values removed.
RemoveRowsWithMissingValues(C[]) Returns a new data frame with any rows containing missing values removed.
RenameColumn(C, C) Renames the specified column.
RenameColumn(IEnumerable<C>, IEnumerable<C>) Renames the specified column.
RenameColumns Renames the columns that satisfy a condition using the specified key generator.
ReplaceMissingValues(Direction, Int32) Returns a new data frame whose columns have their missing values replaced with the next or previous non-missing value.
ReplaceMissingValues<T>(T) Returns a new data frame whose columns of the specified type have their missing values replaced with the specified value.
ReplaceMissingValues<T>(Vector<T>) Returns a new data frame whose columns of the specified type have their missing values replaced with the corresponding value from a row vector.
SelectRows<R1>(Index<R1>, Subset) Returns a new data frame that contains the selected rows and uses the specified row index.
SelectRows<R1>(Index<R1>, Int32[]) Returns a new data frame that contains the selected rows and uses the specified row index.
SelectRows<R1>(Index<R1>, Int32, Int32, Int32) Returns a new data frame that contains the selected rows and uses the specified row index.
SetColumnRole(ColumnSelector, ColumnRole) Assigns a role to all columns selected by a column selector.
SetColumnRole(C, ColumnRole) Assigns a role to the specified column.
SetColumnSemantics Assigns semantic metadata to the specified column.
SortBy(C) Sorts the data frame by the specified column.
SortBy(Int32) Sorts the data frame by the specified column.
SortBy(C, SortOrder) Sorts the data frame by the specified column.
SortBy(Int32, SortOrder) Sorts the data frame by the specified column.
SortByIndex() Sorts the data frame by the row index in ascending order.
SortByIndex(SortOrder) Sorts the data frame by the row index.
Stack() Returns a data frame containing all values in the data frame as row-column-value pairs.
Stack<T>(IEnumerable<C>, IEnumerable<C>, C, C) Converts a data frame from wide to long format.
Summarize() Returns a summary of the contents of the data frame using the default summary options.
Summarize(SummaryOptions) Returns a summary of the contents of the data frame using the specified options.
Tail Returns the last few rows of the data frame.
ToMatrix<T> Converts the data frame to a matrix with elements of the specified type.
ToStringReturns a string that represents the current object.
(Overrides Object.ToString())
TransformColumns(Func<IVector, IVector>) Applies the specified transformation to each column in the data frame.
TransformColumns<T, U>(Func<T, U>) Applies the specified transformation to each element of each column in the data frame.
TransformColumns<T, U>(Func<Vector<T>, Vector<U>>) Applies the specified transformation to each column in the data frame.
TransformColumns<T, U, R1>(Func<Vector<T>, Vector<U>>) Applies the specified transformation to each column in the data frame.
TryGetColumnRole Attempts to get the role assigned to the specified column.
TryGetColumnSemantics Attempts to get semantic metadata assigned to the specified column.
TryGetRow Attempts to get the row at the specified row index.
Unstack<T> Converts a data frame from long to wide format.
WithColumnIndex<C1> Returns a new data frame that relabels the columns using the specified index.
WithRowIndex<R1>(C) Returns a new data frame using the specified column as the index.
WithRowIndex<R1>(Index<R1>) Returns a new data frame that uses the specified row index.
WithRowIndex<R1, R2>(C, C) Returns a new data frame using the specified columns as a hierarchical index.
WithRowIndex<R1, R2, R3>(C, C, C) Returns a new data frame using the specified columns as a hierarchical index.

Extension Methods

Group<DataFrameRow<R, C>> Returns a grouping by the unique elements in a list.
(Defined by Grouping)
Group<DataFrameRow<R, C>> Returns a grouping by the unique elements in a sequence.
(Defined by Grouping)
Group<DataFrameRow<R, C>> Returns a grouping by the unique elements in a list using the specified comparer to determine equality.
(Defined by Grouping)
Group<DataFrameRow<R, C>> Returns a grouping by the unique elements in a sequence using the specified comparer to determine equality.
(Defined by Grouping)
StandardDeviation<DataFrameRow<R, C>> Returns the standard deviation of the elements of a sequence.
(Defined by Stats)
Sum<DataFrameRow<R, C>> Computes the sum of the sequence of values.
(Defined by ArrayMath)
Sum<DataFrameRow<R, C>, U> Computes the sum of the sequence of values that are obtained by invoking a transform function on each element of the input sequence.
(Defined by ArrayMath)
Sum<DataFrameRow<R, C>, T2, U> Computes the sum of the sequence of values that are obtained by invoking a transform function on each pair of elements of the input sequences.
(Defined by ArrayMath)

See Also