DataSpell 2023.2 Help

Working 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:

Working with tables

When data frames are built, they are displayed in the tabular form. To open a data frame 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

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 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 sort the table data based on the column values, you can either click the column name or select Ascending or Descending from the context menu.

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

Configure the viewing mode

  • You can browse table data in several modes: Table, Tree, Text, and Transpose. To switch between these modes, click the View as button in the upper-right corner of the output cell and select the mode that you need.

    Switching between viewing modes

    For more information about viewing modes, refer to View data.

  • To configure the way DataSpell displays data in the Text mode, use the Data Extractors drop-down:

    Tables data extractors

    For more information, refer to Data extractors.

Viewing column statistics

  1. Run a code cell that produces a table output from a data frame.

    Running a cell with a table output
  2. In the cell output, hover over a column name. A popup with column statistics appears.

    Column statistics for non-numeric data
    Data type

    Shows the data type the column belongs to

    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 non-numeric data
    Data type

    Shows the data type the column belongs to

    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

Last modified: 27 September 2023