DataFrame Class

Contains extension methods for data frames.

Definition

Namespace: Extreme.DataAnalysis
Assembly: Extreme.Numerics (in Extreme.Numerics.dll) Version: 8.1.23
C# 
public static class DataFrame
Inheritance
Object  →  DataFrame

Properties

DefaultMissingValueLabel Gets or sets the string to use to represent a missing value in a data frame or series.

Methods

Append<R, C>(DataFrame<R, C>[]) Combines data frames by appending the rows of the other data frame to the rows of this data frame.
Append<R, C>(IEnumerable<DataFrame<R, C>>, Index<C>, Boolean) Combines data frames by appending the rows of the other data frame to the rows of this data frame.
Append<R, C>(IEnumerable<DataFrame<R, C>>, JoinType, Boolean) Combines data frames by appending the rows of the other data frame to the rows of this data frame.
Apply<R, C, T> Applies the specified matrix function to two data frames and returns the result.
CreateEmpty<R, C> Constructs an empty data frame.
FromColumns<C>(IDictionary<C, Object>) Constructs a new data frame from a dictionary of columns using a default index.
FromColumns<C>(ValueTuple<C, Object>[]) Constructs a new data frame from an array of tuples of key / column pairs using a default index.
FromColumns<C>(IEnumerable<IVector>, Index<C>) Constructs a new data frame from the specified columns and column index.
FromColumns<C>(IEnumerable<IVector>, IEnumerable<C>) Creates a new data frame from the specified column labels and data.
FromColumns<R, C>(IDictionary<C, Object>) Constructs a new data frame from a dictionary of columns.
FromColumns<R, C>(IDictionary<C, Object>, Index<R>) Constructs a new data frame from a dictionary of columns using the specified row index.
FromColumns<R, C>(IDictionary<C, Object>, Index<R>, Index<C>) Constructs a new data frame from a dictionary of columns using the specified row index.
FromColumns<R, C>(IEnumerable<IVector>, Index<R>, Index<C>) Constructs a new data frame from the specified columns, row and column indexes.
FromDataTable(DataTable) Constructs a data frame from a data table.
FromDataTable(DataTable, IEnumerable<String>) Constructs a data frame from the specified columns in a data table.
FromDataTable<R>(DataTable, String) Constructs a data frame from a data table using the specified key column.
FromDataTable<R>(DataTable, String, IEnumerable<String>) Constructs a data frame from the specified columns in a data table using the specified key column.
FromMatrix<C, T>(Matrix<T>, Index<C>) Constructs a new data frame from a matrix with a default row index.
FromMatrix<R, C, T>(Matrix<T>, Index<R>, Index<C>) Constructs a new data frame from a matrix.
FromObjects<T>(IEnumerable<T>) Creates a new data frame containing the public properties of a sequence of objects.
FromObjects<T>(IEnumerable<T>, String[]) Creates a new data frame containing the specified properties of a sequence of objects.
FromObjects<T, R>(IEnumerable<T>, String) Creates a new data frame containing the public properties of a sequence of objects.
FromObjects<T, R>(IEnumerable<T>, String[]) Creates a new data frame containing the specified properties of a sequence of objects.
GetRows<R1, R2, C>(DataFrame<ValueTuple<R1, R2>, C>, R1) Returns a data frame containing the rows where the first level of the index has the specified value.
GetRows<R1, R2, R3, C>(DataFrame<ValueTuple<R1, R2, R3>, C>, R1) Returns a data frame containing the rows where the first level of the index has the specified value.
GetRows<R1, R2, R3, C>(DataFrame<ValueTuple<R1, R2, R3>, C>, R1, R2) Returns a data frame containing the rows where the first two levels of the index have the specified values.
Join<R>(DataFrame<R, String>, DataFrame<R, String>, JoinType, String, String) Returns a new data frame by joining this data frame with another data frame on the data frames' indexes.
Join<R, C>(DataFrame<R, C>, JoinType, DataFrame<R, C>, Func<C, C>, Func<C, C>) Returns a new data frame by joining two data frames on their row indexes.
Join<R1, R2>(DataFrame<R1, String>, JoinType, DataFrame<R2, String>, IList<String>, String, String) Returns a new data frame by joining this data frame with another data frame on the data frame's indexes.
Join<R1, R2>(DataFrame<R1, String>, JoinType, DataFrame<R2, 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.
Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, C, Func<C, C>, Func<C, 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.
Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, Boolean, C, C) Returns a new data frame by joining two data frames on the specified columns in each data frame.
Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, IList<C>, Func<C, C>, Func<C, 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.
JoinOnNearest<R, C> Returns a new data frame by joining a data frames on the nearest keys in their row indexes.
JoinOnSharedColumns<R1, R2, C> Returns a new data frame by joining two data frames on their shared columns.
ReadCsv(StreamReader, Boolean, Int32, CultureInfo, Boolean, Int32) Reads a data frame from a CSV file.
Obsolete.
ReadCsv(String, Boolean, Int32, CultureInfo, Boolean, Int32) Reads a data frame from a CSV file.
Obsolete.
ReadCsv<R>(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.
Obsolete.
ReadCsv<R>(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.
Obsolete.
ReadDelimited Reads a data frame from a delimited text file.
Obsolete.
Resample<C>(DataFrame<DateTime, C>, Recurrence, IDictionary<C, AggregatorGroup>, Direction) Resamples the rows of the data frame according to the specified recurrence.
Resample<C>(DataFrame<DateTime, C>, Recurrence, IList<AggregatorGroup>, Direction) Resamples the rows of the data frame according to the specified recurrence.
Resample<C, C1>(DataFrame<DateTime, C>, Recurrence, IEnumerable<ValueTuple<C, AggregatorGroup>>, Index<C1>, Direction) Resamples the rows of the data frame according to the specified recurrence.
Stack<R>(DataFrame<R, String>, IEnumerable<String>, IEnumerable<String>, String, String) Returns a data frame containing all values in the data frame as row-column-value pairs.
Stack<R, C>(DataFrame<R, C>, Boolean) Transforms a data frame so that the column index is nested into the row index.
Stack<R, C1, C2>(DataFrame<R, ValueTuple<C1, C2>>, Boolean) Transforms a data frame so that the second level of a two-level column index is nested into the row index.
Stack<R1, R2, C>(DataFrame<ValueTuple<R1, R2>, C>, Boolean) Transforms a data frame so that the column index is nested into the row index.
Unstack<R, C>(IVector) Transforms a vector with a two-level index into a data frame whose columns correspond to the second level in the index.
Unstack<R1, R2, C>(DataFrame<ValueTuple<R1, 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.
Unstack<R1, R2, R3, C>(DataFrame<ValueTuple<R1, 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.
WriteCsv<R, C> Writes a data frame to a CSV file.
Obsolete.

See Also