Read CSV

What it is

A block that reads and processes CSV (Comma-Separated Values) files.

What it does

This block takes CSV content as input, processes it, and outputs the data as individual rows and a complete dataset.

How it works

The Read CSV block takes the contents of a CSV file and splits it into rows and columns. It can handle different formatting options, such as custom delimiters and quote characters. The block processes the CSV data and outputs each row individually, as well as the complete dataset.

Inputs

Input	Description
Contents	The CSV data as a string
Delimiter	The character used to separate values in the CSV (default is comma ",")
Quotechar	The character used to enclose fields containing special characters (default is double quote '"')
Escapechar	The character used to escape special characters (default is backslash "\")
Has_header	Indicates whether the CSV has a header row (default is true)
Skip_rows	The number of rows to skip at the beginning of the CSV (default is 0)
Strip	Whether to remove leading and trailing whitespace from values (default is true)
Skip_columns	A list of column names to exclude from the output (default is an empty list)

Outputs

Output	Description
Row	A dictionary representing a single row of the CSV, with column names as keys and cell values as values
All_data	A list of dictionaries containing all rows from the CSV

Possible use case

This block could be used in a data analysis pipeline to import and process customer information from a CSV file. The individual rows could be used for real-time processing, while the complete dataset could be used for batch analysis or reporting.