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.

Functions by Scope

No functions found for this category.