FrameTable Class

Represents a modify-able array of data.

Inheritance Hierarchy

SystemObject
Meta.Numerics.DataFrameView
Meta.Numerics.DataFrameTable

Namespace: Meta.Numerics.Data
Assembly: Meta.Numerics (in Meta.Numerics.dll) Version: 4.1.4

Syntax

C++

Copy

public sealed class FrameTable : FrameView

Public NotInheritable Class FrameTable
	Inherits FrameView

public ref class FrameTable sealed : public FrameView

[<SealedAttribute>]
type FrameTable =  
    class
        inherit FrameView
    end

The FrameTable type exposes the following members.

Constructors

	Name	Description
	FrameTable	Initializes a new, empty frame table.

Top

Properties

	Name	Description
	Columns	Gets the columns of the table. (Inherited from FrameView.)
	ItemString	Get the column with the given name. (Inherited from FrameView.)
	ItemInt32, Int32	Gets or sets the value in a given cell.
	Rows	Gets the rows of the table. (Inherited from FrameView.)

Top

Methods

	Name	Description
	AddColumnT(String)	Adds a new column with the given name and type.
	AddColumnT(String, ListT)	Adds a new column with the given name and stored values.
	AddColumnsT	Adds new columns with the given names.
	AddComputedColumnT	Add a computed column. (Inherited from FrameView.)
	AddRow(IReadOnlyDictionaryString, Object)	Adds a new row of data to the data frame.
	AddRow(Object)	Add a new row of data to the data frame.
	AddRowT(IReadOnlyListT)	Adds a new row of data to the frame.
	AsColumnsT	Exposes a list of columns of uniform type. (Inherited from FrameView.)
	Clear	Removes all data from the table.
	Discard	Constructs a new view that does not contain the given columns. (Inherited from FrameView.)
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	FromCsv	Creates a new frame table from a file of comma-separated values.
	FromDictionaries	Constructs a new frame table from a sequence of dictionaries.
	GetColumnIndex	Gets the index of a given column. (Inherited from FrameView.)
	GetHashCode	Serves as the default hash function. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	GroupBy(String, FuncFrameView, IReadOnlyDictionaryString, Object)	Groups the data by the values in the given column, and computes aggregate quantities for each group. (Inherited from FrameView.)
	GroupByT(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.)
	OrderBy(String)	Sorts the rows by the values in the given column. (Inherited from FrameView.)
	OrderBy(ComparisonFrameRow)	Sorts all rows by the given function. (Inherited from FrameView.)
	OrderBy(String, SortOrder)	Sort the rows by the values in the given column in the given direction. (Inherited from FrameView.)
	OrderByT(String, ComparisonT)	Sorts all rows by the given function of the given column. (Inherited from FrameView.)
	RemoveColumn	Removes the column with the given index from the data frame.
	Select(ICollectionString)	Constructs a new view, containing only the given columns. (Inherited from FrameView.)
	Select(String)	Constructs a new view, containing only the given columns. (Inherited from FrameView.)
	ToCsv	Write the data in the view to a comma-separated-value file. (Inherited from FrameView.)
	ToDictionaries	Writes the data in the view as a sequence of dictionaries. (Inherited from FrameView.)
	ToString	Returns a string that represents the current object. (Inherited from Object.)
	Where(FuncFrameRow, Boolean)	Selects rows matching the given criteria. (Inherited from FrameView.)
	WhereT(String, FuncT, Boolean)	Selects rows in which the value of the given column matches the given criteria. (Inherited from FrameView.)
	WhereNotNull	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.

Reference

Meta.Numerics.Data Namespace