Many commands can be finetuned to operate on rows which are 'selected'.
||select/toggle/unselect current row|
||select/toggle/unselect all rows|
||select/unselect rows matching regex in current column|
||select/unselect rows matching regex in any visible column|
||select/unselect rows matching Python expr in any visible column|
||select rows matching current cell in current column|
||select rows matching entire current row in all visible columns|
An example usage follows.
t on the rows to filter.
gd to delete the selected rows.
" to open a duplicate sheet with references to the selected rows. Edits performed within the duplicate sheet will also propagate to the source sheet.
gz" to open a duplicate sheet with copies of the selected rows. Any changes will not affect the source sheet.
The following example uses the file sample.tsv.
Question On which days have we sold less than 10 Binders?
Unitscolumn. Set the type of the
Unitscolumn by pressing
Item == 'Binder' and Units < 10to select all of the rows where the
Itemis Binder and the number of
Unitsis less than 10.
"to open a duplicate sheet with only those selected rows.
Rfollowed by the number of rows you wish included in your random population sample.
||move cursor row down/up|
||move cursor row all the way to the bottom/top of sheet|
yto delete/yank the row and move it to the clipboard.
Pto paste the row after/before current row.
ton those rows to select them.
gyto cut/yank all selected rows to the clipboard.
Pto paste those rows after/before current row.
||sorts ascending/descending by current column|
||sorts ascending/descending by all key columns|
[to sort the column from highest to lowest.
]to sort the column chronologically.
!on those columns to designate them as key columns.