DataFrame.LoadCsvFromString Method

Definition

Namespace:

Microsoft.Data.Analysis

Assembly:

Microsoft.Data.Analysis.dll

Package:

Microsoft.Data.Analysis v0.22.0-preview.24522.7

Overloads

LoadCsvFromString(String, Char, Boolean, String[], Type[], Int64, Int32, Boolean, Boolean, CultureInfo, Func<IEnumerable<String>,Type>)

Reads CSV data passed in as a string into a DataFrame.

LoadCsvFromString(String, Char, Boolean, String[], Type[], Int64, Int32, Boolean, Boolean, CultureInfo, Func<IEnumerable<String>,Type>)

Source:

DataFrame.IO.cs

Reads CSV data passed in as a string into a DataFrame.

public static Microsoft.Data.Analysis.DataFrame LoadCsvFromString(string csvString, char separator = ',', bool header = true, string[] columnNames = default, Type[] dataTypes = default, long numberOfRowsToRead = -1, int guessRows = 10, bool addIndexColumn = false, bool renameDuplicatedColumns = false, System.Globalization.CultureInfo cultureInfo = default, Func<System.Collections.Generic.IEnumerable<string>,Type> guessTypeFunction = default);

static member LoadCsvFromString : string * char * bool * string[] * Type[] * int64 * int * bool * bool * System.Globalization.CultureInfo * Func<seq<string>, Type> -> Microsoft.Data.Analysis.DataFrame

Public Shared Function LoadCsvFromString (csvString As String, Optional separator As Char = ',', Optional header As Boolean = true, Optional columnNames As String() = Nothing, Optional dataTypes As Type() = Nothing, Optional numberOfRowsToRead As Long = -1, Optional guessRows As Integer = 10, Optional addIndexColumn As Boolean = false, Optional renameDuplicatedColumns As Boolean = false, Optional cultureInfo As CultureInfo = Nothing, Optional guessTypeFunction As Func(Of IEnumerable(Of String), Type) = Nothing) As DataFrame

Parameters

csvString

String

csv data passed in as a string

separator

Char

column separator

header

Boolean

has a header or not

columnNames

String[]

column names (can be empty)

dataTypes

Type[]

column types (can be empty)

numberOfRowsToRead

Int64

number of rows to read not including the header(if present)

guessRows

Int32

number of rows used to guess types

addIndexColumn

Boolean

add one column with the row index

renameDuplicatedColumns

Boolean

If set to true, columns with repeated names are auto-renamed.

cultureInfo

CultureInfo

culture info for formatting values

guessTypeFunction

Func<IEnumerable<String>,Type>

function used to guess the type of a column based on its values

Returns

DataFrame

DataFrame