repository·develop·Indexed 27 days ago
https://github.com/saulpw/visidataA terminal-based interface for exploring, arranging, and manipulating tabular data in formats including CSV, JSON, Excel, and SQLite. Documentation covers installation via pip, pipx, and uv; user guides for data loading, navigation, and manipulation; and a developer API reference for building plugins, loaders, and custom sheets. Includes specialized guides for vdsql database interaction and the Galactic Conquest game server.
vgit provides a terminal user interface for several git operations, including:
The documentation provides specific recipes for common data tasks, including:
VisiData loads all installed plugins and internal modules by default. Note the following behaviors:
visidata sqlite loader vs. the vdsql sqlite loader). The last module imported will have its functions registered for the specific filetype or command.VisiData uses braille Unicode characters to display low-resolution terminal graphics. The graphics system is built on a hierarchy of classes that transition from raw terminal pixels to high-level, interactive graphs:
Plotter: A pixel-addressable surface covering the terminal. It uses exact integer (x, y) coordinates.Canvas: A zoomable/scrollable virtual surface on top of a Plotter that uses arbitrary units (floats) for coordinates.InvertedCanvas: A Canvas with an inverted Y-axis (minimum coordinates in the lower-left).Graph: An InvertedCanvas that includes axis labels, legends, and gridlines.Data flows from a Sheet (the source) through a Graph.reload() call, which uses Canvas.polyline() to define what to render, eventually being drawn by the Plotter using braille characters.
VisiData provides extensive documentation for various data manipulation tasks:
loading.md).stdin/stdout pipelines (pipes.md).formats.md)..vd, .vdj, .vdx (command logs) and .vds (sheet state) (internal_formats.md).navigate.md, move.md).menu.md) and mouse interaction (mouse.md).split.md).DirSheet (dirsheet.md).columns.md).rows.md).edit.md).crud.md).group.md).freq.md).join.md)..visidatarc, command bindings, and the Options Sheet (customize.md).macros.md).save-restore.md).colors.md).To sort by multiple columns in a specific priority order, start with the most important column and then add secondary columns using the following commands:
sort_asc_add: Add current column to sort order (ascending)sort_desc_add: Add current column to sort order (descending)sort_keys_asc_add: Add key columns to sort order (ascending)sort_keys_desc_add: Add key columns to sort order (descending)The vgit diff functionality provides several ways to inspect changes:
You can make commands or behaviors configurable by defining options using vd.option. This allows users to modify behavior via the command line or a .visidatarc file.
Use vd.option(name, default, description) to register an option.
disp_hello, use --disp-hello="value"..visidatarc file using the options. prefix.mod_).disp_ for displayed strings and color_ for color options.Frequency Tables allow you to group rows into bins based on column values. This is the VisiData equivalent of a GROUP BY operation. You can use freq_col to create a frequency table for a single column or freq_keys to group by multiple keys simultaneously.
To bin numeric rows into ranges rather than discrete values, use the --numeric-binning option.
Once you have a Frequency Table, you can inspect the specific rows that make up a group:
open_row to view the data.dive_selected to drill down into a group.To navigate or rearrange your split panes:
{help.commands.splitwin_swap}{help.commands.splitwin_swap_pane}