pyarrow.csv.ConvertOptions

class pyarrow.csv.ConvertOptions(check_utf8=None, *, column_types=None, null_values=None, true_values=None, false_values=None, strings_can_be_null=None, quoted_strings_can_be_null=None, include_columns=None, include_missing_columns=None, auto_dict_encode=None, auto_dict_max_cardinality=None, timestamp_parsers=None)

Bases: pyarrow.lib._Weakrefable

Options for converting CSV data.

Parameters
  • check_utf8 (bool, optional (default True)) – Whether to check UTF8 validity of string columns.

  • column_types (pa.Schema or dict, optional) – Explicitly map column names to column types. Passing this argument disables type inference on the defined columns.

  • null_values (list, optional) – A sequence of strings that denote nulls in the data (defaults are appropriate in most cases). Note that by default, string columns are not checked for null values. To enable null checking for those, specify strings_can_be_null=True.

  • true_values (list, optional) – A sequence of strings that denote true booleans in the data (defaults are appropriate in most cases).

  • false_values (list, optional) – A sequence of strings that denote false booleans in the data (defaults are appropriate in most cases).

  • timestamp_parsers (list, optional) – A sequence of strptime()-compatible format strings, tried in order when attempting to infer or convert timestamp values (the special value ISO8601() can also be given). By default, a fast built-in ISO-8601 parser is used.

  • strings_can_be_null (bool, optional (default False)) – Whether string / binary columns can have null values. If true, then strings in null_values are considered null for string columns. If false, then all strings are valid string values.

  • quoted_strings_can_be_null (bool, optional (default True)) – Whether string / binary columns can have quoted null values. If true and strings_can_be_null is true, then strings in null_values are considered null for string columns, even when quoted. Otherwise, then all quoted strings are valid string values.

  • auto_dict_encode (bool, optional (default False)) – Whether to try to automatically dict-encode string / binary data. If true, then when type inference detects a string or binary column, it it dict-encoded up to auto_dict_max_cardinality distinct values (per chunk), after which it switches to regular encoding. This setting is ignored for non-inferred columns (those in column_types).

  • auto_dict_max_cardinality (int, optional) – The maximum dictionary cardinality for auto_dict_encode. This value is per chunk.

  • include_columns (list, optional) – The names of columns to include in the Table. If empty, the Table will include all columns from the CSV file. If not empty, only these columns will be included, in this order.

  • include_missing_columns (bool, optional (default False)) – If false, columns in include_columns but not in the CSV file will error out. If true, columns in include_columns but not in the CSV file will produce a column of nulls (whose type is selected using column_types, or null by default). This option is ignored if include_columns is empty.

__init__(*args, **kwargs)

Initialize self. See help(type(self)) for accurate signature.

Methods

__init__(*args, **kwargs)

Initialize self.

equals(self, ConvertOptions other)

validate(self)

Attributes

auto_dict_encode

Whether to try to automatically dict-encode string / binary data.

auto_dict_max_cardinality

The maximum dictionary cardinality for auto_dict_encode.

check_utf8

Whether to check UTF8 validity of string columns.

column_types

Explicitly map column names to column types.

false_values

A sequence of strings that denote false booleans in the data.

include_columns

The names of columns to include in the Table.

include_missing_columns

If false, columns in include_columns but not in the CSV file will error out.

null_values

A sequence of strings that denote nulls in the data.

quoted_strings_can_be_null

Whether string / binary columns can have quoted null values.

strings_can_be_null

Whether string / binary columns can have null values.

timestamp_parsers

A sequence of strptime()-compatible format strings, tried in order when attempting to infer or convert timestamp values (the special value ISO8601() can also be given).

true_values

A sequence of strings that denote true booleans in the data.

auto_dict_encode

Whether to try to automatically dict-encode string / binary data.

auto_dict_max_cardinality

The maximum dictionary cardinality for auto_dict_encode.

This value is per chunk.

check_utf8

Whether to check UTF8 validity of string columns.

column_types

Explicitly map column names to column types.

equals(self, ConvertOptions other)
false_values

A sequence of strings that denote false booleans in the data.

include_columns

The names of columns to include in the Table.

If empty, the Table will include all columns from the CSV file. If not empty, only these columns will be included, in this order.

include_missing_columns

If false, columns in include_columns but not in the CSV file will error out. If true, columns in include_columns but not in the CSV file will produce a null column (whose type is selected using column_types, or null by default). This option is ignored if include_columns is empty.

null_values

A sequence of strings that denote nulls in the data.

quoted_strings_can_be_null

Whether string / binary columns can have quoted null values.

strings_can_be_null

Whether string / binary columns can have null values.

timestamp_parsers

A sequence of strptime()-compatible format strings, tried in order when attempting to infer or convert timestamp values (the special value ISO8601() can also be given). By default, a fast built-in ISO-8601 parser is used.

true_values

A sequence of strings that denote true booleans in the data.

validate(self)