![]() ![]() ![]() This parameter indicates if quotes should be regarded. This option might be problematic if TABs ('\t') are used as separators. This parameter indicates if lines should be trimmed (removal of empty spaces at the beginning and the end) before the column split is performed. It can also be provided as a regular expression.Ī good understanding of regular expressions can be developed by studying the description of Select Attributes Operator and its tutorial Processes. It can also be selected using the 'Choose a file' button.Ĭolumn separators for CSV files can be specified here. The path of the CSV file is specified here. ![]() This user-friendly wizard guides you to easily configure this Operator to import the CSV file. This port delivers the ExampleSet created from the CSV file provided at the input port, imported through the Import Configuration Wizard or loaded from the path given to the csv file parameter. This can be created with Operators having file output ports such as the Read File Operator. There are many Read Operators in the Data Access group and Files/ Read sub-group.įor example, there is Read Excel, Read URL, Read SPSS, Read XML and other Operators, which can read ExampleSet from different file formats.Ī CSV file can be optionally passed in as a file object. Please make sure that the CSV file is read correctly as an ExampleSet before building a Process that uses it. The easiest way to import a CSV file is to use the Import Configuration Wizard from the Parameters panel.Īll parameters can also directly be set in the Parameters panel.įor more details about the Operator, see the description of the parameters. The term 'CSV' suggests that the Attribute values would be separated by commas, but other separators can also be used. Values for different Attributes are separated by a separator character.Įach row in the file uses the constant separator for separating Attribute values. The CSV files store data (both numerical and text) in plain-text form.Īll values corresponding to an Example are stored as one line in the CSV file. This Operator reads an ExampleSet from the specified CSV file.ĬSV is an abbreviation for Comma-Separated Values. ![]()
0 Comments
Leave a Reply. |