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