Scientific features
warning
The following is only valid when the Python plugin is installed and enabled.
When viewing variables in the Python Console, you can click View as Array, View as DataFrame, or View as Series links to display the data in the Data View tool window.
By default, the new table representation is used.
Click
More Actions and select 
Switch Between Table Representations to change the table interface.note
IntelliJ IDEA will remember your choice and use the selected table representation in the future, except for the data structures from the newly supported libraries (for example,
polars), which will always be displayed using the new representation.
To open the table search bar, click the table and press .
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 . The hidden columns are shown strikethrough. Select a column and press 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.
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.
To add another column to sorting, you can either click the column name while pressing or select Ascending or Descending from the Add to ORDER BY section in the context menu.
The data will be sorted by selected columns.
note
Value column cannot be added to sorting if sorting by the index column is active.
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.
To remove or duplicate a filter, click 
Additional Filter Actions and select the required option from the list.
Click
More Actions and select Format Table...In the dialog that opens, specify the format and click OK.
Click
More Actions and select Show Expression Input.Write your expression in the input field that appears on top of the table and press .
Hover over a column name. A popup with column statistics appears.
Click
Show Column Statistics and select Detailed.The detailed statistics are shown above the columns.
- Data type
Shows the data type the column belongs to
- None Count
Shows the number of
Nonevalues 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
note
Viewing column statistics in table outputs is equivalent to using the
describe()method forSeries. For more information, refer to pandas.Series.describe and polars.Series.describe.
Click
Show series settings to change the initial settings of the chart.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
Click the Add new series link to add more series to the chart.
Click
Export to PNG to save the generated chart in the .png format.Enter the filename and click Save.
Click
AI Quick Charts in the upper-right corner of the table.You will see the suggested charts under the table. Click any of them to insert the corresponding visualization code as a notebook cell.
