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
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
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.
Was this helpful?