REPLAY MODE¶

-p, --play=cmdlog

replay a saved cmdlog within the interface

-w, --replay-wait=seconds

wait seconds between commands

-b, --batch

replay in batch mode (with no interface)

-o, --output=file

save final visible sheet to file as .tsv

--replay-movement

toggle --play to move cursor cell-by-cell

field=value

replace "{field}" in cmdlog contents with value

Commands During Replay¶

GLOBAL COMMANDS¶

All keystrokes are case sensitive. The ^ prefix is shorthand for Ctrl.

Keystrokes to start off with¶

^Q

abort program immediately

^C

cancel user input or abort all async threads on current sheet

g^C

abort all secondary threads

q

quit current sheet

gq

quit all sheets (clean exit)

^H

view this man page

z^H

view sheet of command longnames and keybindings

Space longname

execute command by its longname

U

undo the most recent modification (requires enabled options.undo)

R

redo the most recent undo (requires enabled options.undo)

Cursor Movement¶

Arrow PgUp Home

go as expected

h j k l

go left/down/up/right

gh gj gk gl

go all the way to the left/bottom/top/right of sheet

G gg

go all the way to the bottom/top of sheet

^B ^F

scroll one page back/forward

zz

scroll current row to center of screen

^^ (Ctrl+^)

jump to previous sheet (swaps with current sheet)

/ ? regex

search for regex forward/backward in current column

g/ g? regex

search for regex forward/backward over all visible columns

z/ z? expr

search by Python expr forward/backward in current column (with column names as variables)

n N

go to next/previous match from last regex search

< >

go up/down current column to next value

z< z>

go up/down current column to next null value

{ }

go up/down current column to next selected row

c regex

go to next column with name matching regex

r regex

go to next row with key matching regex

zc zr number

go to column/row number (0-based)

H J K L

slide current row/column left/down/up/right

gH gJ gK gL

slide current row/column all the way to the left/bottom/top/right of sheet

zH zJ zK zK number

slide current row/column number positions to the left/down/up/right

zh zj zk zl

scroll one left/down/up/right

Column Manipulation¶

_ (underscore)

toggle width of current column between full and default width

g_

toggle widths of all visible columns between full and default width

z_ number

adjust width of current column to number

gz_ number

adjust widths of all visible columns to Ar number

- (hyphen)

hide current column

z-

reduce width of current column by half

gv

unhide all columns

! z!

toggle/unset current column as a key column

~ # % $ @ z#

set type of current column to str/int/float/currency/date/len

^

edit name of current column

g^

set names of all unnamed visible columns to contents of selected rows (or current row)

z^

set name of current column to combined contents of current cell in selected rows (or current row)

gz^

set name of all visible columns to combined contents of current column for selected rows (or current row)

= expr

create new column from Python expr, with column names, and attributes, as variables

g= expr

set current column for selected rows to result of Python expr

gz= expr

set current column for selected rows to the items in result of Python sequence expr

z= expr

evaluate Python expression on current row and set current cell with result of Python expr

i (iota)

add column with incremental values

gi

set current column for selected rows to incremental values

zi step

add column with values at increment step

gzi step

set current column for selected rows at increment step

' (tick)

add a frozen copy of current column with all cells evaluated

g'

open a frozen copy of current sheet with all visible columns evaluated

z' gz'

add/reset cache for current/all visible column(s)

: regex

add new columns from regex split; number of columns determined by example row at cursor

; regex

add new columns from capture groups of regex (also requires example row)

z; expr

create new column from bash expr, with $columnNames as variables

* regex/subst

add column derived from current column, replacing regex with subst (may include \1 backrefs)

g* gz* regex/subst

modify selected rows in current/all visible column(s), replacing regex with subst (may include \1 backrefs)

( g(

expand current/all visible column(s) of lists (e.g. [3]) or dicts (e.g. {3}) fully

z( gz( depth

expand current/all visible column(s) of lists (e.g. [3]) or dicts (e.g. {3}) to given depth (0= fully)

)

unexpand current column; restore original column and remove other columns at this level

zM

row-wise expand current column of lists (e.g. [3]) or dicts (e.g. {3}) within that column

Row Selection¶

s t u

select/toggle/unselect current row

gs gt gu

select/toggle/unselect all rows

zs zt zu

select/toggle/unselect all rows from top to cursor

gzs gzt gzu

select/toggle/unselect all rows from cursor to bottom

| \ regex

select/unselect rows matching regex in current column

g| g\ regex

select/unselect rows matching regex in any visible column

z| z\ expr

select/unselect rows matching Python expr in any visible column

, (comma)

select rows matching display value of current cell in current column

g,

select rows matching display value of current row in all visible columns

z, gz,

select rows matching typed value of current cell/row in current column/all visible columns

Row Sorting/Filtering¶

[ ]

sort ascending/descending by current column; replace any existing sort criteria

g[ g]

sort ascending/descending by all key columns; replace any existing sort criteria

z[ z]

sort ascending/descending by current column; add to existing sort criteria

gz[ gz]

sort ascending/descending by all key columns; add to existing sort criteria

"

open duplicate sheet with only selected rows

g"

open duplicate sheet with all rows

gz"

open duplicate sheet with deepcopy of selected rows

Editing Rows and Cells¶

a za

append a blank row/column; appended columns cannot be copied to clipboard

ga gza number

append number blank rows/columns

d gd

delete (cut) current/selected row(s) and move to clipboard

y gy

yank (copy) current/all selected row(s) to clipboard

zy gzy

yank (copy) contents of current column for current/selected row(s) to clipboard

zd gzd

delete (cut) contents of current column for current/selected row(s) and move to clipboard

p P

paste clipboard rows after/before current row

zp gzp

set cells of current column for current/selected row(s) to last clipboard value

Y gY

yank (copy) current/all selected row(s) to system clipboard (using options.clipboard_copy_cmd)

zY gzY

yank (copy) contents of current column for current/selected row(s) to system clipboard (using options.clipboard_copy_cmd)

f

fill null cells in current column with contents of non-null cells up the current column

e text

edit contents of current cell

ge text

set contents of current column for selected rows to text

Commands While Editing Input¶

Data Toolkit¶

o input

open input in VisiData

^S g^S filename

save current/all sheet(s) to filename in format determined by extension (default .tsv)

Note: if the format does not support multisave, or the filename ends in a /, a directory will be created.

z^S filename

save current column only to filename in format determined by extension (default .tsv)

^D filename.vd

save CommandLog to filename.vd file

A

open new blank sheet with one column

T

open new sheet that has rows and columns of current sheet transposed

+ aggregator

add aggregator to current column (see Frequency Table)

z+ aggregator

display result of aggregator over values in selected rows for current column

&

concatenate top two sheets in Sheets Stack

g&

concatenate all sheets in Sheets Stack

Data Visualization¶

. (dot)

plot current numeric column vs key columns. The numeric key column is used for the x-axis; categorical key column values determine color.

g.

plot a graph of all visible numeric columns vs key columns.

If rows on the current sheet represent plottable coordinates (as in .shp or vector .mbtiles sources), . plots the current row, and g. plots all selected rows (or all rows if none selected).

Canvas-specific Commands¶

Split Screen¶

Z

split screen in half, so that second sheet on the stack is visible in a second pane

zZ

split screen, and queries for height of second pane

Split Window specific Commands¶

Other Commands¶

Q

quit current sheet and remove it from the CommandLog

v

toggle sheet-specific visibility (multi-line rows on Sheet, legends/axes on Graph)

^E g^E

view traceback for most recent error(s)

z^E

view traceback for error in current cell

^L

refresh screen

^R

reload current sheet

z^R

clear cache for current column

^Z

suspend VisiData process

^G

show cursor position and bounds of current sheet on status line

^V

show version and copyright information on status line

^P

open Status History

m keystroke

first, begin recording macro; second, prompt for keystroke No, and complete recording. Macro can then be executed everytime provided keystroke is used. Will override existing keybinding. Macros will run on current row, column, sheet.

gm

open an index of all existing macros. Can be directly viewed with Enter, and then modified with ^S.

^Y z^Y g^Y

open current row/cell/sheet as Python object

^X expr

evaluate Python expr and opens result as Python object

z^X expr

evaluate Python expr, in context of current row, and open result as Python object

g^X stmt

execute Python stmt in the global scope

Internal Sheets List¶

.

VisiDataMenu (Shift+V) browse list of core sheets

.

Directory Sheet browse properties of files in a directory

.

Plugins Sheet browse, install, and (de)activate plugins

 

Metasheets

 

.

Columns Sheet (Shift+C) edit column properties

.

Sheets Sheet (Shift+S) jump between sheets or join them together

.

Options Sheet (Shift+O) edit configuration options

.

Commandlog (Shift+D) modify and save commands for replay

.

Error Sheet (Ctrl+E) view last error

.

Status History (Ctrl+P) view history of status messages

.

Threads Sheet (Ctrl+T) view, cancel, and profile asynchronous threads

Derived Sheets

 

.

Frequency Table (Shift+F) group rows by column value, with aggregations of other columns

.

Describe Sheet (Shift+I) view summary statistics for each column

.

Pivot Table (Shift+W) group rows by key and summarize current column

.

Melted Sheet (Shift+M) unpivot non-key columns into variable/value columns

.

Transposed Sheet (Shift+T) open new sheet with rows and columns transposed

INTERNAL SHEETS¶

VisiDataMenu (Shift+V)¶

(sheet-specific commands)

Directory Sheet¶

(global commands)

(sheet-specific commands)

Plugins Sheet¶

Browse through a list of available plugins. VisiData needs to be restarted before plugin activation takes effect. Installation may require internet access.

(global commands)

(sheet-specific commands)

METASHEETS¶

Columns Sheet (Shift+C)¶

Properties of columns on the source sheet can be changed with standard editing commands (e ge g= Del) on the Columns Sheet. Multiple aggregators can be set by listing them (separated by spaces) in the aggregators column. The 'g' commands affect the selected rows, which are the literal columns on the source sheet.

(global commands)

(sheet-specific commands)

Sheets Sheet (Shift+S)¶

open Sheets Stack, which contains only the active sheets on the current stack

(global commands)

(sheet-specific commands)

Options Sheet (Shift+O)¶

(global commands)

(sheet-specific commands)

CommandLog (Shift+D)¶

(global commands)

(sheet-specific commands)

DERIVED SHEETS¶

Frequency Table (Shift+F)¶

A Frequency Table groups rows by one or more columns, and includes summary columns for those with aggregators.

(global commands)

(sheet-specific commands)

Describe Sheet (Shift+I)¶

A Describe Sheet contains descriptive statistics for all visible columns.

(global commands)

(sheet-specific commands)

Pivot Table (Shift+W)¶

Set key column(s) and aggregators on column(s) before pressing Shift+W on the column to pivot.

(sheet-specific commands)

Melted Sheet (Shift+M)¶

Open Melted Sheet (unpivot), with key columns retained and all non-key columns reduced to Variable-Value rows.

(global commands)

Python Object Sheet (^X ^Y g^Y z^Y)¶

(sheet-specific commands)

DISPLAY OPTIONS¶

Display options can only be set via the Options Sheet or a .visidatarc (see FILES).

disp_splitwin_pct 0

height of second sheet on screen

disp_currency_fmt %.02f

default fmtstr to format for currency values

disp_float_fmt {:.02f}

default fmtstr to format for float values

disp_int_fmt {:.0f}

default fmtstr to format for int values

disp_date_fmt %Y-%m-%d

default fmtstr to strftime for date values

disp_note_none ⌀

visible contents of a cell whose value is None

disp_truncator …

indicator that the contents are only partially visible

disp_oddspace ·

displayable character for odd whitespace

disp_more_left <

header note indicating more columns to the left

disp_more_right >

header note indicating more columns to the right

disp_error_val

displayed contents for computation exception

disp_ambig_width 1

width to use for unicode chars marked ambiguous

disp_pending

string to display in pending cells

color_note_pending bold magenta

color of note in pending cells

color_note_type 226 yellow

color of cell note for non-str types in anytype columns

color_note_row 220 yellow

color of row note on left edge

disp_column_sep |

separator between columns

disp_keycol_sep ║

separator between key columns and rest of columns

disp_rowtop_sep |

disp_rowmid_sep ⁝

disp_rowbot_sep ⁝

disp_rowend_sep ║

disp_keytop_sep ║

disp_keymid_sep ║

disp_keybot_sep ║

disp_endtop_sep ║

disp_endmid_sep ║

disp_endbot_sep ║

disp_selected_note •

disp_sort_asc ↑↟⇞⇡⇧⇑

characters for ascending sort

disp_sort_desc ↓↡⇟⇣⇩⇓

characters for descending sort

color_default normal

the default color

color_default_hdr bold

color of the column headers

color_bottom_hdr underline

color of the bottom header row

color_current_row reverse

color of the cursor row

color_current_col bold

color of the cursor column

color_current_hdr bold reverse

color of the header for the cursor column

color_column_sep 246 blue

color of column separators

color_key_col 81 cyan

color of key columns

color_hidden_col 8

color of hidden columns on metasheets

color_selected_row 215 yellow

color of selected rows

disp_rstatus_fmt {sheet.longname} {sheet.nRows:9d} {sheet.rowtype}

right-side status format string

disp_status_fmt {sheet.shortcut}› {sheet.name}|

status line prefix

disp_lstatus_max 0

maximum length of left status line

disp_status_sep |

separator between statuses

color_keystrokes white

color of input keystrokes on status line

color_status bold

status line color

color_error red

error message color

color_warning yellow

warning message color

color_top_status underline

top window status bar color

color_active_status bold

active window status bar color

color_inactive_status 8

inactive window status bar color

color_working green

color of system running smoothly

color_edit_cell normal

cell color to use when editing cell

disp_edit_fill _

edit field fill character

disp_unprintable ·

substitute character for unprintables

disp_histogram *

histogram element character

disp_histolen 50

width of histogram column

disp_replay_play ▶

status indicator for active replay

disp_replay_pause ‖

status indicator for paused replay

color_status_replay green

color of replay status indicator

disp_pixel_random False

randomly choose attr from set of pixels instead of most common

color_graph_hidden 238 blue

color of legend for hidden attribute

color_graph_selected bold

color of selected graph points

color_graph_axis bold

color for graph axis labels

color_add_pending green

color for rows pending add

color_change_pending reverse yellow

color for cells pending modification

color_delete_pending red

color for rows pending delete

color_xword_active green

color of active clue