ThoughtSpot acquires Mode to define the next generation of collaborative BI >>Learn More

The Notebook

Overview

Every Mode report contains an integrated notebook-style environment where analysts can extend their analysis using either Python or R.

The Notebook’s moveable code blocks and markdown cells enable exploratory data analysis, visualization, and collaboration. Notebook environments have a variety of supported Python libraries and R packages installed. You can add the results of output cells to reports, or share a link to the Notebook directly. When Notebook output is included in the Report, that Report’s schedule will re-run the Notebook so all of the data stays in sync.

Using the Notebook

To get started using the Notebook:

  1. Open an existing report or create a new report and run one or more SQL queries from the SQL Editor.
  2. Click New Notebook. Your query results will automatically be loaded into a datasets object.
  3. On the right side panel, click the dropdown to select the environment you want to launch a Notebook from, usually either Python 3, R, or Python 3 Edge.

notebook language

Key elements of the Mode Notebook:

  • Toolbar - Where you can manipulate and run your Notebook, restart the session, export, and more.
  • Cells - Compose code and view results in a Code cell, or contextualize your work with a Markdown cell.
  • Resources Panel - The right side panel provides resources to help you including keyboard shortcuts, external documentation, and supported libraries/packages.
  • Status Indicator - Where you are notified about your Notebook session status.

Toolbar

Main Toolbar

Notebook Toolbar

  1. Run All - Runs all input cells in the Notebook in sequence (from top to bottom)
  2. Restart - Stops any current computations running in the Notebook. Restarts the session, thus clearing all the variables, libraries imported, etc. that were defined. However, code in input cells will be available to re-run after the Notebook restarts
  3. Run Cell and Advance - Runs code in the selected cell and advances to the next cell
  4. Add New Cell - Adds new input cell above or below the current cell
  5. Add to Report - Adds the output of the selected cell to the Report Builder
  6. More → Hide All Output - Hide all output in the notebook. Refreshing the notebook will show the output that was previously hidden.
  7. More → Export - Exports all input cells as a .py or .r file

Cell Toolbar

Cell Toolbar

  1. Run Cell and Advance - Runs code in the selected cell and advances to the next cell
  2. Add New Cell - Adds new input cell above or below the current cell
  3. Move Cell Up - Moves the current input or markdown cell up
  4. Move Cell Down - Moves the current cell down
  5. Fold Cell - Folds (hides) the current cell. Folded cells can still run
  6. Freeze Cell - Freezes the current input cell so that no changes are allowed; also prevents this cell from running
  7. Markdown/Code dropdown - Allows you to select the type for the current input cell (as code or markdown)
  8. Add to Report - Adds the output of the selected cell to the Report Builder
  9. Delete Cell - Permanently removes cell from the notebook

Working with cells

There are two types of cells in the Notebook:

Markdown - Markdown cells allow you to add context to your analysis. Markdown cell contains text formatted using Markdown and displays its output in-place when it's run.

Code - Input Python or R code into the IN section of the cell. When this cell runs, any corresponding output (including visualizations) will be shown in the OUT section.

Notes:

  • When you run your notebook, cells are executed in the order they are displayed, starting from the top cell.
  • To select or change a cell's type, go to the dropdown menu in the cell toolbar and choose Code or Markdown.
  • To run a cell, select it and press Shift + Return. Or click Run Cell in the cell or main toolbar.
  • The number next to the cell label will increment by one every time code in the cell is successfully run.
  • To see available methods for an object, type the name of the object followed by . and then press tab.

Notebook Status

The status indicator, located in the bottom right corner of the browser window, will notify you if there is an issue with your session. It may prompt you to restart the kernel.

  • Setting up notebook - Displayed when opening up a new Notebook, or after re-starting your session.
  • Ready - Notebook is ready to go.
  • Running - Your code is executing.
  • Loading dataframes - This message may display for larger datasets while dataframe information is loaded into the Notebook.
  • Notebook has encountered an unexpected error - Your session has crashed and will need to be restarted.
  • There was a problem with your session - Your session has terminated and you need to click Restart to get things working again.
  • Cell is still running. Hang tight! - This can appear when code being run includes long-running, computationally intense functions. The Notebook is still online.
  • Notebook is having trouble, try running again - The Notebook is experiencing problems. Please try running your code again to fix the issue.

Accessing query results

The Notebook has access to the results of every query in your report. However, the way you access those results differs depending on the language you're using. In each case, all query results are delivered to the Notebook as a custom object called datasets. datasets contains objects of the following type:

Python: pandas DataFrame

R: Data Frame

In your Notebook code, reference query result sets in the datasets list by query name, position, or token. For example:

To return results for:PythonR
First query added to reportdatasets[0]datasets[[1]]
Second query added to reportdatasets[1]datasets[[2]]
Query named 'Active Users'datasets["Active Users"]datasets[["Active Users"]]
Query with token '6763b688fb54'datasets["6763b688fb54"]datasets[["6763b688fb54"]]

Notes:

  • The datasets object won’t update in the Notebook until after all queries in the report have run successfully.
  • R is 1-indexed and Python is 0-indexed.
  • If you refer to query results by the query name, remember to update your code if you rename the query in your report.
  • The order of the results in the datasets object is based on when the query was added to the report. Renaming a query may change the order it's displayed in the report editor but will not affect its position in the datasets object.

How to find a query's token

To find the query token starting from the Notebook or editor, click View in the header, then View details, and then click SQL for the query you wish to use. The URL for SQL contains the query token at the end:

https://app.mode.com/ORGANIZATION_USERNAME/reports/REPORT_TOKEN/queries/QUERY_TOKEN

Query token

Memory Management in Python

For Mode Business and Enterprise paid plans, Mode’s Python notebook has 16GB of RAM and up to 16 CPU available to it. The free Mode Studio notebook is limited to 4GB of RAM and 1 CPU. To effectively manage memory usage in the Mode Notebooks consider (1) data load of query result sets, (2) incremental library installation, (3) memory utilization in session. 

Data load of query result sets

Query result sets are loaded into the notebook when the user explicitly references the query. Users can consistently load upto 2GB per raw query result as a pandas dataframes in the notebook.

Incremental library installation

For Mode Business and Enterprise paid plans, the Notebook environment has up to 1 GB of memory available to load additional packages.

Memory utilization in session

Memory usage in the python notebook can be checked by running the following command: 

from pympler.tracker import SummaryTracker
tracker = SummaryTracker()
tracker.print_diff()

Output

Adding cell output to your report

Notebook Toolbar

Add contents of the OUT section of any Notebook cell to the Report Builder by clicking on the cell and then clicking Add to Report in the toolbar. You can adjust the dimensions and placement of this cell in the Report Builder.

NOTE: Scheduled runs will only re-run the Notebook if the Report view page contains at least one output generated by the Notebook. In this case, the Notebook will re-run as part of the scheduled report run.

Add CSV export to a cell

You can add an export button to a Notebook output cell so viewers can export the calculated results contained in any dataframe to a CSV. The following examples add an export button to an output cell that will generate a downloadable CSV of the query results of a query named “New Users”:

Python
R

Supported libraries

Mode enables easier access to advanced analytical functions by supporting well-established, public libraries within Mode’s Notebooks. Common use cases include:

  • Data Manipulation - Cleaning, aggregating, and summarizing data.

  • Statistics - Simple things like distributions, regressions, and trend lines, as well as some advanced tasks like predictive modeling and machine learning.

  • Advanced Visualization - Python and R have many visualization libraries, enabling analysts to quickly build charts including heatmaps, small multiples, and distributions.

Python

IMPORTANT: Notebooks in the Mode Studio plan are unable to properly utilize the pip, requests, or the urllib3 packages in the Python or Python 3 Edge environments. To fully utilize these packages, please upgrade to a paid Mode Business or Enterprise plan.

Mode supports Python version 3.9 in the Notebooks.

Each environment comes pre-loaded with the following libraries:

LibraryVersion (Py3)Version (Edge)Description

IMPORTANT: We strongly discourage using either the requests or pygsheets libraries to access APIs that require authentication using personally identifiable credentials and information, as they will be visible to viewers of your report.

Edge

Mode provides access to an additional Python 3 environment called Python 3 Edge where pending library upgrades are staged. Analysts should use Edge as an alternative environment where they can test out the updated versions of supported Python libraries without fear of jeopardizing scheduled reports.

Mode will announce periodic scheduled promotion events via emails to Mode account administrators. Users will have at least 30 days from that time for testing and validation before the library updates will be made in the broader Python 3 environment. Any Notebooks using the Edge environment will be migrated to use the Python 3 environment at the same time.

Analysts can access Edge via the environment drop-down in the upper right-hand corner of the Notebook. When switching between environments, remember to Restart the Notebook session.

python edge environment

R

IMPORTANT: Notebooks in the Mode Studio plan are unable to properly utilize the httr package in the R environment. To fully utilize this package, please upgrade to a paid Mode Business or Enterprise plan.

The Notebook supports R version 4.2.0 and comes pre-loaded with the following R packages:

LibraryVersionDescription

IMPORTANT: We strongly discourage using the httr library to access APIs that require authentication using personally identifiable credentials and information, as they will be visible to viewers of your report.

Install additional libraries

IMPORTANT: Notebooks in the Mode Studio plan are unable to install additional libraries. To access this feature, please upgrade to a paid Mode Business or Enterprise plan.

To use a publicly available library in the Notebook that is not listed above, users leverage each environment’s package manager to install that library at run-time. The Notebook environment has up to 1 GB of memory available to load additional packages.

IMPORTANT: This offers a workaround to try to install additional libraries, beyond what Mode currently supports, into the Notebook. It is not guaranteed to work in all cases. Only supported libraries have been tested to function as expected in Mode’s Notebooks.

Mode’s Notebook architecture does not enable manually installed libraries to have access to the Notebook’s kernel. This means that manually installed versions of popular and interactive libraries like Plotly, Bokeh, and ipywidgets will not function as expected even if the package install appears to succeed.

Unlike officially supported libraries, you must install packages for any additional libraries in each individual report's Notebook environment. You must add the below package installation commands to the Notebook in each report where you want the corresponding libraries to be available. Avoiding these commands can result in the library not installing and or importing properly.

WARNING: Some libraries require authentication with credentials (e.g., Tweepy, requests, etc.). We strongly discourage using libraries that require authentication using personally identifiable credentials and information, as these credentials will be visible to viewers of your report.

Python

First, enter the following command into a Notebook cell for each public package that you want to install into the Python Notebook, as demonstrated below with the bloom-filter package (replace bloom-filter with the name of the package you want to install):

! pip install bloom-filter 
              ^^^^^^^^^^^^
              Package name

Alternatively, users can try to upgrade a supported package to a more recent version using:

! pip install [package name]==[version.x.y] --upgrade 

Next, in a subsequent cell, add an import statement for each library that you want to include in your environment. For example:

from bloom_filter import BloomFilter
     ^^^^^^^^^^^^
     Package name

You may now use any of the methods or functionality included in the library in subsequent Notebook cells.

R

First, enter the following command into a Notebook cell for each public package that you want to install into the R Notebook, as demonstrated below with the random package (replace random with the name of the package you want to install):

install.packages("random")
                  ^^^^^^
                  Package name

Next, invoke the library command for each library you want to include in your environment from the installed package(s). For example:

library("random")
         ^^^^^^
         Library name

You may now use any of the methods or functionality included in the library in subsequent Notebook cells.

Notebook keyboard shortcuts

General

ActionMacPC
Edit selected cellReturnEnter
Run cellShift ReturnShift Enter
Select cell aboveK or K or
Select cell belowJ or J or
Insert cell aboveAA
Insert cell belowBB
Move cell aboveShift Option Shift Alt
Move cell belowShift Option Shift Alt

Code editor

ActionMacPC
Code complete or indentReturnEnter
Select all ACtrl A
Undo ZCtrl Z
Redo YCtrl Y
Run cell EnterCtrl Enter
Insert cell belowOption EnterAlt Enter

FAQs

Q: How much memory is available to the Notebook?

Each Notebook session has the following resources available, depending on the version of your Mode Workspace:

Available memoryAvailable CPURun-time limitSuspend after idle forCan install additional libraries?
Mode Studio4 GB1 Core60 minutes30 minutesNo
Mode Paid Plans16 GB16 Cores12 hours60 minutesYes

When suspended, the Notebook environment can be resumed at any time by running a cell, running the entire Notebook, or running the report.

Q: Can you visualize a notebook generated visualization with Mode’s native chart editor?

At this time, it is not possible to use our visualization tools, such as Quick Charts and Visual Explorer, to manipulate Python/R dataframes. To visualize data from a notebook, you will need to use a visualization library to create a visualization. If you would like to see this functionality added in the future, please contact our Support team and they will be happy to add a request on your behalf for future consideration.

Q: How to pass parameters into the notebook?

To pass parameters to your notebook, you must add them as a column in your SQL query. You can then access those column(s) in the dataset object in your notebook:

SELECT
 '{{team}}' AS param
FROM
 benn.nfl_touchdowns

This is an example report (check Show Parameter Code) showing how this can be done. You can view the Python code by clicking Notebook on the left side panel.

Q: Can I add a Markdown cell into a report?

Currently it is not possible to add a Markdown cell into the Report Builder, it would have to be an output of a Code cell.

We recommend using Text Boxes in our Report Builder. This includes text, links, images and more to add context to your report.

Q: Can I use dbt Metrics in Notebooks?

Yes. Since metrics charts are SQL Queries under the hood, their results are made available to the Notebook and appear as data frames alongside all other Query results in a given Report

Q: Can you apply report filters to notebook generated visuals?

Mode's report filters only work with our native charts and tables.

However, you can leverage Parameters for this case. When you select a parameter and run the report, the queries return values ​​associated with the selected parameters. As a result, the Notebook and its visualizations will also be adjusted since the Notebook is purely powered by the query results.

Q: When do queries in the Notebook start to execute after a report run?

SQL Queries are kicked off simultaneously, and their results come in based on the processing time of your database. The notebook will wait until all SQL queries have successfully returned results before running. This is because the logic is set up such that the notebook does not know which query results execution is dependent on, so to be safe it waits for all the SQL queries to finish running. 

Therefore, it is possible that the notebook would render faster, but it must wait for all queries to finish running.

Q: I am on a paid Mode Business or Enterprise plan. Why can’t I pip install or upgrade certain libraries in the Notebook?

If you want to install or upgrade additional libraries or versions, we recommend following the steps outlined here. Please be sure to run the exact command listed on the site. If these commands do not work for you, it is possible that we do not support the library or the version of the library that you are trying to upgrade to.

Due to the current architecture of the Notebook, there are certain libraries that we are unable to support. The ability to manually install additional libraries or upgrade to newer versions is a workaround that we offer for these cases. However, we cannot guarantee that these libraries will function properly if they are not included in our list of supported libraries.

If you do not see a library listed as supported, it is considered a feature request. Please contact our support team to confirm and request the library.

Q: Do you have a tutorial where I can learn Python for business analysis using real-world data?

We do have a tutorial available that teaches Python for business analysis using real-world data. This tutorial is designed for users with little or no experience with Python, and it covers everything from the basics of the language to advanced techniques for analyzing and visualizing data.

If you’re interested in learning how to use Python for business analysis, this tutorial is a great place to start. It includes step-by-step instructions and hands-on exercises to help you apply what you learn to real-world scenarios.

To access the tutorial, please visit the page here. If you're interested in learning SQL as well, you can access this page here. We hope you find it helpful and we look forward to hearing your feedback.

Was this article helpful?

Get more from your data

Your team can be up and running in 30 minutes or less.