DataFrame.ReadCsv Method

Definition

Namespace: Extreme.DataAnalysis
Assembly: Extreme.Numerics (in Extreme.Numerics.dll) Version: 8.1.23

Overload List

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.

ReadCsv(StreamReader, Boolean, Int32, CultureInfo, Boolean, Int32)

Note: This API is now obsolete.

Reads a data frame from a CSV file.

[ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")]
public static DataFrame<long, string> ReadCsv(
	StreamReader reader,
	bool hasHeaders = true,
	int skipLines = 0,
	CultureInfo culture = null,
	bool decimalAsDouble = true,
	int inferenceRows = 2147483647
)

Visual Basic

<ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")>
Public Shared Function ReadCsv ( 
	reader As StreamReader,
	Optional hasHeaders As Boolean = true,
	Optional skipLines As Integer = 0,
	Optional culture As CultureInfo = Nothing,
	Optional decimalAsDouble As Boolean = true,
	Optional inferenceRows As Integer = 2147483647
) As DataFrame(Of Long, String)

C++/CLI

public:
[ObsoleteAttribute(L"Use the classes in the Extreme.Data package instead.")]
static DataFrame<long long, String^>^ ReadCsv(
	StreamReader^ reader, 
	bool hasHeaders = true, 
	int skipLines = 0, 
	CultureInfo^ culture = nullptr, 
	bool decimalAsDouble = true, 
	int inferenceRows = 2147483647
)

[<ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")>]
static member ReadCsv : 
        reader : StreamReader * 
        ?hasHeaders : bool * 
        ?skipLines : int * 
        ?culture : CultureInfo * 
        ?decimalAsDouble : bool * 
        ?inferenceRows : int 
(* Defaults:
        let _hasHeaders = defaultArg hasHeaders true
        let _skipLines = defaultArg skipLines 0
        let _culture = defaultArg culture null
        let _decimalAsDouble = defaultArg decimalAsDouble true
        let _inferenceRows = defaultArg inferenceRows 2147483647
*)
-> DataFrame<int64, string>

Parameters

reader StreamReader: A stream reader for the file.
hasHeaders Boolean (Optional): Specifies whether the first record contains column headers. The default is true.
skipLines Int32 (Optional): The number of lines to skip at the beginning of the file. The default is 0.
culture CultureInfo (Optional): The culture to use for parsing numbers and dates.
decimalAsDouble Boolean (Optional): Specifies whether columns containing numbers with decimals should be returned as Double instead of Decimal.
inferenceRows Int32 (Optional): The number of records to use to infer the data types of the columns. The default is 10.

Return Value

DataFrame<Int64, String>
A data frame that contains the data in the CSV file.

Exceptions

IOException	The file could not be found.
FormatException	The file is not in the proper format.

ReadCsv(String, Boolean, Int32, CultureInfo, Boolean, Int32)

Note: This API is now obsolete.

Reads a data frame from a CSV file.

[ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")]
public static DataFrame<long, string> ReadCsv(
	string path,
	bool hasHeaders = true,
	int skipLines = 0,
	CultureInfo culture = null,
	bool decimalAsDouble = true,
	int inferenceRows = 2147483647
)

Visual Basic

<ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")>
Public Shared Function ReadCsv ( 
	path As String,
	Optional hasHeaders As Boolean = true,
	Optional skipLines As Integer = 0,
	Optional culture As CultureInfo = Nothing,
	Optional decimalAsDouble As Boolean = true,
	Optional inferenceRows As Integer = 2147483647
) As DataFrame(Of Long, String)

C++/CLI

public:
[ObsoleteAttribute(L"Use the classes in the Extreme.Data package instead.")]
static DataFrame<long long, String^>^ ReadCsv(
	String^ path, 
	bool hasHeaders = true, 
	int skipLines = 0, 
	CultureInfo^ culture = nullptr, 
	bool decimalAsDouble = true, 
	int inferenceRows = 2147483647
)

[<ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")>]
static member ReadCsv : 
        path : string * 
        ?hasHeaders : bool * 
        ?skipLines : int * 
        ?culture : CultureInfo * 
        ?decimalAsDouble : bool * 
        ?inferenceRows : int 
(* Defaults:
        let _hasHeaders = defaultArg hasHeaders true
        let _skipLines = defaultArg skipLines 0
        let _culture = defaultArg culture null
        let _decimalAsDouble = defaultArg decimalAsDouble true
        let _inferenceRows = defaultArg inferenceRows 2147483647
*)
-> DataFrame<int64, string>

Parameters

path String: The path to the file.
hasHeaders Boolean (Optional): Specifies whether the first record contains column headers. The default is true.
skipLines Int32 (Optional): The number of lines to skip at the beginning of the file. The default is 0.
culture CultureInfo (Optional): The culture to use for parsing numbers and dates.
decimalAsDouble Boolean (Optional): Specifies whether columns containing numbers with decimals should be returned as Double instead of Decimal.
inferenceRows Int32 (Optional): The number of records to use to infer the data types of the columns. The default is 10.

Return Value

DataFrame<Int64, String>
A data frame that contains the data in the CSV file.

Exceptions

IOException	The file could not be found.
FormatException	The file is not in the proper format.

ReadCsv<R>(StreamReader, String, Boolean, Boolean, Int32, CultureInfo, Boolean, Int32)

Note: This API is now obsolete.

Reads a data frame from a CSV file and uses the specified column as the row index.

[ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")]
public static DataFrame<R, string> ReadCsv<R>(
	StreamReader reader,
	string keyColumn,
	bool dropKeyColumn = true,
	bool hasHeaders = true,
	int skipLines = 0,
	CultureInfo culture = null,
	bool decimalAsDouble = true,
	int inferenceRows = 10
)

Visual Basic

<ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")>
Public Shared Function ReadCsv(Of R) ( 
	reader As StreamReader,
	keyColumn As String,
	Optional dropKeyColumn As Boolean = true,
	Optional hasHeaders As Boolean = true,
	Optional skipLines As Integer = 0,
	Optional culture As CultureInfo = Nothing,
	Optional decimalAsDouble As Boolean = true,
	Optional inferenceRows As Integer = 10
) As DataFrame(Of R, String)

C++/CLI

public:
[ObsoleteAttribute(L"Use the classes in the Extreme.Data package instead.")]
generic<typename R>
static DataFrame<R, String^>^ ReadCsv(
	StreamReader^ reader, 
	String^ keyColumn, 
	bool dropKeyColumn = true, 
	bool hasHeaders = true, 
	int skipLines = 0, 
	CultureInfo^ culture = nullptr, 
	bool decimalAsDouble = true, 
	int inferenceRows = 10
)

[<ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")>]
static member ReadCsv : 
        reader : StreamReader * 
        keyColumn : string * 
        ?dropKeyColumn : bool * 
        ?hasHeaders : bool * 
        ?skipLines : int * 
        ?culture : CultureInfo * 
        ?decimalAsDouble : bool * 
        ?inferenceRows : int 
(* Defaults:
        let _dropKeyColumn = defaultArg dropKeyColumn true
        let _hasHeaders = defaultArg hasHeaders true
        let _skipLines = defaultArg skipLines 0
        let _culture = defaultArg culture null
        let _decimalAsDouble = defaultArg decimalAsDouble true
        let _inferenceRows = defaultArg inferenceRows 10
*)
-> DataFrame<'R, string>

Parameters

reader StreamReader: A stream reader for the file.
keyColumn String: The name of the column that contains the column keys.
dropKeyColumn Boolean (Optional): If true, the key column is not included in the returned data frame.
hasHeaders Boolean (Optional): Specifies whether the first record contains column headers. The default is true.
skipLines Int32 (Optional): The number of lines to skip at the beginning of the file. The default is 0.
culture CultureInfo (Optional): The culture to use for parsing numbers and dates.
decimalAsDouble Boolean (Optional): Specifies whether columns with decimal values should be returned as Double or Decimal.
inferenceRows Int32 (Optional): The number of records to use to infer the data types of the columns. The default is 10.

Type Parameters

R: The type of the row keys.

Return Value

DataFrame<R, String>
A data frame that contains the data in the CSV file.

Exceptions

KeyNotFoundException	A column named keyColumn was not found in the file.
IOException	The file could not be found.
FormatException	The file is not in the proper format.

ReadCsv<R>(String, String, Boolean, Boolean, Int32, CultureInfo, Boolean, Int32)

Note: This API is now obsolete.

Reads a data frame from a CSV file and uses the specified column as the row index.

[ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")]
public static DataFrame<R, string> ReadCsv<R>(
	string path,
	string keyColumn,
	bool dropKeyColumn = true,
	bool hasHeaders = true,
	int skipLines = 0,
	CultureInfo culture = null,
	bool decimalAsDouble = true,
	int inferenceRows = 10
)

Visual Basic

<ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")>
Public Shared Function ReadCsv(Of R) ( 
	path As String,
	keyColumn As String,
	Optional dropKeyColumn As Boolean = true,
	Optional hasHeaders As Boolean = true,
	Optional skipLines As Integer = 0,
	Optional culture As CultureInfo = Nothing,
	Optional decimalAsDouble As Boolean = true,
	Optional inferenceRows As Integer = 10
) As DataFrame(Of R, String)

C++/CLI

public:
[ObsoleteAttribute(L"Use the classes in the Extreme.Data package instead.")]
generic<typename R>
static DataFrame<R, String^>^ ReadCsv(
	String^ path, 
	String^ keyColumn, 
	bool dropKeyColumn = true, 
	bool hasHeaders = true, 
	int skipLines = 0, 
	CultureInfo^ culture = nullptr, 
	bool decimalAsDouble = true, 
	int inferenceRows = 10
)

[<ObsoleteAttribute("Use the classes in the Extreme.Data package instead.")>]
static member ReadCsv : 
        path : string * 
        keyColumn : string * 
        ?dropKeyColumn : bool * 
        ?hasHeaders : bool * 
        ?skipLines : int * 
        ?culture : CultureInfo * 
        ?decimalAsDouble : bool * 
        ?inferenceRows : int 
(* Defaults:
        let _dropKeyColumn = defaultArg dropKeyColumn true
        let _hasHeaders = defaultArg hasHeaders true
        let _skipLines = defaultArg skipLines 0
        let _culture = defaultArg culture null
        let _decimalAsDouble = defaultArg decimalAsDouble true
        let _inferenceRows = defaultArg inferenceRows 10
*)
-> DataFrame<'R, string>

Parameters

path String: The path to the file.
keyColumn String: The name of the column that contains the column keys.
dropKeyColumn Boolean (Optional): If true, the key column is not included in the returned data frame.
hasHeaders Boolean (Optional): Specifies whether the first record contains column headers. The default is true.
skipLines Int32 (Optional): The number of lines to skip at the beginning of the file. The default is 0.
culture CultureInfo (Optional): The culture to use for parsing numbers and dates.
decimalAsDouble Boolean (Optional): Specifies whether columns with decimal values should be returned as Double or Decimal.
inferenceRows Int32 (Optional): The number of records to use to infer the data types of the columns. The default is 10.

Type Parameters

R: The type of the row keys.

Return Value

DataFrame<R, String>
A data frame that contains the data in the CSV file.

Exceptions

KeyNotFoundException	A column named keyColumn was not found in the file.
IOException	The file could not be found.
FormatException	The file is not in the proper format.

DataFrame.ReadCsv Method

Definition

Overload List

ReadCsv(StreamReader, Boolean, Int32, CultureInfo, Boolean, Int32)

Parameters

Return Value

Exceptions

ReadCsv(String, Boolean, Int32, CultureInfo, Boolean, Int32)

Parameters

Return Value

Exceptions

ReadCsv<R>(StreamReader, String, Boolean, Boolean, Int32, CultureInfo, Boolean, Int32)

Parameters

Type Parameters

Return Value

Exceptions

ReadCsv<R>(String, String, Boolean, Boolean, Int32, CultureInfo, Boolean, Int32)

Parameters

Type Parameters

Return Value

Exceptions

See Also

Reference