Datalore 2025.1 Help

Datalore concepts

This page will help you get familiarized with the basic concepts in Datalore to better understand how to organize your work here.

In a nutshell, your work in Datalore revolves around analyzing data and publishing your results as HTML pages with tables, charts, and explanatory texts. To reach those goals, you will be primarily working with:

  • Home page

  • Notebook editor

  • Workspaces

  • Notebooks

  • Data sources

  • Attached data

  • Reports

Home page

The Home page is where you organize your work and results. The page provides access to all your workspaces, your own and shared resources, and recent activities in Datalore.

This is how the Home page looks on your first visit to Datalore:

Private workspace, Notebooks menu

Notebook editor

The Notebook editor (or, 'the editor') is where you develop and edit the content of your notebooks and prepare them for publishing as reports.

This is what the editor looks like when you open a notebook in it:

Editor page

Notebook

Notebook is the basic Datalore document where you create and combine executable code, formulas, tables, charts, and texts.

With Python being the default language, you can also choose to code in Scala, R, and Kotlin in your Datalore notebooks.

The structure of a Datalore notebook comprises different types of cells:

  • Code cells are used for coding in the programming language selected for the notebook.

  • Markdown cells are used to provide explanatory or descriptive texts to your code.

  • Chart cells are used to build advanced charts based on DataFrames without manually writing the required code.

  • SQL cells are used to query attached databases and other data sources.

  • Metric cells are used to track numerical values in your code and compare them to others.

  • Export to database cells are used to append DataFrames to attached database tables.

Workspace

Workspace is a collection of notebooks with a variety of shared resources, such as data sources, SSH keys, or environment variables. The Home page of Datalore is where you manage your workspaces.

Datalore users can share their workspaces with other users as part of their collaboration and further development of projects that require team effort.

Data sources

Datalore allows you to connect to data from the following types of sources:

  • Imported (or created) isolated files

  • All popular databases

  • Cloud storage systems: SMB/CIFS folders, Amazon S3. Google Cloud

Attached data

The editor provides an easy-to-use tool, Attached data to manage your data sources in each of your notebooks.

You attach data from your connected data sources to the notebook in order to access it in the code.

To help you query attached data easily and quickly, Datalore provides a special type of cells, SQL cells.

Reports

Reports are presentations of your notebooks in form of HTML pages where you choose which parts of the notebook are visible to the viewer and how they can interact with them.

You can publish your notebooks as static or interactive reports to give the audience the opportunity to control how they view the presented data.

In many cases, a report is the final result of your work on a particular notebook and the best way to display the data your target audience is most interested in, hiding the coding part, which can be irrelevant for such demonstrations.

Last modified: 05 December 2024