DataSpell 2023.3 Help

Work with outputs

When you execute a code cell, its output is shown below. You can save the results or clear the output.

You can manage the length of the notebook by expanding and collapsing cell outputs.

Expand or collapse cell outputs

  • Click an arrow next to the cell counter:

Working with plots

Save a plot as an image

  • Right-click the output and select Save As from the context menu.

If you are using a dark UI theme, the colors in charts are adapted for better readability by default. To change this behavior, perform the following steps:

Disable color inversion in plots

  1. Go to Languages & Frameworks | Jupyter in the IDE Settings (Control+Alt+S)

  2. Disable the Invert image outputs for dark themes checkbox

  3. Restart the editor to apply the changes.

Resize plots

  1. Move the mouse pointer to the bottom of the cell, so that the pointer becomes a double arrow.

  2. Click and drag the cell border up or down to reach the desired size:

Dataframes and series can be displayed in tabular or graphical form. By default, tables are shown. To toggle the view mode, use the corresponding icons in the upper left corner.

View dataframe as a table

Working with tables

To open the table in a separate editor tab, click Open In New Tab in the upper-right corner of the output cell.

Open cell output in a new tab

Save data as a file

  1. Click Export Data to File Export Data to File.

  2. Choose extractor and configure additional settings.

    Export data

  3. Click the Browse button Browse to choose the location for your file.

  4. Click Export to File to save the data as a file.

  • Right-click the column name to open the context menu:

    Copying table headers

  • To copy the column name to the clipboard, select Copy Column Name.

  • To select the entire column, select Select Column.

  • To hide a column, select Hide Column. Hide Other Columns will hide all columns except the selected one.

  • To display hidden columns, click Columns List Control+F12. The hidden columns are shown strikethrough. Select a column and press Space to toggle its visibility. To search through the column list, start typing a column name in the Columns List window.

  • To assign a language to a column, use Set Highlighting Language. For more information, refer to Inject a language for a column.

Sorting data

  • To sort the table data based on the column values, you can either click the column name or select Ascending or Descending from the ORDER BY section in the context menu.

    Sorting the table data

  • To add another column to sorting, you can either click the column name while pressing Alt or select Ascending or Descending from the Add to ORDER BY section in the context menu.

    Adding another column to the sorting

    The data will be sorted by selected columns.

    Data sorted by selected columns

    State

    Description

    No sorting

    Indicates that the data is not sorted in this column. The initial state of the sorting marker.

    Ascending order

    The data is sorted in the ascending order.

    Descending order

    The data is sorted in the descending order.

    Sorting level

    The number to the right of the marker (1 on the picture) is the sorting level. You can sort by more than one column. In such cases, different columns will have different sorting levels.

Viewing column statistics

By default, column statistics are shown above the columns in a Compact mode, which includes only the Missing and Count statistics.

Column statistics in a compact mode

For numeric data, histograms are plotted and shown together with statistics. Hover over the histogram to view detailed information about each bar.

To view detailed column statistics, do one of the following:

  • Hover over a column name. A popup with column statistics appears.

  • Click Grid core icons expui statistics panel Show Column Statistics and select Detailed.

    The detailed statistics are shown above the columns.

Column statistics for non-numeric data
Missing

Shows the number of None values in the column

Count

Shows the total number of items in a column

Distinct

Shows the number of unique values

Top

Shows the most popular value

Frequency

Shows the number of times an element occurs

Column statistics for numeric data
Missing

Shows the number of None values in the column

Count

Shows the total number of items in a column

Mean

Shows the average number of all values in the column

Std. Deviation

Shows the standard deviation value

Min

Shows the minimum value in the column

Pctl

Shows values for 5th, 25th, 50th( Median) and 95th percentiles

Max

Shows the maximum value in the column

Working with charts

To view dataframes or series in a graphical form, click Show Chart.

View data as a chart

The data will be displayed in the form of a chart. You can change the type of chart and configure additional settings.

Data displayed as a chart

Configure charts

  1. Click Show series settings Show series settings to change the initial settings of the chart.

  2. Select the chart type and configure the settings. You can choose one of the following chart types:

    • Charts icons chart chart bar Bar

    • Charts icons chart chart pie Pie

    • Charts icons chart chart area Area

    • Charts icons chart chart line Line

    • Charts icons chart chart scatter Scatter

    • Charts icons chart chart bubble Bubble

    • Charts icons chart chart stock Stock

    • Charts icons chart chart area range AreaRange

    • Charts icons chart chart bar Histogram

    Change initial settings of the chart

  3. Click the Add new series link to add more series to the chart.

Save a chart as an image

  • Click Export to PNG Export to PNG to save the generated chart in the .png format.

  • Enter the filename and click Save.

Last modified: 28 November 2023
Work with SQL cells Manage Jupyter notebook servers