vd
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
vd [2021/06/18 13:02] – dblume | vd [2021/08/06 13:24] – [Case Study: Exported CSV from PG&E] dblume | ||
---|---|---|---|
Line 33: | Line 33: | ||
| , | Select all rows that match this column' | | , | Select all rows that match this column' | ||
| " | Open duplicate sheet with only selected rows | | | " | Open duplicate sheet with only selected rows | | ||
+ | |||
+ | ==== Case Study: Exported CSV from PG&E ==== | ||
+ | |||
+ | PG&E CSVs come with 5 rows of metadata followed by Type, Date, Start Time, End Time, Usage, Units, Cost, Notes columns. Delete the five rows of metadata in a text editor, or use '' | ||
+ | |||
+ | tail +6 pge_electric_interval_data.csv | vd -f csv - | ||
+ | |||
+ | Then prepare your PG&E data like so: | ||
+ | |||
+ | ^ Key ^ Meaning ^ | ||
+ | | - | Hide columns TYPE, END TIME, UNITS and NOTES | | ||
+ | | C | Go to column mode and... | | ||
+ | | t | Select the DATE and START TIME columns | | ||
+ | | & | Make a new column that merges them | | ||
+ | | q, - | Quit the Column mode, hide DATE and START TIME columns | | ||
+ | | O | Go to options mode and... | | ||
+ | | e | Set '' | ||
+ | | q | Quit options mode. | | ||
+ | | @!, %, $ | Set DATE_START_TIME to date format and important, USAGE to float, COST to currency | | ||
+ | | = | Add a column, enter '' | ||
+ | | %%^%% | Rename COST/USAGE to '' | ||
+ | | . or g. | Select columns to graph them. Notice rate changes. Notice times of high use. | | ||
+ | | +, - | Navigate with hjkl, zoom in and out ([[https:// | ||
==== Protip: Use column view to set multiple columns at once ==== | ==== Protip: Use column view to set multiple columns at once ==== |
vd.txt · Last modified: 2023/05/17 14:00 by dblume