Thread of 3 posts
ugh, the pg&e "green button" csv exports are in localtime, so i have to write code to do the dst conversions and handle the skipped/repeated hours
fuck, this library doesn't let me add "1 day" (distinct from "24 hours") to a Timestamp object, does it
figured that out, got it working for the gas usage csv
completely forgot that the gas usage csv is basically useless (day-per-row, and the value has low enough resolution that there's basically 3 values a given day might be rounded to)
now to implement the slightly trickier bit: the electricity usage csvs (which are hour-per-row, and thus need more dst handling)