system.dataset
Dataset Functions
The following functions give you access to view and interact with datasets.
📄️ system.dataset.addColumn
Takes a dataset and returns a new dataset with a new column added or inserted into it.
📄️ system.dataset.addRow
Takes a dataset and returns a new dataset with a new row added or inserted into it.
📄️ system.dataset.addRows
Takes a dataset and returns a new dataset with new rows added or inserted into it.
📄️ system.dataset.appendDataset
Takes two different datasets and returns a new dataset with the second dataset appended to the first.
📄️ system.dataset.clearDataset
Takes a dataset and returns a new dataset with all of the same column names, but all of the rows deleted.
📄️ system.dataset.dataSetToExcel
Formats the contents of one or more datasets as an excel spreadsheet, returning the results as a string.
📄️ system.dataset.dataSetToHTML
Formats the contents of a dataset as an HTML page, returning the results as a string.
📄️ system.dataset.deleteRow
Takes a dataset and returns a new dataset with a row removed.
📄️ system.dataset.deleteRows
Takes a dataset and returns a new dataset with one or more rows removed.
📄️ system.dataset.exportCSV
Exports the contents of a dataset as a CSV file, prompting the user to save the file to disk.
📄️ system.dataset.exportExcel
Exports the contents of a dataset as an Excel spreadsheet, prompting the user to save the file to disk.
📄️ system.dataset.exportHTML
Exports the contents of a dataset to an HTML page. Prompts the user to save the file to disk.
📄️ system.dataset.filterColumns
Takes a dataset and returns a view of the dataset containing only the columns found within the given list of columns.
📄️ system.dataset.formatDates
Returns a new dataset with Date columns as strings formatted according to the dateFormat specified.
📄️ system.dataset.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.
📄️ system.dataset.getColumnHeaders
Takes in a dataset and returns the headers as a python list.
📄️ system.dataset.setValue
Takes a dataset and returns a new dataset with one value altered.
📄️ system.dataset.sort
Sorts a dataset and returns the sorted dataset.
📄️ system.dataset.toCSV
Formats the contents of a dataset as CSV (comma separated values), returning the resulting CSV as a string.
📄️ system.dataset.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.
📄️ system.dataset.toPyDataSet
This function converts from a normal DataSet to a PyDataSet, which is a wrapper class which makes working with datasets more Python-esque.
📄️ system.dataset.updateRow
Takes a dataset and returns a new dataset with a one row altered.