---
title: "system.dataset.toDataSet"
description: "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.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.

This function is used in **Python Scripting**.

## Description
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.

## Client Permission Restrictions
This scripting function has no [Client Permission](projects\project-properties\project-properties.md#client---permissions) restrictions.

## Syntax (Without Headers)
`system.dataset.toDataSet(dataset)`

### Parameters
Type | Parameter | Description 
------- | ------- | ------
PyDataSet | `dataset` | A PyDataSet object to convert.

### Returns
**Dataset** - The newly created dataset.

### Scope
All

## Syntax (With Headers)
`system.dataset.toDataSet(headers, data)`

### Parameters
Type | Parameter | Description 
------- | ------- | ------
PySequence | `headers` | A PyDataSet object to convert.
PySequence | `data` | A list of rows for the new dataset. Each row must have the same length as the headers list, and each value in a column must be the same type.

### Returns
**Dataset** - The newly created dataset.

### Scope
All

## Code Examples
```python title="Example 1"
# This example create a single column dataset.

header = ['myColumn']
rows = [[1], [2]]
dataset = system.dataset.toDataSet(header, rows)
```

```python title="Example 2"
# This first example shows how this function can be used to convert from a PyDataSet (which is what system.db.runQuery returns) to a normal DataSet, which is the datatype of a Table component's data property.
  
pyDataSet = system.db.runQuery("SELECT * FROM example1 LIMIT 100")
table = event.source.parent.getComponent("Table")
normalDataSet = system.dataset.toDataSet(pyDataSet)
table.data = normalDataSet
```