User Tools

Site Tools


vd

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
vd [2021/08/06 13:02]
dblume Added PG&E example
vd [2021/08/09 22:58] (current)
dblume [Case Study: Exported CSV from PG&E]
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 ''tail'' to remove them like so: +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 ''disp_date_fmt'' to ''%Y-%m-%d %H:%M''+
-| q | Quit options mode. | +
-| @!, %, $ | Set DATE_START_TIME to date format and important, USAGE to float, COST to currency | +
-| = | Add a column, enter ''COST/USAGE'', (Make it float with ''%'') | +
-| %%^%% | Rename COST/USAGE to ''kWh cost''+
-| . | Select columns to graph them. Notice rate changes. Notice times of high use|+
  
 ==== Protip: Use column view to set multiple columns at once ==== ==== Protip: Use column view to set multiple columns at once ====
vd.1628280146.txt.gz · Last modified: 2021/08/06 13:02 by dblume