system.dataset.fromCSV

Top | Previous | Next

Description

Converts a dataset stored in a CSV formatted string to a dataset that can be immediately assignable to a dataset property in your project. Usually this is used in conjunction with system.file.readFileAsString when reading in a CSV file that was exported using system.dataset.toCSV. The CSV string must be formatted in a specific way:

"#NAMES"

"Col 1","Col 2","Col 3"

"#TYPES"

"I","str","D"

"#ROWS","6"

"44","Test Row 2","1.8713151369491254"

"86","Test Row 3","97.4913421614675"

"0","Test Row 8","20.39722542161364"

"78","Test Row 9","34.57127071614745"

"20","Test Row 10","76.41114659745085"

"21","Test Row 13","13.880548366871926"

•	The first line must be "#NAMES"

•	The second line must list the names of the columns of the datset, each in quotes and separated by commas

•	The third line must be "#TYPES"

•	The fourth line must list the type of each column of the dataset in order

•	Integer = "I"

•	String = "str"

•	Double = "D"

•	Date = "date"

•	Long = "L"

•	Short = "S"

•	Float = "F"

•	Boolean = "B"

•	The fifth line must be "#ROWS" followed by a comma and then the number of rows of data in quotes (i.e. "#ROWS", "6")

•	The following lines will be your data, each column value surrounded in quotes and separated by a comma; each row on a separate line. The number of rows must match what was specified on line 5

Syntax

system.dataset.fromCSV(csv)

Parameters

String csv - A string holding a CSV dataset.

Returns

Dataset - A new dataset.

Scope

All

Examples

In this example it is assumed that the CSV file being read was a dataset that was previously exported using system.dataset.toCSV:

#Specify file path

file_path = "C:\\my_dataset.csv"

#Read in the file as a string

data_string = system.file.readFileAsString(file_path)

#Convert the string to a dataset and store in a variable

data = system.dataset.fromCSV(data_string)

#Assign the dataset to a table

event.source.parent.getComponent('Table').data = data