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.

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.

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

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.

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.