Differences

This shows you the differences between two versions of the page.

--- vd-pge [2021/08/10 12:01] – dblume
+++ vd-pge [2021/08/10 16:55] – [Select Rows to Analyze] dblume
@@ Line 1: / Line 1: @@
 ====== Analyzing PG&E data with VisiData ======
-At the PG&E website, you can download a CSV table of your energy usage. Click "Energy Usage Details" and then the "Green Button" to download your data.
+At the PG&E website, you can download a CSV table of your energy usage. Click "Energy Usage Details" and then the "Green Button" at their site to download your data.
 {{:general:vd-pge-green-button.png?direct|}}
@@ Line 59: / Line 59: @@
 ===== Select Rows to Analyze =====
+Directly selecting ranges of rows:
 ^ Key ^ Meaning ^
-| %%|%% | On DATE_START_TIME column, select by regex, like "-11-" for November |
+| s,t,u | Select/toggle/unselect current row. |
-| " | To open a new sheet with just those selected rows. |
+| , | Select all rows matching value of current cell |
-| q | Quit the new sheet mode. |
+| gs,gt,gu | ... all rows |
+| zs,zt,zu | ... from top to cursor |
+| gzs,gzt,gzu | ... from cursor to bottom (Or... ''zs,gt'', one less thing to remember) |
+| " | Open duplicate sheet with only selected rows. |
+Select based on a pattern:
 ^ Key ^ Meaning ^
-| %%z|%% | select rows matching Python expr "DATE_START_TIME [-3:] == '-07'" |
+| %%|%% | On DATE_START_TIME column, select by regex, like "-11-" for November |
+| %%z|%% | Select rows matching Python expr "DATE_START_TIME [-3:] == '-07'" |
 | " | To open a new sheet with just those selected rows. |
-| q | Quit the new sheet mode. |
 ===== Visualize Data =====