The following options are supported.
Option name |
Type |
Default |
Description |
Constraints |
|---|---|---|---|---|
datastore precision |
string |
\(s=\) double |
The precision used when reading floating point numbers using autodetection. |
\(s=\) double, or single. |
datatype |
string |
\(s=\) auto |
If a CSV file is known to be of a single datatype, set this option to disable autodetection and make reading the file quicker. |
\(s=\) auto, boolean, double, float, integer, or string. |
use header row |
integer |
\(i=0\) |
Whether or not to interpret the first row as a header. |
\(0 \le i \le 1\) |
skip empty lines |
integer |
\(i=0\) |
Whether or not to ignore empty lines in CSV files (note that caution should be used when using this in conjunction with options such as CSV skip rows since line numbers may no longer correspond to the original line numbers in the CSV file). |
\(0 \le i \le 1\) |
delimiter |
string |
\(s=\) , |
The delimiter used when reading CSV files. |
|
warn for missing data |
integer |
\(i=0\) |
If set to 0, return error if missing data is encountered; if set to 1, issue a warning and store missing data as either a NaN (for floating point data) or the maximum value of the integer type being used. |
\(0 \le i \le 1\) |
thousands |
string |
empty |
The character used to separate thousands when reading numeric values in CSV files. |
|
quote character |
string |
\(s=\) “ |
The character used to denote quotations in CSV files. |
|
decimal |
string |
\(s=\) . |
The character used to denote a decimal point in CSV files. |
|
scientific notation character |
string |
\(s=\) e |
The character used to denote powers of 10 in floating point values in CSV files. |
|
skip footer |
integer |
\(i=0\) |
Whether or not to ignore the last line when reading a CSV file. |
\(0 \le i \le 1\) |
skip rows |
string |
empty |
A comma- or space-separated list of rows to ignore in CSV files. |
|
comment |
string |
\(s=\) # |
The character used to denote comments in CSV files (note, if a line in a CSV file is to be interpreted as only containing a comment, the comment character should be the first character on the line). |
|
whitespace delimiter |
integer |
\(i=0\) |
Whether or not to use whitespace as the delimiter when reading CSV files. |
\(0 \le i \le 1\) |
escape character |
string |
\(s=\) \ |
The escape character in CSV files. |
|
line terminator |
string |
empty |
The character used to denote line termination in CSV files (leave this empty to use the default). |
|
integers as floats |
integer |
\(i=0\) |
Whether or not to interpret integers as floating point numbers when using autodetection. |
\(0 \le i \le 1\) |
row start |
integer |
\(i=0\) |
Ignore the specified number of lines from the top of the file (note that line numbers in CSV files start at 1). |
\(0 \le i\) |
storage order |
string |
\(s=\) column-major |
Whether to return data in row- or column-major format. |
\(s=\) column-major, or row-major. |
skip initial space |
integer |
\(i=0\) |
Whether or not to ignore initial spaces in CSV file lines. |
\(0 \le i \le 1\) |
double quote |
integer |
\(i=0\) |
Whether or not to interpret two consecutive quotechar characters within a field as a single quotechar character. |
\(0 \le i \le 1\) |