# Dataset

<figure><img src="/files/oaWr2HQMnZKn1XbNSp5f" alt=""><figcaption></figcaption></figure>

The Dataset node is an array of data.&#x20;

You can create a spreadsheet with your project's data and link it to the diagram, using the Dataset node. It's also possible to save and read data from Data nodes into Datasets.

## Creating a spreadsheet

Using your favorite spreadsheet editor, create a table with your project's data.

### Styling

The spreadsheet must be organized as such:

| {Dataset Name} | {Data 1} | {Data 2} |
| :------------: | :------: | :------: |
|                |     0    |     3    |
|                |     1    |     4    |
|                |     2    |     5    |

## Importing spreadsheets&#x20;

To import the spreadsheet into your project, you must use the Spreadsheets library menu.&#x20;

<figure><img src="/files/8C6N8N7Y2he5BiBNmoX6" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
The spreadsheet file must be in the XLSX file format.
{% endhint %}

## Interacting with the spreadsheet data

To reference the Dataset in the diagram, you need to use the following notation system: `datasetTag[`<mark style="color:red;">`x`</mark>`][`<mark style="color:green;">`y`</mark>`]`

Here's the above table with the coordinates individually marked:

<table><thead><tr><th width="213" align="center">Dataset Name (X = 0)</th><th width="283" align="center">Data 1 (X = 1)</th><th align="center">Data 2 (X = 2)</th></tr></thead><tbody><tr><td align="center"></td><td align="center">0 (Y = 0)</td><td align="center">3 (Y = 0)</td></tr><tr><td align="center"></td><td align="center">1 (Y = 1)</td><td align="center">4 (Y = 1)</td></tr><tr><td align="center"></td><td align="center">2 (Y = 2)</td><td align="center">5 (Y =2)</td></tr></tbody></table>

To reference the number "5", per example, we would write `datasetTag[`<mark style="color:red;">`2`</mark>`][`<mark style="color:green;">`2`</mark>`]`

In the same manner, to reference the number "4", we would write `datasetTag[`<mark style="color:red;">`2`</mark>`][`<mark style="color:green;">`1`</mark>`]`

If we put this into a Formula's "Expression" field `datasetTag[`<mark style="color:red;">`2`</mark>`][`<mark style="color:green;">`2`</mark>`] * datasetTag[`<mark style="color:red;">`2`</mark>`][`<mark style="color:green;">`1`</mark>`]`, it would be the same as inputting `5 * 4` and that would give `20` as the result.

{% hint style="info" %}
Datasets are very useful to gather together the inputs from your project.&#x20;

In this way, the only thing needed to update new values in your project is the spreadsheet with the updated values.
{% endhint %}

{% hint style="info" %}
You can also use Datasets to output data from the diagram. e.g. Individual Player Data based on Day.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://nodanomics.gitbook.io/docs/documentation/nodes/data-type-nodes/dataset.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
