Run notebooks and analyze data
To preview and analyze data sets, you need to run the executable paragraphs of your notebook.
Running notebooks
You can run paragraphs one by one or all at once. When executing any paragraph, mind code dependencies. If, for example, the current paragraph relies on the variables that are initialized in the previous paragraph, it needs to be executed first.
Click
on the notebook editor toolbar to execute all paragraphs of the notebook. The progress of the execution will be shown on the toolbar.Click
icon in the gutter to execute a particular paragraph of the notebook.
Once the execution completes, the execution status is shown in the toolbar and in the gutter:
: execution has been successfully finishedYou can click this icon to execute the paragraph again.
: execution has failed
: execution has been aborted
In case of the successful execution, preview the output that is shown below the paragraph code.
Refresh interpreters
When you execute code of your notebook, you might want to restart an interpreter on the target Zeppelin server. For your convenience, PyCharm provides several options to do this:
Click
on the notebook toolbar.Right-click the Run icon in the gutter and select .
Right-click any paragraph in the editor and select from the context menu.
Viewing tables
By default, the Table tab shows all the processed data.
Organize data in the table
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.
Export tables
Click
to save the table in a .csv file.Enter the filename and click Save.
Viewing charts
The default type of the chart is defined by the chart settings on the server. However, you can configure and modify the predefined settings.
Configure charts
Click
to alter the initial settings of the chart. 
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.Drag the columns you want to plot to the specific field:
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.
Export charts
Click
to save the generated graphical output in the .png format.Enter the filename and click Save.
Troubleshooting
If, for some reasons, the execution of the notebook or a particular paragraph has failed, review the error message and consider some typical troubleshooting actions:
| Problem | Recommended action |
|---|---|
The notebook toolbar is not available. The following warning message is shown:  | Click the Try Reconnect link to get the notebook connected to the server. |
Server connection is lost. The corresponding icon shows the disconnected status of the server:  | Click  to reestablish the connection to the server. |
| Interpreter session gets expired. For example, the error message reports that the Spark session is expired. | Click  on the notebook toolbar control and restart the problematic interpreter. |