Run notebooks and analyze data

• Click on the notebook editor toolbar to execute all paragraphs of the notebook, all paragraphs above or below the current one. The progress of the execution will be shown on the toolbar.

• Click icon in the gutter to execute a particular paragraph of the notebook.

When you execute code of your notebook, you might want to restart an interpreter on the target Zeppelin server. For your convenience, DataSpell provides several options to do this:

• Click on the notebook toolbar.

• Right-click the Run icon in the gutter and select Restart Interpreter.

• Right-click any paragraph in the editor and select Restart Interpreter from the context menu.

• Click a column header to order values in it.

• Click to filter data in the selected column.

• Click to organize table in pages. Toggle this button and specify the number of table rows to display on a page: 10, 15, 30, or 100.

• Click and select the columns to be shown in the table.

1. Click to save the table in a .csv file.

2. Enter the filename and click Save.

1. Click to alter the initial settings of the chart.

   

2. Click any icon that corresponds to a chart type and the new chart will be plotted. For example, click to add a new scatter chart.

3. Drag the columns you want to plot to the specific field:

   

   Gif

4. Click the Add new series link to add more series to the chart. Then drag the required columns to the target fields to set the axes.

1. Click to save the generated graphical output in the .png format.

2. Enter the filename and click Save.

1. To define the way the chart looks, click on the chart toolbar (right side of the output area).

2. Select the contrast or default theme. Click to modify the theme colors. Also, you can click to clone the theme and customize it later.

   

3. Review the modified settings in the preview area and save the changes.

1. In the Zeppelin connection settings, make sure the Enable State Viewer integration checkbox is selected.

   

2. If you want to fine-tune State Viewer settings, click Show State Viewer Settings.

3. Open any notebook on the target Zeppelin server and execute any paragraph to collect data.

   note

   Alternatively, you can create a local Zeppelin notebook in your project and link it to the configured connection.

4. Once the paragraph is executed, the State Viewer tool window opens. You can see the State Viewer synced status in the notebook toolbar.

   

5. In the State Viewer tool window, you can preview the values of the variables and expand hierarchical data. You can right-click any variable to open a context menu and inspect the variable in a separate window with the Inspect ... command, or preview its value in text form (View Text).

   

   At any time, you can click to sync up with the server.

   If you closed the State Viewer tool window, you can quickly reopen it: click at the top of your Zeppelin notebook and select Open State Viewer Window.