files.read_csv

Read data from CSV

Properties

Name Type Description Required
file string Filename. Can contain a regexp or glob expression
yes
encoding string Encoding to use for reading the file
Default: "utf-8"
no
fields
(List of columns to use)
string[] List of columns to use for extract
Minimal Length: 1
no
skip number Number of lines to skip
Default: 0
Minimum: 0
no
delimiter string Delimiter to use for splitting the csv records
Default: ","
Minimal Length: 1
Maximal Length: 1
no
batch_size number Number of records to read per batch
Default: 1000
Minimum: 1
no
quotechar string A one-character string used to quote fields containing special characters, such as the delimiter or quotechar, or which contain new-line characters. It defaults to ‘
Default: "\""
Minimal Length: 1
Maximal Length: 1
no

Additional Properties: not allowed
Example

file: archive.csv
delimiter: ;

fields[]: List of columns to use

List of columns to use for extract

Items

field name

Item Type: string
Example

- fname
- lname