> For the complete documentation index, see [llms.txt](https://docs.informationhub.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.informationhub.io/project/tables/analyse-data.md).

# Analyse Data

Information Hub can generate a ready-to-run script that connects directly to your table's data, so you can analyse it in Python or R without any manual setup.

## Using the Analyse feature

1. Open the table you want to analyse.
2. Click the **Analyse** button in the toolbar.
3. The analyse popover opens. Choose **Python** or **R** using the language selector at the top.
4. A script is automatically generated for you. It includes the connection details for this specific table.
5. Click the **copy icon** to copy the script to your clipboard.
6. Paste and run the script in your own Python or R environment (for example, Jupyter, VS Code, RStudio, or a terminal).

The script fetches the table's data using your API key and loads it into a data frame, ready for analysis.

{% hint style="info" %}
The generated script uses your personal API key for authentication. Make sure you have created an API key in **Account Settings** before using this feature. Without an API key the script will not be able to connect.
{% endhint %}

## What you can do with the script

Once the data is loaded in your environment, you can:

* Run statistical computations.
* Generate charts and plots.
* Transform and clean data.
* Build models and run experiments.

Results from your analysis can also be used to create components on your project's dashboards.

## External tools

{% hint style="info" %}
For analysis that does not require a live connection to Information Hub, you can export your data and use any external tool - Excel, SPSS, Jupyter, RStudio, or anything else that reads TSV or XLSX files.
{% endhint %}

Exporting is also useful when you need to:

* Use specialised software not available in the built-in environment.
* Share analysis results with collaborators who use different tools.
* Work offline without an internet connection.