system.dataset
Dataset Functions
The following functions give you access to view and interact with datasets.
📄️ addColumn
Takes a dataset and returns a new dataset with a new column added or inserted into it.
📄️ addRow
Takes a dataset and returns a new dataset with a new row added or inserted into it.
📄️ addRows
Takes a dataset and returns a new dataset with new rows added or inserted into it.
📄️ appendDataset
Takes two different datasets and returns a new dataset with the second dataset appended to the first.
📄️ clearDataset
Takes a dataset and returns a new dataset with all of the same column names, but all of the rows deleted.
📄️ dataSetToHTML
Formats the contents of a dataset as an HTML page, returning the results as a string.
📄️ deleteRow
Takes a dataset and returns a new dataset with a row removed.
📄️ deleteRows
Takes a dataset and returns a new dataset with one or more rows removed.
📄️ exportCSV
Exports the contents of a dataset as a CSV file, prompting the user to save the file to disk.
📄️ exportExcel
Exports the contents of a dataset as an Excel spreadsheet, prompting the user to save the file to disk.
📄️ exportHTML
Exports the contents of a dataset to an HTML page. Prompts the user to save the file to disk.
📄️ filterColumns
Takes a dataset and returns a view of the dataset containing only the columns found within the given list of columns.
📄️ formatDates
Returns a new dataset with Date columns as strings formatted according to the dateFormat specified.
📄️ fromCSV
Converts a dataset stored in a CSV formatted string to a dataset that can be immediately assignable to a dataset property in your project.
📄️ getColumnHeaders
Takes in a dataset and returns the headers as a python list.
📄️ setValue
Takes a dataset and returns a new dataset with one value altered.
📄️ sort
Sorts a dataset and returns the sorted dataset.
📄️ toCSV
Formats the contents of a dataset as CSV (comma separated values), returning the resulting CSV as a string.
📄️ toDataSet
This function is used to 1. Convert PyDataSets to DataSets 2. Create new datasets from raw Python lists. When creating a new dataset, headers should have unique names.
📄️ toExcel
Formats the contents of one or more datasets as an Excel spreadsheet, returning the results as a byte array.
📄️ toPyDataSet
This function converts from a normal DataSet to a PyDataSet, which is a wrapper class which makes working with datasets more Python-esque.
📄️ updateRow
Takes a dataset and returns a new dataset with a one row altered.