View data
You can browse and edit data in three modes: Table, Tree, Text, and Transpose. To switch between these modes, click the View as button (
) and select the mode that you need.
Transpose: viewing mode in which rows and columns are interchanged. You can combine this checkbox with other viewing modes.
To make this mode a default for tables and views, open settings by pressing CtrlAlt0S and navigate to . From the Automatically transpose tables list, select Always. When this option is enabled, query results are not transposed.
Table: the default viewing mode of table data. Data in a table is stored in a cell that is an intersection of a vertical column and horizontal row.
Tree: viewing mode in which data is displayed in the key-value table with the possibility to expand the key cell if it contains children nodes. Data from the expanded children node is distributed between key and value columns. You might consider using this mode to work with JSON and array data.
Text: viewing mode in which data is displayed as a text.
To transpose a table, a view, or a virtual view, click
View as and select Transpose.
Click the Reload Page button (
) on the toolbar.Right-click the table and select Reload Page from the context menu.
Press CtrlF5.
To see the query that was used to generate the result table, click the Show Options Menu button (
) and select View Query. If necessary, you can select the query text and copy it to the clipboard by pressing Ctrl0C.To close the pane where the query is shown, press Esc.
When you insert, delete, or modify data in a table editor, you can preview the query that PyCharm uses to perform selected operations. To preview the query, click the Preview Pending Changes button (
) on the toolbar.
To edit the value in the value editor, do the following:
To start a new line, press Enter.
To enter the value, press CtrlEnter.
To restore an initial value and quit the editing mode, press Esc.
To enable soft wrap in the editor by clicking the Toggle Soft-Wrap button
.
Click the gear icon (
) on the toolbar of the Aggregates tab to view, enable, and disable aggregates. To access the bundled aggregator, select Go to Scripts Directory. The scripts are located in Scratches and Consoles
tip
Aggregate scripts and extractors are interchangeable. If you have previously used an extractor that gets only one value, you can copy it to the aggregates directory and use it for aggregates.
To open the single record view, select a cell or a record and do one of the following:
Press CtrlShiftEnter.
Click
Record View on the toolbar.Right-click and select
Show Record View.
For the single record view, there are two layouts: single-column layout and two-column layout. You can switch the layouts by clicking 
Settings in the upper-right corner of the panel and selecting the other layout.
Single-column layout | Two-column layout |
 |  |
To visualize your data, click
Show Chart on the data editor toolbar.Default chart type is selected automatically depending on the data types. To view the exact value, hover over it on the chart.
On the chart toolbar, click
Show Series Settings.In the chart type selector, click the icon of the type that you want to plot.
For each axis, configure its settings:
Click Add Column and select the column that you want to plot.
Click
Modifier to modify the data display.
On the chart toolbar, click
Show Series Settings.To plot one more series with the data from the same table, click Add new series and configure the new series.
To delete a series, click
Remove in the upper-right corner of the series settings pane.
Click
Export to PNG on the chart toolbar to save the generated chart in the .png format.Enter the filename and click Save.
Item | Description |
|---|---|
| Export chart in the .png format. |
| Opens the series settings pane with chart type selector and axes settings. |
Item | Description |
|---|---|
Chart types | |
| Bar |
| Pie |
| Area |
| Line |
| Scatter |
| Bubble |
| Stock |
| AreaRange |
| Histogram |
Controls | |
| (For multiple series plots.) Removes a series from the plot. |
X axis | Determines a column plotted on the X axis. Axis Modifier defines how the data is displayed:
|
Groups | Determines how the X axis values are grouped. |
Y axis | Determines a column plotted on the Y axis. Axis Modifier defines which Y axis values are displayed. |
warning
The Geo viewer works only if JCEF is enabled. In rare cases, when you enable JCEF, PyCharm might crash. It can happen if you have installed plugins that use JavaFX. If the crash happened, refer to Recover PyCharm after enabling JCEF.
PostgreSQL database table | Tabular data file |
|---|---|
 |  |
note
To work with geographical data in PostgreSQL, you must install the Postgis extension on your PostgreSQL server. For more information about the installation process, refer to the Postgis documentation.
In the Database tool window () , double-click the table with geographical data.
Click
Show Options Menu on the toolbar of the data editor tab that opens and select Show Geo Viewer.Read the notification about possible risks of enabling JCEF. If you accept the risk, click Enable JCEF.
In the Restart Required window, click Restart Now.
After the restart, press CtrlF5 or reopen the table with geographical data.
Click
Show Options Menu on the toolbar of the data editor tab and select Show Geo Viewer.
To detach the Geo viewer tab from Services tool window, drag it from the tool window. To restore the layout, click 
Layout Settings in the upper-right corner of the viewer window and select Restore Default Layout.
In the Project tool window () , double-click the file with geographical data.
At the bottom of the editor tab that opens, click Data to view the file contents as table data.
Click
Show Options Menu on the toolbar of the editor tab and select Show Geo Viewer.
Thanks for your feedback!