-
Notifications
You must be signed in to change notification settings - Fork 32
Expand file tree
/
Copy pathdata-explorer-summary-panel.qmd
More file actions
65 lines (37 loc) · 4.29 KB
/
data-explorer-summary-panel.qmd
File metadata and controls
65 lines (37 loc) · 4.29 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
---
title: "Summary Panel"
description: "Get instant column statistics and visualizations with Data Explorer's Summary Panel. View histograms, missing data, and detailed stats for every column."
---
The summary panel displays a scrollable list of all column names with an icon representing the data type. Each column will have a sparkline histogram or frequency table of the column data. Missing data for the column is displayed as both an inline bar graph and a percentage.
Select the {{<fa chevron-down>}} icon next to the column name to expand the column and see additional summary statistics and a larger sparkline.
{width=350 fig-alt="Column arr_delay expanded in the summary panel. There is a bar with 2 percent, depicting how much data is missing. There is a graph of arrival delays showing a right skew. Summary statistics are displayed: 8,824 missing, --86 min, --5 median, 6.96 mean, 1,127 max, 44.98 SD."}
Double-click a column name to bring the column into focus in the main data grid. This allows for quick navigation of wider datasets.
## Loading indicators
When first opening the Data Explorer or using features like scrolling, filtering, or sorting, you may see loading indicators in the summary panel and in the bottom left corner of the window:
{width=300 fig-alt="Summary panel showing flight data with columns like year, month, and day. A red progress bar loading indicator next to the column names shows the loading state. In the bottom status bar, a green loading indicator icon shows the loading status."}
## Tooltips
The summary sparkline charts and missing data indicators display tooltips when you hover over them:
::: {layout-ncol=2}
{width=250}
{width=300}
:::
When you hover over the data type indicator next to the column name, a tooltip shows the name of the column data type:
{width=300 fig-alt="Histogram showing data for air_time is highlighted, with a tooltip displaying a range of 121.3 to 129.7 and count of 13,239 (4.0%)."}
If the column has a label, the tooltip includes the label:
{width=300 fig-alt="Hovering over column named 'age' in summary panel. Tooltip reads 'Age in years'"}
## Search and sort columns
### Search columns
To search for specific columns in the summary panel, type part of a column name into the summary panel search bar. The summary panel will display columns that match any part of the search text. Searching changes the summary panel display but does not affect the main data grid.
### Sort columns
To sort columns in the summary panel, select one of the following options from the sort dropdown:
- **Sort by original:** Display columns in their original order
- **Sort by name, ascending:** Sort column names A to Z
- **Sort by name, descending:** Sort column names Z to A
- **Sort by type, ascending:** Sort data types alphabetically (float, integer, string)
- **Sort by type, descending:** Sort data types reverse alphabetically (string, integer, float)
Sorting changes the summary panel display but does not affect the main data grid.
## Panel layout and settings
You can collapse or expand the summary panel by selecting the {{<fa circle-chevron-left>}}/{{<fa circle-chevron-right>}} button or by dragging the grid and summary panel divider.
You can also place the summary panel on the left or right side of the Data Explorer using the _Positron Data Explorer: Summary on Left_ or _Positron Data Explorer: Summary on Right_ command.
You can change the default settings for [`dataExplorer.summaryCollapsed`](positron://settings/dataExplorer.summaryCollapsed) or [`dataExplorer.summaryLayout`](positron://settings/dataExplorer.summaryLayout) in Positron settings:
{width=500 fig-alt="Settings UI screenshot showing 'Data Explorer: Summary Collapsed' with an unchecked box, and 'Data Explorer: Summary Layout' dropdown set to 'left.'"}