# todo: convert to use circuit_dict_list
if __name__ == '__main__':
import sqlalchemy as sa
import matplotlib.pyplot as plt
import datetime as dt
date_start = dt.datetime(2012, 3, 1)
date_end = dt.datetime(2012, 4, 1)
import offline_gateway as og
circuit_list = og.get_circuit_list()
debug = True
debug = False
if debug:
circuit_list = circuit_list[:1]
# iterate over list of circuits
for c in circuit_list:
filename = 'lpc-' + c[1] + '-' + c[2][-3:] + '.pdf'
print 'querying for', filename
og.plot_load_profile_curve(c[0], date_start, date_end, filename)
import datetime as dt
import pandas as pd
import sqlalchemy as sa
import sys
sys.path.append('/home/mitchell/Documents/SharedSolar/ss_sql_views/python')
import offline_gateway as gw
date_start = '2010-01-01'
date_end = '2013-12-31'
d0 = dt.datetime(2010,1,1,0)
d1 = dt.datetime(2013,12,31,23)
datelist = pd.date_range(d0,d1,freq='1h')
cl = gw.get_circuit_list()
circ_list = []#list of circuit names as strings
circ_dict = {} #dictionary circuit name string as key, with number equavilent
wh_DF = pd.DataFrame(index = datelist)
cred_DF = pd.DataFrame(index = datelist)
# Populate the list of all circuits and mains
# AND populate dictionary to translate string name to number name
for ix, row in enumerate(cl):
circ_list.append(row[1].encode('ascii')+'_'+str(int(row[2][-2:])))
circ_dict[circ_list[ix]] = row[0]
# Create a DataFrame of Wh for each main or site
for ix, row in enumerate(circ_list):
wh_col = gw.get_watthours_for_circuit_id(circ_dict[row], date_start, date_end)[0].apply(np.float32)
wh_col.resample('H', how = np.max) # resample options sum, mean, std, max, min, median, first, last, ohlc.
plot hourly power
'''
import sqlalchemy as sa
import matplotlib.pyplot as plt
import datetime as dt
date_start = dt.datetime(2012, 2, 14)
date_end = dt.datetime(2012, 3, 1)
if __name__ == '__main__':
import offline_gateway as og
circuit_list = og.get_circuit_list()
debug = False
if debug:
circuit_list = circuit_list[:2]
# iterate over list of circuits
for c in circuit_list:
filename = 'pchp-' + c[1] + '-' + c[2][-3:] + '.pdf'
print 'querying for', filename
import offline_gateway as og
df = og.get_watthours_for_circuit_id(c[0], date_start, date_end)
if df == None:
continue
