![]() Different numbers of key columns cannot match (no partial keys and rollup yet). When sheets are joined, the rows are matched by the display values in the key columns. The current sheet remains until a reload (`Ctrl-R`). `R` sets the source type of the current sheet. `Ctrl-S`ave sheet: the output type is determined by the file extension (currently. `:` regex subst: creates a new column from an expression, a pattern, and a subst template: `:column/(.*)/\1` `=` "add column expression" takes a Python expression as input and appends a new column, which evaluates the The global\_action column on the Help Sheet shows the specific way the global prefix changes each command. ![]() the "`g`lobal prefix": always applies to the next command only, but could mean "apply to all columns" (as with the regex search commands) or "apply to selected rows" (as with `d`elete) or "apply to all sheets" (as with `q`). Here are slightly better descriptions of some non-obvious commands: This sheet can be searched, sorted, and filtered just like any other sheet. `F1` opens the Help Sheet, which shows the available commands along with a brief description. 'open': add a new sheet to the front of the sheets list (thus making it immediately visible) Unknown filetypes are by default viewed with a text If no inputs are given, starts exploring theĬurrent directory. **Remember to install the Python3 versions of these modules with e.g. dateutil.parser (if converting string column to datetime) google-api-python-client (if opening Google Sheets must () cell edits are rejected if they don't convert to the column typeĬopy the bin/vd script to a directory in PATH and make it executable. for commands like sort which require a correctly typed value, the default (0) value for that type is used values that can't be properly converted are flagged with `~` on the display ![]() all values are stored in their original format, and only converted on demand and as needed. columns start out untyped (unless the source data is typed) `!` marks column as a key column (pins to the left and matches on sheet joins) `_` maximizes column width to fit longest value On the `C`olumns sheet, these commands apply to rows (the columns of the source sheet), instead of the columns on the Columns sheet `O`ptions sheet to change the style or behavior `S`heets metasheet to manage/navigate multiple sheets `Ctrl-O` to eval an expression and browse the result as a python object inner/outer/full/diff joins on any number of sheets, matching designated key columns `F`requency table for current column with histogram search/select/unselect/subst by regex in column `hjkl` cursor movement, `t`op/`m`iddle/`b`ottom scroll to position screen cursor ![]() Usable via any remote shell which has Python3 installed. A curses interface for exploring and arranging tabular data ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |