Click or drag to resize

FrameTable Class

Represents a modify-able array of data.
Inheritance Hierarchy

Namespace:  Meta.Numerics.Data
Assembly:  Meta.Numerics (in Meta.Numerics.dll) Version: 4.0.7.0 (4.0.7.0)
Syntax
public sealed class FrameTable : FrameView

The FrameTable type exposes the following members.

Constructors
  NameDescription
Public methodFrameTable
Initializes a new, empty frame table.
Top
Properties
Methods
  NameDescription
Public methodAddColumnT(String)
Adds a new column with the given name and type.
Public methodAddColumnT(String, ListT)
Adds a new column with the given name and stored values.
Public methodAddColumnsT
Adds new columns with the given names.
Public methodAddComputedColumnT
Add a computed column.
(Inherited from FrameView.)
Public methodAddRow(IReadOnlyDictionaryString, Object)
Adds a new row of data to the data frame.
Public methodAddRow(Object)
Add a new row of data to the data frame.
Public methodAddRowT(IReadOnlyListT)
Adds a new row of data to the frame.
Public methodAsColumnsT
Exposes a list of columns of uniform type.
(Inherited from FrameView.)
Public methodClear
Removes all data from the table.
Public methodDiscard
Constructs a new view that does not contain the given columns.
(Inherited from FrameView.)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodStatic memberFromCsv
Creates a new frame table from a file of comma-separated values.
Public methodStatic memberFromDictionaries
Constructs a new frame table from a sequence of dictionaries.
Public methodGetColumnIndex
Gets the index of a given column.
(Inherited from FrameView.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodGroupBy(String, FuncFrameView, IReadOnlyDictionaryString, Object)
Groups the data by the values in the given column, and computes aggregate quantities for each group.
(Inherited from FrameView.)
Public methodGroupByT(String, FuncFrameView, T, String)
Groups the data by the values in the given column, and computes the given aggregate quantity for each group.
(Inherited from FrameView.)
Public methodOrderBy(String)
Sorts the rows by the values in the given column.
(Inherited from FrameView.)
Public methodOrderBy(ComparisonFrameRow)
Sorts all rows by the given function.
(Inherited from FrameView.)
Public methodOrderBy(String, SortOrder)
Sort the rows by the values in the given column in the given direction.
(Inherited from FrameView.)
Public methodOrderByT(String, ComparisonT)
Sorts all rows by the given function of the given column.
(Inherited from FrameView.)
Public methodRemoveColumn
Removes the column with the given index from the data frame.
Public methodSelect(ICollectionString)
Constructs a new view, containing only the given columns.
(Inherited from FrameView.)
Public methodSelect(String)
Constructs a new view, containing only the given columns.
(Inherited from FrameView.)
Public methodToCsv
Write the data in the view to a comma-separated-value file.
(Inherited from FrameView.)
Public methodToDictionaries
Writes the data in the view as a sequence of dictionaries.
(Inherited from FrameView.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodWhere(FuncFrameRow, Boolean)
Selects rows matching the given criteria.
(Inherited from FrameView.)
Public methodWhereT(String, FuncT, Boolean)
Selects rows in which the value of the given column matches the given criteria.
(Inherited from FrameView.)
Public methodWhereNotNull
Removes any rows that have null values in the named columns.
(Inherited from FrameView.)
Top
Remarks

This is the central class for storing data in our data frame system.

Use the FromCsv(TextReader) method to create a frame table from a comma-separated values file or the FromDictionaries(IEnumerableIReadOnlyDictionaryString, Object) method to create a frame table from JSON or another collection-of-dictionaries representation. Or create one programmatically by using the FrameTable constructor to instantiate an empty data frame and AddColumn and AddRow to add columns and rows.

Using the methods inherited from the FrameView class, you can filter, re-order, manipulate, and analyze data without incurring the space or time costs of copying the stored data.

See Also