datui-keys - the keys of every datui screen
? or F1 on any screen shows that screen's keys,
grouped by task: / narrows them to those whose text matches, and
Enter closes the help and presses the key on the line. This page lists every
screen's keys, with the longer descriptions.
- ? / F1
- This screen's keys. In a text field ? types, and F1 opens the help
- Ctrl+O
- Go to the home screen, with the dataset you left selected. Its filter is
kept and selected, so typing replaces it. During a load, cancels the
load
- Ctrl+Q /
Ctrl+C
- Quit from anywhere; Ctrl+C quits from a text field too, where Alt+W
copies
- Click a
field
- Focus a form's field and act as Space does: a checkbox flips, a choice
steps, a picker opens, a button runs, and a text field takes the cursor.
In a list of sorts, filters or columns, the first click on a row focuses
it and the second acts on it. A click on a picker's line chooses it, a
click on a tab switches to it, and a click on a key in the footer presses
it. A click outside a dialog does nothing. With display.mouse = false (or
--mouse false) the mouse belongs to the terminal; in most terminals
Shift+drag selects text either way
- Right-click a
field
- Step a choice back, as ← does; else focus it
- ↑ / ↓ (j/k)
- Move between the keys
- Enter
- Close the help and press the selected line's key on the screen the help
was opened from
- /
- Narrow to the keys whose text matches
- Esc
- Clear the filter, then close
When datui asks before acting.
- ← / →
- Choose the other answer
- Enter
- Give the answer chosen, or close an error
- Esc
- Leave it as it was
Where a dataset opens.
Explore
- ↑ / ↓ (j/k)
- Move the row cursor
- ← / → (h/l)
- Move the column cursor, frozen columns included. The columns scroll only
when the cursor would leave the screen
- Shift+← /
Shift+→
- A page of columns left or right, the cursor on the page's first
column
- { / }
- First column, last column
- PgUp / PgDn
- A page up or down (Ctrl+B / Ctrl+F too)
- Ctrl+D /
Ctrl+U
- Half a page down or up
- Home / End
- First or last row (G = End)
- :
- Open the command line. Digits go to that row (the prefix shows row:);
anything else runs as SQL or q, whichever the prefix shows, and Ctrl+T
switches. With a query in effect, the line opens holding the query's
text
- g
- Go to a column by name
- / (f)
- Find text, a regex, or letters in order in the view. Matches on screen
light up as you type. Enter moves the cursor, row and column, to the first
match at or after the current row. f opens it too
- n / N
- Next / previous match from the cursor's cell, wrapping around the
view
- Enter
- On a row of a by query or a SQL GROUP BY, drill down to its rows (Esc
comes back); elsewhere, inspect the row
- Space
- Inspect the row: every field, each value whole and exact (Esc or Space
closes)
Shape
- [ / ]
- Sort by the cursor's column, [ ascending and ] descending, replacing the
sort in effect; the same key again on that column removes it. The s
sidebar adds secondary sorts
- s
- Open the Sort & Filter sidebar (tabs: Columns, Filters), on the
cursor's column
- + / -
- Filter on the cursor's cell: + keeps the rows with its value, - drops them
(on a null cell, the nulls). Each adds a filter to the Sort & Filter
sidebar, joined with "and"; the value is the cell's exactly as
stored
- r
- Reverse sort order (sorted columns carry a direction mark in the header);
with no sort, reverse the row order
- H / L
- Move the cursor's column one place left or right, the cursor with it; a
frozen column moves among the frozen ones. R puts the order back
- p
- Pivot or melt
- S
- Draw a sample of the source into memory; the query, filters and sort then
run over the sample. Rows show as they arrive (Esc stops and keeps them),
and the footer says, for example, sample 100,000 of 36.8M. Analysis,
charts and export read the sample. S again edits it; the Method No sample,
or R, removes it
- R
- Reset table: clear the sample, column types, query, filters, sort, column
order, hidden columns and widths, frozen columns, pivot/melt, drill-down
and the applied view
Analyze
- F
- Value counts of the cursor's column: each value's rows, percent and a bar,
with a summary. A number column opens as a histogram; c there shows the
list of its values
- a
- Open Analysis. In a Data Quality evidence drill a is disabled; Esc returns
to the observation
- c
- Chart the view
- i
- Open the Info panel (tabs: Schema, Resources, Partitions, Notes). H on its
Schema tab reads a CSV's first row as data, or as column names
Output
- e
- Export the view to a file
- y
- Copy to the clipboard (cell, row, view or table); a cell is the
cursor's
- v
- The saved views list
- V
- Apply the best-matching view (or open the list)
Display
- #
- Row numbers on or off. Each row keeps its place in the source as its
number through a sort or a filter (in a text file, its line number). On by
default for text and logs; display.row_numbers sets it
- ,
- Number formatting (digit grouping) on or off
- D
- The type row under the headers on or off
- < / >
- The cursor's column 4 cells narrower or wider
- = / w
- Fit the cursor's column to the rows on screen; w puts it back to automatic
width
- b
- On a binary file read through a format spec, read it again with another
spec. Clears the query, filters and sort
- T
- In a file of several tables (a workbook's worksheets, a database's tables,
a format spec's record types, a Hugging Face cache's splits), open another
table in place of this one, as --table does. Clears the query, filters and
sort, and applies a saved view for that table. On a file of one table,
says so
- t
- Follow the file as it grows (CSV, TSV, PSV, NDJSON). The file is read
again, so the query, filters and sort are cleared. While following, t
pauses and resumes, and Esc stops
Go
- q
- Back to the home screen when the dataset was opened from it; otherwise
quit
- Q
- Quit
- Esc
- Leave a drill-down; stop a find, a sample being drawn (its rows so far
stay) or a follow
Mouse
- Click
- The cursor to the cell; on a header, its column
- Double-click
- Enter on the row
- Double-click a
header
- Double-click a column's header to sort by it, as [ and ] do: ascending,
then descending, then back to no sort, replacing the sort in effect
- Double-click a
header's edge
- Double-click the gap right of a column's header to fit the column to the
rows on screen, as = does; the column cursor moves to it, and nothing is
sorted
- Wheel
- Scroll three rows a notch, as ↑ / ↓ do; the same in help,
the inspector and the sidebars
- Shift+wheel
- Move the column cursor, as ← / → do (a sideways wheel
too)
- Click a
key
- Press a key shown in the footer. A click on the filters and sort presses
s, and a click on the query presses :
- Drag a header
- Drag a column's header onto another column to move it there, as H / L do;
a rule on the header marks where it lands
- Drag a header's
edge
- Drag the gap right of a column's header to set its width by hand, as <
/ > do, from 4 to 240 cells
- Right-click
- Right-click a cell: the cursor goes there and a menu lists the keys that
act on it (+, -, F, [, ], y, Space), each with its key. ↑ /
↓ and Enter, or a click, run a line as its key does; Esc or a click
elsewhere closes it
datui with no path, or Ctrl+O from
anywhere.
Explore
- ↑ / ↓
- Move the selection (Ctrl+P / Ctrl+N too). The home screen opens with no
row picked, so nothing is read, and the search box names the row it starts
on. The first ↑ or ↓ picks that row, and PgUp, PgDn, Home,
End, Ctrl+↑ / Ctrl+↓ and the wheel move from it. A click
picks the row clicked, and typing picks the best match
- Ctrl+↑ /
Ctrl+↓
- Previous or next section
- PgUp /
PgDn
- A screenful, stopping at the first and last
- Home / End
- The first or last row. The filter has no cursor; typing always edits its
end
- ← / →
- Fold or unfold a section. → on a directory or a file of tables goes
inside it, and on a file a format spec reads as record types it lists
them, one row each. On `..` or the open-all row, which are already inside,
→ moves to the directory's first row. When a directory or RECENT
shows only its first rows, → on its more row shows them all, and
← on a row past the first ones shortens it again; on any other row,
← folds
- Space
- While the filter is empty: fold or unfold the section header under the
cursor. With a filter typed, it types
- Tab
- Cycle the sort; the footer names the order in effect when it has room
Go
- Enter
- What the footer says on this row: "Open all" reads a whole
directory as one table, "Inside" steps into it, "Open"
loads a file, "Look" finds out first. A catalog bookmark,
indented under its dataset, opens whole. On a section header, fold or
unfold it; on a more row, show the rest; on `..`, go up a level; on the
hidden-files row, show them. With no row picked yet, Enter acts on the row
the search box names
- Backspace
- Delete a filter character; on an empty filter, up a level (from a bucket,
back to its cloud source; from the top of a catalog's remote dataset, back
here)
- Esc
- Back out one layer: the path prompt, the filter (onto the first dataset),
the directory (back to the row it was entered from), then to the open
table
Find
- (type)
- Narrow by name or column; fuzzy, so "sal" finds
"sales". What you open often ranks first. Typing also searches
below the directory you are inside and the listed bucket names; matches
appear under "Found". A paste goes in whole
- ~
- While the filter is empty, type a path or URL by hand. The list shows the
directory being typed, narrowed by the name after the last /, and the
first name that matches is picked. The prompt takes characters, Backspace,
and Ctrl+U to clear. Tab completes the one name left, the start the names
share, or a name picked further down. ↑ / ↓ pick a name, and
↑ from the first goes back to the path as typed. Enter opens the
picked name or the typed path: a file opens, and a directory is entered.
Esc closes. A pasted path goes in whole, a line break in it as a space;
one starting with ~ pasted on an empty filter opens the prompt with it.
s3://, gs:// and az:// complete from buckets and prefixes already known.
With a filter typed, ~ types into it
- Ctrl+U
- Clear the filter or path input
- Ctrl+R
- List again what is on screen
Manage
- Ctrl+A
- Show or hide files datui cannot read; inside a SQLite database, its
internal tables
- Ctrl+X
- Show the local file under the cursor as bytes, in the hex view, whatever
datui would read it as
- Ctrl+D
- Add the dataset or directory under the cursor to catalog.toml, listed
under My datasets; on a row from catalog.toml, forget it. A heading stands
for the directory it lists. Only catalog.toml is written; another catalog
is hidden with home.hide
- Ctrl+E
- Open the Documentation view of a catalog row, of a place inside one, or of
a file whose format spec documents it: description, publisher, license,
links, record types, columns with units and value legends, bookmarks. A
catalog's description, link and column notes take precedence over the
spec's. Here Ctrl+E is not readline's end of line: the filter is always
edited at its end
- Delete
- Forget the highlighted recent entry, or a whole place after confirming, or
a row from catalog.toml, or hide a cloud source. On the Example datasets
heading, hide them until datui cache clear, after confirming
- Shift+Delete
- Forget every recent entry, after confirming
Mouse
- Click
- Select the row; double-click is Enter
- Wheel
- Move the selection three rows, stopping at the ends
Ctrl+E on the home screen, on a catalog row or a
file a format spec documents.
Read
- ↑ / ↓ (j/k)
- Move the cursor a line
- PgUp /
PgDn
- A page
- g / G
- The first or last line (Home / End too)
- Enter / Space /
→
- Open or close the value legend of the column under the cursor: a catalog's
values, or a spec's enum
- o
- Open the link on the cursor's line in the system browser. Only http and
https links open, and only after a question showing the whole URL (Enter
opens, Esc does not). Off over SSH or without a display: y copies the link
instead
- y
- Copy the link or value on the cursor's line, whole, however it is cut on
screen
- Esc / q /
←
- Back to the home screen
: at the table.
Run
- (digits)
- Digits alone go to that row, and the prefix says row: (:0 Enter is the
top)
- Enter
- Go to the row, or run the query in the language the prefix shows, sql: or
q:. Reopened with a query in effect, the line holds the query's text,
selected: typing replaces it, and the arrows edit it
- Ctrl+J
- Run, the same as Enter
- Ctrl+T
- Switch between SQL and q, keeping what is typed; the choice is remembered.
[query] default_mode sets the first
- Esc
- Close
Edit
- Tab
- Complete a column name, or df in SQL; again for the next match. The line
under the input lists the names that fit
- Alt+Enter
- SQL: start a new line
- ↑ / ↓
- Earlier and later queries from the history (Ctrl+P / Ctrl+N too; SQL and q
keep their own). In SQL over several lines, they move between lines
first
- Ctrl+U /
Ctrl+K
- Delete to the start or end of the line
- Ctrl+Z /
Ctrl+R
- Undo, redo
/ (or f) at the table.
Find
- (text)
- What to find: text (any case until a capital is typed), a regex with
Ctrl+R, or letters in order with Ctrl+T. Matches in the rows on screen
light up as you type, and the line says how many are on screen
- Enter
- Find: the cursor moves, row and column, to the first match at or after the
current row, reading beyond the rows already read when it must (the footer
counts the rows read; Esc stops). On an empty field, clear the find
- Ctrl+G
- Keep only the rows with a match, as a filter: the footer and the Sort
& Filter sidebar show it, and removing it there (or R) brings the rows
back
- Ctrl+R
- Regex on or off
- Ctrl+T
- Letters in order on or off: smth finds Smith
- Ctrl+L
- Only the column cursor's column, or every column shown
- ↑ / ↓
- Earlier patterns (Ctrl+P / Ctrl+N too)
- Esc
- Cancel
At the table
- n / N
- Next / previous match from the cursor's cell. After the last match the
find wraps to the first, and the footer says so. Presses typed while a
find is reading run in turn; Esc stops them all
- /
- Find again, the last pattern ready to edit
- Esc
- Clear the find (or stop one still reading)
g at the table.
Go
- (type)
- Narrow to the names that contain it
- ↑ / ↓
- Move
- Enter
- Go. The column cursor moves to it. A column already whole on screen stays
where it is; another becomes the first after the frozen ones, or lands on
the last page when it is there
- Backspace
- Delete a character (Ctrl+W a word, Ctrl+U all)
- Esc
- Close without moving
Space at the table.
Fields
- ↑ / ↓ (j/k)
- Move between fields
- Home / End
- First and last field
- PgUp /
PgDn
- A page of fields
- ← / → (h/l)
- Previous and next row; the table's cursor moves with it
- Tab /
Shift+Tab
- Into the value, to scroll and find in it. The panes keep their sizes: they
are split by what they hold, not by where the cursor is
- Enter
- On a group's row, its rows, as at the table. Else open a struct, a list,
or text holding a JSON object or array; or read a field the table's rows
do not hold (hidden and binary columns)
- r
- On a group's row, read a field the rows do not hold
- /
- Find a field by name, then by value: type to narrow, Enter or ↓
keeps the list narrowed, Esc clears it
- f
- Nulls: shown or hidden (null and empty fields); comparing, only the fields
that differ
- s
- Order: the table's, A-Z, or nulls last
- c
- Compare: a column for the next row, or the pinned one
- m
- Pin this row to compare others with; again to unpin
- Esc /
Space
- Close. Esc backs out one level at a time: a find first, then Compare, then
the inspector
Output
- y
- Copy the value as its view shows it
- Y
- Copy the whole row as one JSON object
- e
- The value's next view, where it has more than one
- w
- Word wrap or hard wrap for long text
- o
- Open the value in another program
Value
- ↑ / ↓ (j/k)
- Scroll a line
- PgUp /
PgDn
- Scroll a page
- Home / End
- Top and end, instantly, however long the value
- /
- Find in the value; n and N go to the next and previous match
- n / N
- The next or previous match in the value
- e, w, y, o
- As in the fields
- Esc / Tab
- Back to the fields (Shift+Tab too); Esc clears a find first
Find
- (type)
- The name or value to find
- Enter
- Keep the list narrowed; in a value, find
- Esc
- Clear the find
Nested
- Enter / →
(l)
- Open the focused item
- ↑ / ↓ (j/k)
- Move between fields, keys or items
- Tab /
Shift+Tab
- Into the item's value; not in an empty level
- PgUp /
PgDn
- A page of the level
- Esc / ←
(h)
- Up a level; at the row, Esc closes
- y
- Copy the focused item: text as itself, a JSON object or array
indented
- e
- The item's next view
i at the table.
Panel
- ← / → (h/l)
- Previous or next tab, from anywhere in the panel; Shift+Tab and Tab do the
same. The panel is a viewer, not a form: its body always has the keys
- ↑ / ↓ (j/k)
- Schema, Notes or Documentation tab: move the cursor. Model, Audio, MIDI,
Metadata and format tabs: scroll the list
- PgUp /
PgDn
- Model, Audio, MIDI, Metadata and format tabs: scroll the list a page
- Home / End
- Model, Audio, MIDI, Metadata and format tabs: the top or the end of the
list
- Enter
- Schema tab: change the column's type, with the names and formats a format
spec's type takes. Notes tab: take the offer on the note, where it has
one. Documentation tab: open or close the value legend of the column under
the cursor. Excel or SQLite tab: open the worksheet or table under the
cursor in place of this one, as T does
- o
- Documentation tab: open the link on the cursor's line in the system
browser. Only http and https links open, and only after a question showing
the whole URL. Off over SSH or without a display
- y
- Documentation tab: copy the link or value on the cursor's line, whole,
however it is cut on screen
- H
- Schema tab, CSV, TSV, PSV: read the first row as data, under column_1,
column_2, …; again to read it as column names. Reads the file
again, so the query, filters and sort are cleared, and the panel
closes
- c
- A dataset of more files than read.exact_count_files shows a row count
estimated from a sample of its footers; c reads every footer for the exact
count. The footer shows its progress, and Esc at the table stops it
- x
- Show the file's bytes in the hex view
- Esc / i
- Close the panel
F at the table.
Explore
- ↑ / ↓ (j/k)
- Move
- PgUp /
PgDn
- A page
- Home / End
- First and last row
- ← / → (h/l)
- The previous or next column; the table's column cursor moves with it
- Enter
- The rows holding the value, as a drill-down; Esc there comes back
here
- s
- Sort by count or by value
- c
- Switch a number column between its histogram, binned from the counts, and
the list of its values. A number column opens as its histogram; the header
says which is shown
- a
- Count every row, when the counts are of a sample
- t
- While following a file, count again with the rows that arrived since; the
footer says how many
Output
- y
- Copy the counts as TSV: every value, its count, percent and cumulative
percent
- e
- Export the counts to a file
- Esc
- Back to the table; while every row is being counted, stop that and keep
the sample
s at the table.
Sidebar
- Tab / Shift+Tab (↑
/ ↓)
- Next or previous field, wrapping; a field the form does not offer right
now is skipped. The arrows move from the moment the dialog opens
- ← / →
- On the tab bar: switch Sort & Filter / Columns. On a sort: flip its
direction. On a filter: and / or. On a column: step its sort (none,
ascending, descending). h/l too
- Space
- On a sort: flip its direction. On a filter: edit it (column, operator,
value). On "add sort": pick a column to sort by, last and
ascending. On "add filter": a new filter, starting on the
table's column cursor. On a column: step its sort
- Enter
- Apply everything staged and close, from any row (in the filter editor
Enter takes the step; Ctrl+J applies)
- Ctrl+J
- Apply from anywhere, including mid-edit (the row in progress is saved).
Ctrl+Enter does the same, on a terminal that tells it from Enter
- Esc
- Close an open picker or filter editor; otherwise cancel and close,
discarding what is staged. Reopening shows what is applied
In effect
- [ / ]
- Move the focused sort earlier or later in the sort order, or the focused
filter in the list
- d / Del
- Remove the sort or filter
- C
- Remove every sort and filter
Columns
- (type)
- Narrow the column list, when the find field is focused. ↓ from find
goes to the list, on the table's column cursor
- PgUp / PgDn, Home /
End
- A page of columns, or the first or last; ↓ stops at the last
column
- Space
- Cycle the column's sort: none → ascending → descending
(← steps back). Each column carries its own direction
- 1-9
- Put the column at that place in the sort order; 0 removes it (a digit past
the end of the order says so)
- Del
- Remove the column from the sort
- [ / ]
- Earlier or later in the sort order
- + / - (= / _)
- Move the column's display position
- L
- Freeze this column and every column up to it at the left edge; on a column
already frozen, pull the boundary back
- v
- Show or hide the column (it keeps its place, dimmed)
- < / > (, / .)
- Make the column 4 cells narrower or wider. A number column is never
narrower than its numbers
- f
- Fit the column to the rows on screen, its name up to the automatic
limit
- w
- Back to the automatic width
- C
- Clear the staged sort, order, locks, hidden columns and widths
Filter editor
- (type)
- Narrow the column or operator list. The operators are those the column's
type takes
- Enter
- Pick the column (type to narrow, Enter chooses), the operator the same
way, then type the value and Enter saves the row. Tab and → also
choose at the column and operator steps, and so does Space until typing
narrows the list (then it types a space); Shift+Tab steps back; ↑ /
↓ move in the lists
- Esc
- End the edit, and only the edit
p at the table: the form on the left, a live preview of the
result on the right (above and below on a narrow terminal).
Form
- Tab / Shift+Tab (↑
/ ↓)
- Next or previous field, wrapping; a field the form does not offer right
now is skipped. The arrows move from the moment the builder opens
- ← / →
- On the first row: switch Pivot and Melt. On the aggregation, strategy or
type: the previous or next value. On a single column row: the previous or
next column. In a text field: move the cursor. h/l too, outside text
fields. The preview follows each change
- Space
- On a column row: open its picker, scoped to that row; typing narrows it.
On a choice: its next value, wrapping
- Enter
- Apply the reshape the preview shows, to the whole view, from any
field
- Esc
- Close without applying; while a pivot is computed, stop it and keep the
builder
Picker
- (type)
- Narrow the column list
- ↑ / ↓
- Move; typing narrows
- Enter
- Choose; on a several-choice row, done
- Space
- Choose, until typing narrows the list (then it types a space). On a
several-choice row: toggle a column in or out
- Esc
- Back out of the picker; the toggles made since it opened are undone (Enter
keeps them)
c at the table: a chart chosen from the cursor column's
type.
Shelves
- 1-7
- Switch the chart type: Line, Scatter, Bar, Histogram, Box, KDE, Heatmap ([
/ ] step). The shelves keep what the new type takes. On Rows, digits type
a sample size instead
- [ / ]
- Previous or next chart type
- Tab / Shift+Tab (↑
/ ↓)
- Next or previous row of the panel, wrapping (j/k too). A shelf the type
does not use is dimmed and skipped
- Space /
Enter
- On X, Y or Color: open its picker. On the line under Color: pick the
values that get a series, by rows. On an option: toggle it or take its
next value. The panel applies as it changes, so Enter acts as Space does,
except on Rows: Space switches between Sample and Every row, and Enter
reads what the row says
- ← / → (h/l)
- Step the type, the time bucket (day, week, month, quarter, year), the
aggregate (count, distinct, sum, mean, median, stdev, quantile, min, max,
first, last) and a quantile's percentile, cumulative, bins, range or
order; on Smooth, the window of a line's moving average (trailing mean),
to show its trend through noisy readings (off, then lengths of time over a
time X or numbers of points over any other, sized to the data); on raw
under it, whether the raw line is drawn faintly behind (auto: with one
series; on; off); on a scatter's Trend, the line fitted through the points
(off, linear, exponential, power, robust, local, y = x; a time X offers
neither power nor y = x); on over under it, one fit per color or one over
every point; on X under Log scale, a log axis for a number X; on Rows,
switch between Sample and Every row (read on Enter); on a shelf that takes
one column, or Color, the previous or next column (Color takes it alone);
on the line under Color, turn Other (every value without a series) on or
off; flip a toggle
- + / -
- Bins or bandwidth
- 0-9
- On Rows: type a sample size, like 50000, 50,000, 50k, 250k or 2m.
Backspace edits, Enter reads it, Esc puts the row back as it was. A size
of at least the table's rows is Every row. Nothing is read until Enter or
focus leaves the row
- g
- Grid on or off at the labeled ticks: Line, Scatter, Histogram, Box and
KDE. [analysis] chart_grid sets where it starts
- Esc
- Back to the table; on Rows with a change waiting, put the row back
first
Plot
- x
- Line and Scatter: the plot takes the keys, and a crosshair reads out x and
every series' value under the plot. ← / → (h/l) step to the
next point or column, Home/End go to the ends; x, Tab or Esc hand the keys
back to the panel. A click on the plot puts the crosshair there
- y
- Scatter with a trend: copy the method, the chart's columns and notes, and
for each fit its equation, slope, R squared with r and p, Spearman
ρ, residual SD and the points used, as plain text. While the fit
runs, a note says it is still fitting
- e
- Export the chart to PNG, SVG or PDF, with a title, notes and source. Needs
the chart's shelves filled first
- t
- While following a file, draw again with the rows that arrived since; the
footer says how many
Crosshair
- ← / →
- Move the crosshair along the plot
- Tab
- Back to the panel, the crosshair kept
- Esc
- The crosshair off, back to the panel
Picker
- ↑ / ↓
- Move; typing narrows
- Enter /
Space
- Choose; on a line or scatter chart's Y, on Color and on the Color values,
Space toggles one in or out (Y and the values up to 10, fewer on a
terminal of fewer colors; Color's columns in the order picked, a series
per combination of their values). Elsewhere Space chooses until typing
narrows the list, then types a space
- Tab /
Shift+Tab
- Choose and move to the next or previous row
- Esc
- Back out of the picker alone
Export dialog
- Tab / Shift+Tab
(↑ / ↓)
- Next or previous field: Path, Format, Style, Size, Width, Height, Legend,
the marks (Opacity and Point size for a scatter, Line width for a line, Y
from zero for a line), Title, Description, Notes, Source, Byline,
Recipe
- ← / →
- Step the format (PNG, SVG, PDF), the style (Light, Dark, Transparent), the
size (Slide 16:9, Document, Square, Single column, Double column, Custom),
the legend (line ends, below, a corner, off), a scatter's point opacity
(Auto, 100%, 50%, 20%) and size (Small, Medium, Large), a line's width
(Thin, Normal, Bold), Y from zero, or the recipe (Include, Omit). Typing a
width or height makes the size Custom
- Ctrl+P /
Ctrl+N
- Earlier or later paths in the path field
- Enter
- Export, from anywhere in the dialog. A path ending .png, .svg or .pdf
takes that format; any other gets the format's extension after it. An
existing file asks Overwrite / No, starting on No; ←/→ (h/l)
or Tab pick, Enter confirms, and declining returns to the filled
dialog
- Esc
- Back to the chart
a at the table.
Explore
- Tab /
Shift+Tab
- Between the results and the tools
- ↑ / ↓ (j/k)
- Rows, or the sidebar's tools
- ← / → (h/l)
- Scroll the statistics; the header counts those out of view
- Home / End
- First or last row
- PgUp /
PgDn
- A page
- Enter
- Open the sidebar's tool and move into its pane. The first run on a dataset
starts in the Sample form, where Enter runs it; later tools reuse that
sample. Results last until the view changes: closing and reopening shows
them again
- Esc
- Cancel a run in progress; otherwise from the results back to the tools,
and from the tools close the analysis view
Sample
- s
- Choose the sample every tool reads: which rows, how they are picked, how
many (typed, like 50000, 50k or 2m), the seed. Enter applies the form
- v
- View the sample's rows as a table; Esc comes back
- r
- Draw another sample (when the result is a sample)
- a
- Read every row instead, after confirming
- t
- While following a file, read again with the rows that arrived since the
results were read
Distribution in the Analysis sidebar.
Explore
- ↑ / ↓ (j/k)
- Rows, or the sidebar's tools
- ← / → (h/l)
- Scroll the statistics; the header counts those out of view
- Home / End
- First or last row
- PgUp /
PgDn
- A page
- Tab /
Shift+Tab
- Between the results and the tools
- Enter
- Open the selected column's detail, a Q-Q plot and a histogram; with the
sidebar focused, open a tool
- o / O
- Filter the table to the selected column's outliers (o) or to the rest (O),
and move the column cursor to it. o adds column outside LOW..HIGH in the
Sort & Filter sidebar, beside the filters in effect; O adds column
between LOW..HIGH. When the sample found outliers on one side only, the
filter is one-sided: column < LOW or column >= LOW (column > HIGH
or column <= HIGH). LOW and HIGH are the nearer of the IQR fences and
three standard deviations on each side, from the sample, rounded outward
to four significant digits of the range. Pressed again on the column while
its filter is unedited, o or O replaces that filter by the same LOW and
HIGH, so the two flip between the halves. Infinities and NaN, which sorts
above every number, count as past the ends; nulls are in neither half
- Esc
- Cancel a run in progress; otherwise from the results back to the tools,
and from the tools close the analysis view
Sample
- s
- Choose the sample every tool reads: which rows, how they are picked, how
many (typed, like 50000, 50k or 2m), the seed. Enter applies the form
- v
- View the sample's rows as a table; Esc comes back
- r
- Draw another sample (when the result is a sample)
- a
- Read every row instead, after confirming
- t
- While following a file, read again with the rows that arrived since the
results were read
Enter on a column in Distribution.
Detail
- ↑ / ↓ (j/k)
- Compare the values with another family
- Home / End
- The first or last family
- s
- Histogram scale: linear or log
- o / O
- Filter the table to the selected column's outliers (o) or to the rest (O),
and move the column cursor to it. o adds column outside LOW..HIGH in the
Sort & Filter sidebar, beside the filters in effect; O adds column
between LOW..HIGH. When the sample found outliers on one side only, the
filter is one-sided: column < LOW or column >= LOW (column > HIGH
or column <= HIGH). LOW and HIGH are the nearer of the IQR fences and
three standard deviations on each side, from the sample, rounded outward
to four significant digits of the range. Pressed again on the column while
its filter is unedited, o or O replaces that filter by the same LOW and
HIGH, so the two flip between the halves. Infinities and NaN, which sorts
above every number, count as past the ends; nulls are in neither half
- Esc
- Back to the distribution table
Correlation Matrix in the Analysis sidebar.
Explore
- Tab /
Shift+Tab
- Between the matrix and the tools
- ↑ / ↓ (j/k)
- Matrix rows, or the sidebar's tools
- ← / → (h/l)
- Matrix columns
- Home /
End
- Jump to the first pair (the first row's second column) or the last (the
last row's next-to-last column); the matrix opens on the first
- PgUp /
PgDn
- A page
- Enter
- On a cell, open the pair's detail; in the sidebar, open a tool. Does
nothing on a diagonal cell
- c
- On a cell off the diagonal, chart the pair as a scatter (X the cell's
column, Y its row) with a linear trend; Esc from the chart comes back
here
- m
- Method: Pearson r or Spearman ρ, named in the title (one run
computes both, so switching reads nothing)
- Esc
- Cancel a run in progress; otherwise from the matrix back to the tools, and
from the tools close the analysis view
Sample
- s
- Choose the sample every tool reads: which rows, how they are picked, how
many (typed, like 50000, 50k or 2m), the seed. Enter applies the form
- v
- View the sample's rows as a table; Esc comes back
- r
- Draw another sample (when the result is a sample)
- a
- Read every row instead, after confirming
- t
- While following a file, read again with the rows that arrived since the
results were read
Enter on a pair in the correlation matrix.
Detail
- m
- Pearson or Spearman
- c
- Scatter the pair with a linear trend
- Esc
- Return to the correlation matrix. Resampling (r) works from the matrix,
not from inside this detail
Data Quality in the Analysis sidebar.
Setup
- ↑ / ↓, Tab
- Move between rows
- ← / →
- Change a short list's choice
- Space
- Open the row: the Sample form, a list (type to narrow; Enter chooses, and
Space until typing narrows it), Time roles, Intervals, Column intent or
Expected
- s
- The Sample form; its Enter applies to Setup and returns there
- p
- The access plan: what a run reads
- d
- Release the rows runs kept and a full scan's local copy, named on the Read
rule; the next run that would reuse them reads again
- Enter
- Run, from any row. A full read asks first; the report on screen or in the
session cache is shown, not read again
- Esc
- Discard every staged edit
Setup lists
- ↑ / ↓
- Time roles: choose the role. Intervals: choose the pair. Column intent:
choose the column. Expected: Windows, From, Before (Tab too)
- ← / →
- Time roles: choose the role's column. Expected: choose the windows.
Intervals: measure the pair or not
- Space
- Intervals: measure the pair or not. Column intent: declare the column's
intent in a form
- Enter
- Done
- Esc
- Put the list back as it was
Forms
- Tab /
Shift+Tab
- Next or previous field
- ← / →
- Change the field's choice
- Space
- Toggle a checkbox
- Enter
- Apply the form; export the report
- Esc
- Close the form unchanged
Popups
- ↑ / ↓
- Scroll a popup, or move in its list
- (type)
- Narrow a popup's list
- Enter
- Close a popup, or act on what it shows: a finding's rows (shown when the
run kept them, else read), its checks all or fewer, a list's choice
- Esc
- Close a popup or a list unchanged
Report
- ← / → (h/l)
- Previous or next page
- 1 - 5
- Overview, Columns, Segments, Trends, Intervals
- ↑ / ↓ (j/k)
- Move, or scroll a tall finding
- PgUp /
PgDn
- Page; Home/End jump to either end
- Enter
- Open a finding, then its rows. On an empty page, open the setting it
needs
- c / t
- Overview: only one column's or one type's findings
- o
- Overview: ranked, by rows, by rate
- e
- Setup
- s
- Setup, with the Sample form open
- v
- View the sample's rows; Esc returns
- p
- The access plan: what a run reads
- r
- On a sample, run again with a new seed
- x
- Export the report to JSON or Markdown; nothing is read
- Tab /
Shift+Tab
- Between the result and the tools
- Esc
- Back one level: all findings again, then the tools, then close
Segments
- Enter
- A segment's columns beside the one it is compared with, largest change
first
- o
- Largest change first, or back in order
- b
- Compare with the highlighted segment
Trends
- Enter
- A line's bars: span, segments, rows sampled of counted, rate, 95%
interval, and the bar before. ↑ / ↓ there: the next bar
- m
- Next measure
- w
- Stage a coarser window in Setup, for segments the sample reached thinly or
not at all
- g
- The expected windows with no rows: empty by exact count, not sampled, or
out of scope
- Esc
- Back to Trends
Intervals
- Enter
- An interval's detail: its ends, the rows with both, missing and unread
ends, negative and zero durations, percentiles and breaches. Enter there
shows the rows behind the count under the cursor: a sample's from the rows
the run kept
- Esc
- Back to the list
e at the table.
Form
- Tab / Shift+Tab
(↑ / ↓)
- Next or previous field, wrapping; the fields follow the format. The dialog
opens on Path, and the arrows move from there
- ← / →
- On Format or Compression: the previous or next value, along the Format row
(h/l too). On Header or Source file: toggle. In Path and Delimiter: move
the cursor
- Space
- Toggle a checkbox (Header, Source file); on Format or Compression, the
next value, wrapping
- Ctrl+P /
Ctrl+N
- In the path field: the paths exported to before, earlier or later
(↑ and ↓ move between fields)
- Enter
- Export, from anywhere in the form. On a blank path the form says
"Enter a file path." instead of exporting
- Esc
- Close without exporting
File exists
- ← / → (h/l)
- Pick Overwrite or No (Tab too)
- Enter
- Confirm the one picked
- Esc
- Decline: back to the filled form
y at the table.
Form
- Tab / Shift+Tab
(↑ / ↓)
- Next or previous row
- ← / →
- The previous or next scope, column or format (h/l too); on Header:
toggle
- Space
- On Scope or Format: the next value, wrapping. On Column: open its picker.
On Header: toggle
- Enter
- Copy, from anywhere in the form. On the Cell scope with no column picked,
Enter copies nothing and shows pick a column to copy in the warning
color
- Esc
- Close a picker, then the dialog, without copying
Picker
- (type)
- Narrow the list
- ↑ / ↓
- Move the cursor (in the picker, j and k type; only ↑ / ↓
move)
- Enter /
Space
- Choose. Space chooses until typing narrows the list, then types a space,
so a name of several words narrows
- Tab /
Shift+Tab
- Choose and move on
- Esc
- Back to the form, the choice unchanged
v at the table.
List
- ↑ / ↓ (j/k)
- Move in the list
- Enter
- Apply the selected view
- s
- Save the current state as a view (an untouched table has nothing to save,
and s says so)
- e
- Edit the selected view
- d
- Delete the selected view, after confirming
- i
- Show how the selected view's score was computed (Esc closes the score
view)
- Esc
- Close
Save and edit
- Tab / Shift+Tab
(↑ / ↓)
- Next or previous row. In the description ↑ / ↓ move between
its lines, and leave it from the first or last
- Enter
- Save, from any row. In the description Enter types: Ctrl+J saves from
there
- Ctrl+J
- Save from anywhere, the description included; so does Ctrl+Enter, on a
terminal that tells it from Enter
- PgUp /
PgDn
- Five lines in the description
- Space
- Expand or collapse Matching; toggle schema match
- Esc
- Back to the list, discarding edits
Delete
- ← / → (h/l)
- Pick Delete or No (Tab too); it starts on No
- Enter
- Confirm the one picked
- Esc
- Keep the view
b at a table read through a format spec.
Pick
- (type)
- Narrow to the names that contain it
- ↑ / ↓
- Move
- Enter /
Space
- Read the file again with the spec chosen. The query, filters and sort are
cleared
- Backspace
- Delete a character (Ctrl+W a word, Ctrl+U all)
- Esc
- Close and keep the format
Enter on the Info panel's Schema tab, or Change type in the
cell menu.
Pick
- (type)
- Narrow the list to the names that contain it. In the format list, a
strftime format typed that no line holds is the format
- ↑ / ↓
- Move
- Enter
- Apply the type: the column is read as it at once, and a value that does
not fit becomes null. A date, time or datetime asks for its format next,
each line showing what it makes of the column's first value. as read
removes the type
- Backspace
- Delete a character (Ctrl+W a word, Ctrl+U all)
- Esc
- Back to the types, or close
Combine into datetime in the cell menu, on a text, date or time
column.
Fields
- Tab / Shift+Tab
(↑ / ↓)
- Next or previous field
- Space
- Pick a column, or step the kind
- ← / →
- Step the kind: datetime, date or time
- Enter
- Make the column, placed after the last column it is made from, as a format
spec's derived column is. A date, a time and a UTC offset make a datetime
in UTC
- Esc
- Cancel
Picker
- (type)
- Narrow to the columns that contain it
- ↑ / ↓
- Move
- Enter
- Choose the column
- Esc
- Back to the fields, the choice unchanged
T at a table from a file of several tables.
Pick
- (type)
- Narrow to the names that contain it
- ↑ / ↓
- Move
- Enter
- Open the table chosen in place of this one. The query, filters and sort
are cleared
- Backspace
- Delete a character (Ctrl+W a word, Ctrl+U all)
- Esc
- Close and keep the table
S at the table.
Form
- Tab / Shift+Tab
(↑ / ↓)
- Next or previous row
- ← / →
- Step Rows from, Method and Per value of; Method's No sample takes the
view's sample away
- (type)
- Type into the focused row: the size (50000, 50k, 2m), the seed, a row
range, partition values or file numbers
- PgUp /
PgDn
- Page through the files, where there are many
- Enter
- Draw the sample: the table shows its rows as they arrive, and the query,
filters and sort run over them. When the estimate is more than the memory
available now (or analysis.sample_memory_limit), the form says so; Enter
again draws anyway
- Esc
- Close; the view's sample stays as it was
datui --hex FILE, Ctrl+X on the home screen,
or x in the Info panel.
Explore
- ← / → (h/l)
- A byte
- ↑ / ↓ (j/k)
- A row
- w / b
- The next group of four, or back one
- 0 / $
- The start or end of the row
- g / G
- The start or end of the file (Home and End too)
- PgUp /
PgDn
- A page (Ctrl+B/F too; Ctrl+U/D half a page)
- :
- Go to an offset: 4096 or 0x1000; +16 or -16 from the cursor; e-8 for the
eighth byte from the end
Find
- f
- Find bytes. Text is found as its UTF-8 bytes (Ctrl+U in the prompt: as
UTF-16 little-endian). 0x1acffc1d, or two or more hex pairs (de ad be ef),
is a byte pattern, where ?? matches any byte. Text in double quotes is
text, even when it looks like hex. A match may span rows
- n / N
- The next or previous match, wrapping around the end of the file
- R
- When the matches after the one found are all the same distance apart, make
that the bytes per row
- Esc
- Stop a find that is reading
Prompt
- Enter
- Find, go to the offset or set the row size
- Ctrl+U
- Find the text as UTF-16 as well
- Esc
- Close the prompt
Display
- r
- Bytes per row, so that records line up; empty goes back to as many as fit.
--hex-width N sets it on the command line
- #
- Offsets in decimal or hex
- i / Enter
- Show or hide the byte inspector. It sits beside the bytes when there is
room and a row holds 16 bytes, and over them otherwise
- v
- Mark from the cursor; move to mark a range, and the status line counts it.
v again, or Esc, unmarks
Go
- B
- Read the file with a format spec instead: type to narrow the list of
specs; Enter chooses, and Space until typing narrows it
- Esc
- Back to the table, when opened from the Info panel; back home, when opened
from there
- q
- Home, when opened from there; else quit
The keys of every screen, as a manual page.
datui(1)
The datui documentation:
<https://derekwisong.github.io/datui/>
Report bugs at
<https://github.com/derekwisong/datui/issues>.
Derek Wisong and the datui contributors.
Copyright © 2026 Derek Wisong
datui is free software under the MIT License.