DataSpell 2025.1 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 the cell handle in the gutter next to the cell output.

Cell output expanded
Cell output collapsed

    Disable scrolling in output cells

    1. Right-click the output cell.

    2. Disable the Scrolling for Outputs option. The entire output will be displayed without limiting the number of lines.

    Cell output scrolling enabled

    Work 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. Press Ctrl+Alt+S to open settings and then select Languages & Frameworks | Jupyter.

      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 required 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

      Work with tables

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

      Open cell output in a new tab
      • To open the table search bar, click the table and press Ctrl+F.

      • To open the context menu, right-click the column name:

        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 Show Column List Ctrl+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 Show Column List window.

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

      • To toggle and configure cell coloring, click Table Coloring Options.

        Configuring table color mapping

      Create a new table from a file

      1. Click New Cell and select Import Data.

        Select Import Data cell
      2. Do one of the following:

        • Drag and drop TSV, CSV or Excel XLSX file from your project to the cell.

        • Click Browse file and select the file in the dialog that opens.

        Add file to the Import Data cell
      3. Run the cell and continue to work with the table using UI elements or Python code.

      Save data as a file

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

      2. Choose an 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.

      Sort 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.

      Filter data

      1. Click Open Filter View in the upper-right corner of the table.

      2. In the dialog that opens, select the column where you want to apply the filter and specify the filter criteria.

      3. If you want to use additional filters, click Add filter and specify the new filter criteria.

      4. Click Apply to filter data.

      To remove or duplicate a filter, click Additional Filter ActionsAdditional Filter Actions and select the required option from the list.

      Adjust table formatting

      1. Click More Actions and select Format Table...

      2. In the dialog that opens, specify the format and click OK.

        Dialog with the input field for the format

      DataSpell supports Python 2 formatting syntax.

      Use Expression Input

      You can use Expression Input to display multidimensional data in a two-dimensional table format.

      1. Click More Actions and select Show Expression Input.

      2. Write your expression in the input field that appears on top of the table and press Enter.

      Table expression input

      View column statistics

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

      To change the default mode, navigate to Settings | Languages & Frameworks | Tables.

      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:

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

      2. Click Show Column Statistics and select Detailed.

        The detailed statistics are shown above the columns.

      Column statistics for non-numeric data
      None Count

      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
      None Count

      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

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

        • Bar

        • Pie

        • Area

        • Line

        • Scatter

        • Bubble

        • Stock

        • AreaRange

        • 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

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

      2. Enter the filename and click Save.

      AI-generated charts

      You can generate a number of preview-charts for a DataFrame using AI. These previews can then be transformed into notebook cells.

      1. Click AI Quick Charts in the upper-right corner of the table.

      2. You will see the suggested charts under the table. Click any of them to insert the corresponding visualization code as a notebook cell.

      AI suggested charts

      Work with images

      To view variables representing NumPy 1D, 2D or 3D arrays as images, click View as image in the upper-right corner of the table.

      View as Image

      In the window that opens, you can use the following toolbar options to work with the image.

      Item

      Description

      Show Chessboard

      Click this button to toggle a chessboard background.

      Show Grid

      Click this button to toggle a visible grid over the image.

      Zoom In

      Click this button to expand the image.

      Zoom Out

      Click this button to compress the image.

      Actual Size

      Click this button to restore the actual size of the image.

      Fit Zoom to Window

      Click this button to make a larger image fit the window size.

      Show Color Picker

      Click this button to open the Color Picker window.

      Save Image

      Click this button to save the image on your device.

      Copy Image

      Click this button to copy the image to the clipboard.

      Select Image display mode

      Use this dropdown to select one of the following image display modes:

      • Original

      • Inverted

      • Grayscale

      • Binary

      Or click Configure... to set a custom binarization threshold.

      Last modified: 10 April 2025