vd-pge
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
vd-pge [2021/08/10 12:02] – [Analyzing PG&E data with VisiData] dblume | vd-pge [2021/08/10 16:55] – [Select Rows to Analyze] dblume | ||
---|---|---|---|
Line 59: | Line 59: | ||
===== Select Rows to Analyze ===== | ===== Select Rows to Analyze ===== | ||
+ | |||
+ | Directly selecting ranges of rows: | ||
^ Key ^ Meaning ^ | ^ Key ^ Meaning ^ | ||
- | | %%|%% | On DATE_START_TIME column, select by regex, like " | + | | s,t,u | Select/ |
- | | " | + | | , | Select all rows matching value of current cell | |
- | | q | Quit the new sheet mode. | | + | | gs, |
+ | | zs,zt,zu | ... from top to cursor | ||
+ | | gzs, | ||
+ | | " | Open duplicate | ||
+ | |||
+ | Select based on a pattern: | ||
^ Key ^ Meaning ^ | ^ Key ^ Meaning ^ | ||
- | | %%z|%% | select rows matching Python expr " | + | | %%|%% | On DATE_START_TIME column, |
+ | | %%z|%% | Select | ||
| " | To open a new sheet with just those selected rows. | | | " | To open a new sheet with just those selected rows. | | ||
- | | q | Quit the new sheet mode. | | + | |
===== Visualize Data ===== | ===== Visualize Data ===== |
vd-pge.txt · Last modified: 2023/04/12 20:44 by 127.0.0.1