# 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