Differences

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

--- vd-pge [2021/08/10 11:51] – dblume
+++ vd-pge [2021/08/10 12:02] – [Analyzing PG&E data with VisiData] dblume
@@ Line 1: / Line 1: @@
 ====== 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:
+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|}}
+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 (or with ''tail -n +6'' for older tail):
     tail +6 pge_electric_interval_data.csv | vd -f csv -
@@ Line 71: / Line 75: @@
 | . or g. | Select columns to graph them. Notice rate changes. Notice times of high use. |
 | +, - | Navigate with hjkl, zoom in and out ([[https://www.visidata.org/docs/graph/|more]]) |
+====== Further Resources ======
+I have another tutorial at [[vd]] that merges/joins three CSV tables.