vd
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
vd [2021/08/06 13:24] – [Case Study: Exported CSV from PG&E] dblume | vd [2021/08/09 22:58] – [Case Study: Exported CSV from PG&E] dblume | ||
---|---|---|---|
Line 36: | Line 36: | ||
==== Case Study: Exported CSV from PG&E ==== | ==== 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 '' | + | Visit [[vd-pge]]. |
- | + | ||
- | 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