Work with outputs

Create a new table from a file

1. Click New Cell and select Data Import.

   

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.

   

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

Customize tables toolbar

1. Press Ctrl+Alt+S to open settings and then select Appearance & Behavior | Menus and Toolbars.

   Alternatively, click on the toolbar and select Customize Tables Toolbar.

2. Add or remove actions under Customize Tables Toolbar.

   For more information, refer to Menus and toolbars.

3. Click OK to apply the changes and close the window, or click Apply to keep the window open.

Customize page size

You can use the Change page size widget in the upper-left corner of the table to define how many rows are shown at once:

• Select one of the predefined values in the Page Size list.

  

• To specify a custom number of rows, select Custom in the Page Size list, enter the value in the dialog that opens, and click OK.

  

• To make the selected value the default, click Set as Default. The word Default will appear next to the chosen value.

  

Work with columns

• To open the table search bar, click the table and press Ctrl+F.

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

  

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

  

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.

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.

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

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

Sort data

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

  

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

  

  The data will be sorted by selected columns.

  

  State	Description
  	Indicates that the data is not sorted in this column. The initial state of the sorting marker.
  	The data is sorted in the ascending order.
  	The data is sorted in the descending order.
  	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. For columns with the object data type, filter values should be entered in quotes.

   You can use the Wrap with Quotes action to add them automatically.

   

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

5. Click Apply to filter data.

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

Reload data

Click Reload Data in the upper-right corner of the table. This refreshes the view with the most recent data.

Save data as a file

1. Click More Actions in the upper-right corner of the table and select Export Data to File.

2. Choose an extractor and configure additional settings.

   

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

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

Adjust table formatting

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

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

   

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.

Configure charts

1. Click 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

   

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

Fit image to editor width

Right-click the output cell and enable the Fit to Editor Width option in the context menu.

Save image

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

Copy image

Right-click the output cell and select Copy from the context menu.

Disable color inversion in plots

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:

• To disable inversion for a specific plot, right-click it and select Invert Image from the context menu.

• To permanently disable color inversion for all images:

  1. Right-click any image output and select Configure Inversion from the context menu.

     Alternatively, go to Settings | Jupyter | Jupyter General.

  2. Disable the Invert image outputs for dark themes checkbox.

  3. Restart the editor to apply the changes.