This is an old revision of the document!

Analyzing PG&E data with VisiData

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:

  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 rate`
. or g.	Select columns to graph them. Notice rate changes. Notice times of high use.
+, -	Navigate with hjkl, zoom in and out (more)