Skip to main content

READ_CSV (inference)

Deprecated version

This document refers to a deprecated version of the RQL programming language.

Please go here for documentation related to the latest supported version.

Reads CSV data from a location.

Syntax
READ_CSV(location,
encoding := null,
has_header := null,
delimiters := [","],
nulls := [],
nans := [],
skip := 0,
escape := "\\",
quotes := ["\""],
quote := null,
sample_size := 10000,
cache := <default interval>,
retries := <default int>,
retry_interval := <default interval>,
http_method := "get",
http_body := null,
http_body_string := null,
http_headers := [],
http_args := [],
http_auth_cred_name := null,
http_token := null,
http_token_url := null,
http_client_id := null,
http_client_secret := null,
http_renew_token_use_basic_auth := false,
http_username := null,
http_password := null)

  • The optional argument encoding specifies the encoding of the data; if the encoding is set to null, it will be determined automatically; otherwise, refer to :ref:encodings <encodings>.
  • The optional argument has_header specifies whether the data has a header or not, e.g. true or false; if the field is not specified, the inference will try to detect the presence of a header.
  • The optional argument skip specifies the number of lines to skip in the data; if the field is not specified it will default to 0 (read and infer from the start of the file).
  • The optional argument delimiters specifies a candidate list of delimiters, e.g. [",", "|"]; if the field is not specified, the inference will try to detect the delimiter.
  • The optional argument nulls specifies a candidate list of strings to interpret as null, e.g. ["NA"]; if the field is not specified, the inference will not detect nulls.
  • The optional argument nans specifies a candidate list of strings to interpret as NaN, e.g. ["nan"]; if the field is not specified, the inference will not detect NaNs.
  • The optional argument quotes specifies a candidate list of quote characters to interpret as quotes, e.g. ["\""]; if the field is not specified, the inference will try to detect the quote char, if the value is set to null then no quote char will be used.
  • The optional argument quote is an alternative to quotes for a single candidate;
  • The optional argument escape specifies a escape character while parsing the CSV file, e.g. "\\"; the default value is \, if the value is set to null or empty string then no escape char will be used.
  • The optional arguments starting with http, like http_method, define specific http request options; refer to :ref:HTTP Optional Arguments <http_optional_args>.