Skip to main content

CSV To Data Table

Converts a CSV file to a data table format.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • CSV File Path - The file path to the CSV file to be converted.

Options​

  • Output Type - Specifies whether to pass the table by reference or by value. Options are:
    • Pass By Reference
    • Pass By Value

Output​

  • Table - The resulting data table converted from the CSV file.

How It Works​

The CSV To Data Table node reads a CSV file and converts it to a data table format. When executed, the node:

  1. Validates that the CSV file path is not empty
  2. Checks if the CSV file exists at the specified path
  3. Reads the CSV file using pandas
  4. Replaces any NaN values with empty strings
  5. Converts the data to a dictionary format with columns and rows
  6. Returns the data table

Requirements​

  • A valid CSV file path
  • The CSV file must exist at the specified location
  • Proper file system permissions to read the file

Error Handling​

The node will return specific errors in the following cases:

  • Empty CSV file path
  • CSV file does not exist at the specified path
  • Invalid CSV file format
  • Insufficient permissions to read the file

Usage Notes​

  • The Output Type option can be set to "Pass By Reference" for handling large CSV files more efficiently
  • NaN values in the CSV file are automatically converted to empty strings
  • The first row of the CSV file is used as column headers
  • The node supports standard CSV formats with comma separators