 | FrameReadCsv Method |
Overload List| Name | Description | |
|---|---|---|
  | ReadCsv(Stream, NullableBoolean, NullableBoolean, NullableInt32, String, String, String, NullableInt32, 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 (`int`, `float`, etc.) are converted to the right type. Columns of other
types (such as dates) are not converted automatically.
## Parameters
* `stream` - Specifies the input stream, opened at the beginning of CSV data
* `hasHeaders` - Specifies whether the input CSV file has header row
(when not set, the default value is `true`)
* `inferTypes` - Specifies whether the method should attempt to infer types
of columns automatically (set this to `false` if you want to specify schema)
* `inferRows` - If `inferTypes=true`, this parameter specifies the number of
rows to use for type inference. The default value is 100.
* `schema` - A string that specifies CSV schema. See the documentation for
information about the schema format.
* `separators` - A string that specifies one or more (single character) separators
that are used to separate columns in the CSV file. Use for example `";"` to
parse semicolon separated files.
* `culture` - Specifies the name of the culture that is used when parsing
values in the CSV file (such as `"en-US"`). The default is invariant culture.
* `maxRows` - The maximal number of rows that should be read from the CSV file.
* `missingValues` - An array of strings that contains values which should be treated
as missing when reading the file. The default value is: "NaN"; "NA"; "#N/A"; ":"; "-"; "TBA"; "TBD".
[category:Input and output]
|
| ReadCsv(String, NullableBoolean, NullableBoolean, NullableInt32, String, String, String, NullableInt32, 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 (`int`, `float`, etc.) are converted to the right type. Columns of other
types (such as dates) are not converted automatically.
## Parameters
* `location` - Specifies a file name or an web location of the resource.
* `hasHeaders` - Specifies whether the input CSV file has header row
(when not set, the default value is `true`)
* `inferTypes` - Specifies whether the method should attempt to infer types
of columns automatically (set this to `false` if you want to specify schema)
* `inferRows` - If `inferTypes=true`, this parameter specifies the number of
rows to use for type inference. The default value is 100.
* `schema` - A string that specifies CSV schema. See the documentation for
information about the schema format.
* `separators` - A string that specifies one or more (single character) separators
that are used to separate columns in the CSV file. Use for example `";"` to
parse semicolon separated files.
* `culture` - Specifies the name of the culture that is used when parsing
values in the CSV file (such as `"en-US"`). The default is invariant culture.
* `maxRows` - Specifies the maximum number of rows that will be read from the CSV file
[category:Input and output]
|
See Also