Frame
Namespace: Deedle
Provides static methods for creating frames, reading frame data from CSV files and database (via IDataReader). The type also provides global configuration for reflection-based expansion.
Table of contents
Configuration
Static members
Input and output
Static members
Static member | Description |
Frame.ReadCsv(...)
Signature: (stream:Stream * hasHeaders:Nullable<bool> * inferTypes:Nullable<bool> * inferRows:Nullable<int> * schema:string * separators:string * culture:string * maxRows:Nullable<int> * missingValues:string [] * preferOptions:Nullable<bool>) -> Frame<int,string>
|
Load data frame from a CSV file. The operation automatically reads column names from the
CSV file (if they are present) and infers the type of values for each column. Columns
of primitive types ( Parameters
|
Frame.ReadCsv(...)
Signature: (location:string * hasHeaders:Nullable<bool> * inferTypes:Nullable<bool> * inferRows:Nullable<int> * schema:string * separators:string * culture:string * maxRows:Nullable<int> * missingValues:string [] * preferOptions:bool) -> Frame<int,string>
|
Load data frame from a CSV file. The operation automatically reads column names from the
CSV file (if they are present) and infers the type of values for each column. Columns
of primitive types ( Parameters
|
Frame.ReadReader(reader)
Signature: reader:IDataReader -> Frame<int,string>
|
Read data from |
Other type members
Static members
Static member | Description |
Frame.CreateEmpty()
Signature: unit -> Frame<'R,'C>
Type parameters: 'R, 'C Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromArray2D(array)
Signature: (array:'T [,]) -> Frame<int,int>
Type parameters: 'T Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
Create data frame from a 2D array of values. The first dimension of the array is used as rows and the second dimension is treated as columns. Rows and columns of the returned frame are indexed with the element's offset in the array. Parameters
|
Frame.FromColumns(cols)
Signature: cols:Series<'TColKey,Series<'TRowKey,'V>> -> Frame<'TRowKey,'TColKey>
Type parameters: 'TColKey, 'TRowKey, 'V Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromColumns(cols)
Signature: cols:Series<'TColKey,ObjectSeries<'TRowKey>> -> Frame<'TRowKey,'TColKey>
Type parameters: 'TColKey, 'TRowKey Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromColumns(columns)
Signature: columns:seq<KeyValuePair<'ColKey,ObjectSeries<'RowKey>>> -> Frame<'RowKey,'ColKey>
Type parameters: 'ColKey, 'RowKey Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromColumns(columns)
Signature: columns:seq<KeyValuePair<'ColKey,Series<'RowKey,'V>>> -> Frame<'RowKey,'ColKey>
Type parameters: 'ColKey, 'RowKey, 'V Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromColumns(cols)
Signature: cols:seq<Series<'ColKey,'V>> -> Frame<'ColKey,int>
Type parameters: 'ColKey, 'V Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromRecords(values)
Signature: values:seq<'T> -> Frame<int,string>
Type parameters: 'T Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
Creates a data frame from a sequence of any .NET objects. The method uses reflection
over the specified type parameter ExampleThe method can be nicely used to create a data frame using C# anonymous types (the result is a data frame with columns "A" and "B" containing two rows). [lang=csharp] var df = Frame.FromRecords(new[] { new { A = 1, B = "Test" }, new { A = 2, B = "Another"} }); |
Frame.FromRecords(series)
Signature: series:Series<'K,'R> -> Frame<'K,string>
Type parameters: 'K, 'R Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
Creates a data frame from a sequence of any .NET objects. The method uses reflection
over the specified type parameter |
Frame.FromRowKeys(keys)
Signature: keys:seq<'K> -> Frame<'K,string>
Type parameters: 'K Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromRows(rows)
Signature: rows:Series<'TColKey,Series<'TRowKey,'V>> -> Frame<'TColKey,'TRowKey>
Type parameters: 'TColKey, 'TRowKey, 'V Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromRows(rows)
Signature: rows:Series<'TColKey,ObjectSeries<'TRowKey>> -> Frame<'TColKey,'TRowKey>
Type parameters: 'TColKey, 'TRowKey Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromRows(rows)
Signature: rows:seq<KeyValuePair<'RowKey,ObjectSeries<'ColKey>>> -> Frame<'RowKey,'ColKey>
Type parameters: 'RowKey, 'ColKey Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromRows(rows)
Signature: rows:seq<KeyValuePair<'RowKey,Series<'ColKey,'V>>> -> Frame<'RowKey,'ColKey>
Type parameters: 'RowKey, 'ColKey, 'V Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromRows(rows)
Signature: rows:seq<Series<'ColKey,'V>> -> Frame<int,'ColKey>
Type parameters: 'ColKey, 'V Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
|
Frame.FromValues(values)
Signature: (values:seq<'?686407 * '?686408 * '?686409>) -> Frame<'?686407,'?686408>
Type parameters: '?686407, '?686408, '?686409 Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
Create a data frame from a sequence of tuples containing row key, column key and a value |
Frame.FromValues(...)
Signature: (values:seq<'T> * colSel:Func<'T,'C> * rowSel:Func<'T,'R> * valSel:Func<'T,'V>) -> Frame<'R,'C>
Type parameters: 'T, 'C, 'R, 'V Attributes: [<CompilerMessage("This method is not intended for use from F#.", 10001, IsHidden = true, IsError = false)>] |
Create a data frame from a sequence of objects and functions that return row key, column key and value for each object in the input sequence. Parameters
|