In [2]:

    

import json
import numpy as np
import matplotlib.pyplot as plt
from hmmlearn import hmm
from sklearn.metrics import confusion_matrix
from collections import OrderedDict
import itertools
from sklearn.neighbors.kde import KernelDensity
from copy import deepcopy
import datetime

import pandas as pd



import matplotlib.pylab as pylab
import matplotlib.cm as cm
import scipy
import scipy.fftpack
import pylab
import sys
sys.path.append('../../') # or non-Unix equivalent (add wikienergy/ to path)
from disaggregator import PecanStreetDatasetAdapter as psda
from disaggregator import utils
from disaggregator import evaluation_metrics as metric
from disaggregator import fhmm
from numpy import sin, linspace, pi
from pylab import plot, show, title, xlabel, ylabel, subplot
from scipy import fft, arange
from scipy import pi

import os
%matplotlib inline
pylab.rcParams['figure.figsize'] = 16, 9


    

    




/usr/local/lib/python2.7/dist-packages/pandas/io/excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >=1.6.1 and <2.0.0.
  .format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver))

In [9]:

    

mu=2
sigma=.1
np.random.normal(mu, sigma, 1)[0]


    

    
Out[9]:





1.7973267504663188

In [4]:

    

def getBestInstanceModel(models,device_type,key_for_model_name):
    dfs_model={}
    best_model_score=0
    
    for model_name in models:
        instances_of_model=[]
        for instance in device_type.instances:
            test_trace=instance.traces[0]
            instance_name=test_trace.metadata[key_for_model_name]
            test=values_to_array(test_trace.series)
            model_score=models[model_name].score(test)
            instances_of_model.append([model_name,instance_name,model_score])
            if(model_score>best_model_score):
                best_model=models[model_name]
        dfs_model[model_name] = pd.DataFrame(data=instances_of_model,columns=['Model_Instance','Test_Instance','Value'])
    model_averages=[]   
    for key in dfs_model:
        sum=0
        for row in dfs_model[key].iterrows():
            sum=sum+row[1]['Value']
        model_averages.append([key,sum/len(dfs_model[key].index)])
    print
    avg_model_df = pd.DataFrame(data=model_averages,columns=['Model_Instance','Avg Probability'])
    print avg_model_df.sort('Avg Probability',ascending=False)
    bestModel= avg_model_df.sort('Avg Probability',ascending=False).sort('Avg Probability',ascending=False).head(1)['Model_Instance'].values[0]
    print str(bestModel)+' is best.'
    return bestModel


    

In [5]:

    

#Load Datasets
devices_types={}
devices_types_unsampled={}
db_url='postgresql://USERNAME:PASSWORD@db.wiki-energy.org:5432/postgres'
psda.set_url(db_url)


    

In [6]:

    

schema = 'shared'
tables= psda.get_table_names(schema)
print tables


    

    




[u'validated_01_2014', u'validated_02_2014', u'validated_04_2014', u'validated_05_2014', u'validated_03_2014']

In [7]:

    

reload(psda)
reload(utils)
psda.set_url(db_url)


    

In [18]:

    

#Gets id's associated with a device and generates types for each ids
ids_for_devices={}
num_houses=1000
table=tables[3]
device_name='air1'
ids_for_devices[device_name]=psda.get_dataids_with_real_values(schema,table,device_name)
#ids_for_air=[26, 59, 86, 93, 94, 280, 410, 434, 484, 499, 580, 624, 661, 739, 744, 774, 821, 871, 936, 1086, 1167, 1283, 1334, 1450, 1507, 1617, 1632, 1681, 1696, 1714, 1718, 1782, 1790, 1830, 1953, 1994, 2034, 2094, 2129, 2156, 2158, 2171, 2242, 2365, 2378, 2470, 2575, 2606, 2638, 2641, 2769, 2787, 2814, 2829, 2845, 2864, 2945, 2953, 2974, 3044, 3092, 3134, 3192, 3221, 3263, 3367, 3394, 3456, 3482, 3504, 3531, 3649, 3652, 3723, 3736, 3778, 3795, 3893, 4135, 4154, 4298, 4313, 4352, 4373, 4505, 4526, 4641, 4767, 4874, 4922, 4956, 4957, 4998, 5026, 5109, 5209, 5218, 5275, 5357, 5395, 5545, 5568, 5677, 5785, 5814, 5852, 5874, 5889, 5938, 5949, 5972, 6139, 6165, 6412, 6636, 6673, 6730, 6826, 6836, 6910, 6941, 7062, 7319, 7390, 7531, 7536, 7617, 7731, 7769, 7788, 7800, 7850, 7863, 7875, 7940, 7951, 8046, 8079, 8084, 8142, 8188, 8197, 8201, 8218, 8292, 8342, 8419, 8645, 8669, 8741, 8956, 9019, 9036, 9121, 9141, 9160, 9343, 9356, 9484, 9488, 9499, 9555, 9578, 9609, 9613, 9643, 9654, 9701, 9729, 9737, 9771, 9830, 9875, 9915, 9922, 9926, 9932, 9934, 9938, 9939, 9982, 9983]
ids_for_air=[26, 59, 86, 93, 94, 280, 410, 434, 484, 499, 580, 624, 661, 739, 744, 774, 821, 871, 936, 1086, 1167, 1283, 1334, 1450, 1507, 1617, 1632, 1681, 1696, 1714, 1718, 1782, 1790, 1830, 1953, 1994, 2034, 2094, 2129, 2156, 2158, 2171, 2242, 2365, 2378, 2470, 2575, 2606, 2638, 2641, 2769, 2787, 2814, 2829, 2845, 2864, 2945, 2953, 2974, 3044, 3092, 3134, 3192, 3221, 3263, 3367, 3394, 3456, 3482, 3504, 3531, 3649, 3652, 3723, 3736, 3778, 3795, 3893, 4135, 4154, 4298, 4313, 4352, 4373, 4505, 4526, 4641, 4767, 4874, 4922, 4956, 4957, 4998, 5026, 5109, 5209, 5218, 5275, 5357, 5395, 5545, 5568, 5677, 5785, 5814, 5852, 5874, 5889, 5938, 5949, 5972, 6139, 6165, 6412, 6636, 6673, 6730, 6826, 6836, 6910, 6941, 7062, 7319, 7390, 7531, 7536, 7617, 7731, 7769, 7788, 7800, 7850, 7863, 7875, 7940, 7951, 8046, 8079, 8084, 8142, 8188, 8197, 8201, 8218, 8292, 8342, 8419, 8645, 8669, 8741, 8956, 9019, 9036, 9121, 9141, 9160, 9343, 9356, 9484, 9488, 9499, 9555, 9578, 9609, 9613, 9643, 9654, 9701, 9729, 9737, 9771, 9830, 9875, 9915, 9922, 9926, 9932, 9934, 9938, 9982, 9983]


    

In [19]:

    

device_name='air1'
devices_types_unsampled[device_name]=psda.generate_type_for_appliance_by_dataids(schema,table,device_name,ids_for_air[:num_houses])


    

    




select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=26
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=59
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=86
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=93
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=94
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=280
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=410
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=434
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=484
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=499
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=580
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=624
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=661
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=739
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=744
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=774
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=821
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=871
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=936
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1086
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1167
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1283
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1334
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1450
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1507
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1617
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1632
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1681
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1696
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1714
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1718
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1782
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1790
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1830
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1953
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1994
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2034
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2094
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2129
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2156
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2158
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2171
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2242
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2365
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2378
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2470
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2575
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2606
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2638
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2641
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2769
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2787
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2814
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2829
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2845
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2864
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2945
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2953
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2974
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3044
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3092
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3134
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3192
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3221
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3263
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3367
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3394
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3456
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3482
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3504
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3531
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3649
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3652
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3723
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3736
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3778
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3795
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3893
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4135
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4154
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4298
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4313
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4352
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4373
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4505
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4526
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4641
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4767
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4874
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4922
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4956
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4957
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4998
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5026
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5109
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5209
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5218
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5275
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5357
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5395
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5545
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5568
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5677
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5785
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5814
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5852
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5874
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5889
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5938
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5949
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5972
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6139
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6165
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6412
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6636
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6673
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6730
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6826
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6836
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6910
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6941
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7062
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7319
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7390
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7531
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7536
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7617
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7731
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7769
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7788
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7800
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7850
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7863
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7875
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7940
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7951
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8046
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8079
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8084
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8142
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8188
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8197
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8201
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8218
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8292
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8342
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8419
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8645
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8669
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8741
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8956
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9019
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9036
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9121
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9141
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9160
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9343
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9356
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9484
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9488
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9499
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9555
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9578
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9609
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9613
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9643
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9654
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9701
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9729
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9737
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9771
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9830
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9875
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9915
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9922
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9926
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9932
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9934
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9938
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9982
select air1,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9983

In [20]:

    

device_name='use'
devices_types_unsampled[device_name]=psda.generate_type_for_appliance_by_dataids(schema,table,device_name,ids_for_air[:num_houses])


    

    




select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=26
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=59
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=86
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=93
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=94
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=280
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=410
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=434
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=484
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=499
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=580
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=624
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=661
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=739
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=744
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=774
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=821
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=871
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=936
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1086
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1167
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1283
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1334
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1450
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1507
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1617
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1632
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1681
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1696
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1714
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1718
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1782
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1790
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1830
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1953
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=1994
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2034
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2094
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2129
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2156
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2158
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2171
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2242
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2365
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2378
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2470
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2575
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2606
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2638
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2641
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2769
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2787
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2814
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2829
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2845
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2864
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2945
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2953
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=2974
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3044
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3092
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3134
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3192
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3221
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3263
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3367
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3394
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3456
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3482
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3504
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3531
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3649
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3652
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3723
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3736
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3778
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3795
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=3893
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4135
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4154
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4298
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4313
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4352
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4373
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4505
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4526
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4641
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4767
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4874
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4922
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4956
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4957
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=4998
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5026
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5109
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5209
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5218
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5275
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5357
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5395
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5545
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5568
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5677
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5785
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5814
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5852
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5874
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5889
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5938
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5949
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=5972
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6139
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6165
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6412
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6636
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6673
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6730
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6826
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6836
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6910
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=6941
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7062
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7319
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7390
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7531
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7536
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7617
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7731
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7769
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7788
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7800
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7850
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7863
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7875
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7940
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=7951
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8046
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8079
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8084
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8142
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8188
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8197
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8201
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8218
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8292
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8342
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8419
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8645
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8669
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8741
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=8956
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9019
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9036
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9121
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9141
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9160
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9343
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9356
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9484
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9488
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9499
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9555
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9578
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9609
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9613
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9643
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9654
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9701
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9729
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9737
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9771
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9830
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9875
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9915
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9922
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9926
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9932
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9934
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9938
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9982
select use,localminute from "PecanStreet_SharedData".validated_05_2014 where dataid=9983

In [21]:

    

#Resamples the data
sample_rate='15T'
length='D'
devices_types_unsplit={}
for key in devices_types_unsampled:
    devices_types_unsplit[key]=utils.resample_type_traces(devices_types_unsampled[key],sample_rate)
    #devices_types[key]=utils.split_type_traces_into_rate(devices_types_unsplit[key],length)
    devices_types[key]=devices_types_unsplit[key]
    print key


    

    




WARNING: deprecated, use appliance_type.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
air1
WARNING: deprecated, use appliance_type.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
WARNING: deprecated, use appliance_instance.resample(sample_rate) instead
WARNING: deprecated, use appliance_trace.resample(sample_rate) instead
use

In [215]:

    

#Look at individual trace
device_name_test='air1'
device_type_test=devices_types[device_name_test]
index=0
index2=0
print device_type_test.instances[index].metadata
plt.plot(device_type_test.instances[index].traces[index2].series.index,device_type_test.instances[index].traces[index2].series)


    

    




{'dataid': 26, 'source': 'PecanStreet', 'device_name': 'air1', 'table': u'validated_05_2014', 'schema': 'shared'}






    
Out[215]:





[<matplotlib.lines.Line2D at 0x7f1130ba3bd0>]






    

In [35]:

    

#Aggregating Signals using the first instance in each ordered dict.

today=datetime.datetime.min
if(sample_rate=='15T'):
    power_total=np.zeros((96,1))
    mins = datetime.timedelta(minutes=15)
elif(sample_rate=='1T'):
    power_total=np.zeros((1440,1))
    mins = datetime.timedelta(minutes=1)
time_total=[]
test_data={}
test_time={}
#Create generic time array


for i,val in enumerate(power_total):
    time_total.append((today+i*mins).time())
    
plt.figure()

for device_name in devices_types:
    print device_name
    device_type=devices_types[device_name]
    test_data[device_name]=values_to_array(device_type.instances[0].traces[2].series)
    test_time[device_name]=device_type.instances[0].traces[2].series.index.time
    power_total=power_total+test_data[device_name]
    plt.plot(test_time[device_name],test_data[device_name],label=device_name)
plt.plot(time_total,power_total,label='total');
plt.title("Simulated total energy")
plt.xlabel("Time")
plt.ylabel("Energy (Wh)");
plt.legend(bbox_to_anchor=(0., 1.05, 1., .102), loc=3,
       ncol=2, mode="expand", borderaxespad=0.)


    

    




air1
use






    
Out[35]:





<matplotlib.legend.Legend at 0x7f111ff679d0>






    

In [22]:

    

#Aggregating Signals using the use column of Pecan.

today=datetime.datetime.min
if(sample_rate=='15T'):
    power_total=np.zeros((96,1))
    mins = datetime.timedelta(minutes=15)
elif(sample_rate=='1T'):
    power_total=np.zeros((1440,1))
    mins = datetime.timedelta(minutes=1)
time_total=[]
test_data={}
test_time={}

#Create generic time array
for i,val in enumerate(power_total):
    time_total.append((today+i*mins).time())
    
plt.figure()

for device_name in devices_types:
    print device_name
    device_type=devices_types[device_name]
    test_data[device_name]=values_to_array(device_type.instances[0].traces[0].series)
    test_time[device_name]=device_type.instances[0].traces[0].series.index
    plt.plot(test_data[device_name],label=device_name)
power_total=test_data['use']
plt.plot(power_total,label='total');
plt.title("Simulated total energy")
plt.xlabel("Time")
plt.ylabel("Energy (Wh)");
plt.legend(bbox_to_anchor=(0., 1.05, 1., .102), loc=3,
       ncol=2, mode="expand", borderaxespad=0.)


    

    




air1






    




---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-22-4a93be03b6fc> in <module>()
     21     print device_name
     22     device_type=devices_types[device_name]
---> 23     test_data[device_name]=values_to_array(device_type.instances[0].traces[0].series)
     24     test_time[device_name]=device_type.instances[0].traces[0].series.index
     25     plt.plot(test_data[device_name],label=device_name)

NameError: name 'values_to_array' is not defined





    






<matplotlib.figure.Figure at 0x7f3ab7f9fa90>

In [37]:

    

#Initialize Variables for Model
devices_models={}
devices_data={}

devices_type_names=[]
pi_prior={}
a_prior={}
mean_prior={}
cov_prior={}
best_model=OrderedDict()


    

In [283]:

    

## 1 Feature
device_type_name='air1'
key_for_model_name='dataid'
pi_prior[device_type_name]=np.array([0.1,0.1,0.8])
a_prior[device_type_name]=np.array([[0.95,0.04,.01],[0.04,0.95,0.01],[0.04,0.01,0.95]])
mean_prior[device_type_name]=np.array([[0],[2], [2.5]])
cov_prior[device_type_name]=np.tile(1, (2, 1, 1))
devices_models[device_type_name]=fhmm.generate_HMMs_from_type(devices_types[device_type_name],pi_prior[device_type_name],a_prior[device_type_name],mean_prior[device_type_name],cov_prior[device_type_name],key_for_model_name)
best_model[device_type_name]=getBestInstanceModel(devices_models[device_type_name],devices_types[device_type_name],key_for_model_name)


    

    




     Model_Instance  Avg Probability
109            2864    180712.829272
97             4874    178245.574736
34             8292    177809.543225
123             484    177783.962998
175            2034    177665.741711
156             434    177557.635373
17             9737    177056.887969
158            1617    177014.864405
174            6636    177007.120837
152            1450    176752.053032
13             9771    175931.609486
122            5972    175260.975267
178            9922    174768.609526
179            6139    173833.258130
22             3652    173640.238544
93             1283    171197.460875
155            3504    170504.958368
11             8741    169650.084684
159            2606    168830.832728
162            7617    168596.625111
32             1632    167913.620234
168            8142    167230.743209
146            1953    166845.248015
150             936    166198.229353
114            4922    165994.353246
53             7319    165945.352244
67             9915    165282.261236
111             821    165267.992142
0              9729    164393.392253
128            7531    163091.486228
..              ...              ...
131            7536     11770.478086
141            7062      9076.684821
38              624      5757.793595
117            3893      3722.063457
153            9643     -2409.490082
132            1086    -23742.444658
74             9934    -30173.376707
23             5814    -31379.546399
172            9701    -32061.145411
64             6836    -39741.333344
106            2845    -44929.737865
42             9343    -69860.992767
84             5357    -92818.092746
126             871   -111121.668465
98             6412   -128728.607775
29             5209   -131716.035699
62             6941   -132602.766304
85             5874   -152580.621089
7              6165   -156657.703655
70             7875   -161929.442861
160            5109   -178315.644153
79             5852   -205056.716304
31               94   -242006.741423
76             9938   -336068.970598
21             3649   -518001.334004
73             9932   -625898.601196
48             1167   -774641.616131
125            4957  -1043816.536186
6              3092  -4594379.026269
112            1334 -11767345.568355

[182 rows x 2 columns]
2864 is best.

In [ ]:

    




    

In [292]:

    

#startprob_
#means_
#transmat_
#covars_
state_0=[]
state_1=[]
state_2=[]
for model_num in devices_models['air1']:
    a=devices_models['air1'][model_num].means_
    state_0.append(a[0][0])
    state_1.append(a[1][0])
    state_2.append(a[2][0])
high_lim=10
bins=30
plt.subplot(3,1,1)
plt.hist(state_0,bins,range=[0,high_lim])
plt.xlim([0 ,high_lim])
plt.subplot(3,1,2)
plt.hist(state_1,bins,range=[0,high_lim])
plt.xlim([0 ,high_lim])
plt.subplot(3,1,3)
plt.hist(state_2,bins,range=[0,high_lim])
plt.xlim([0 ,high_lim])


    

    
Out[292]:





(0, 10)






    

In [297]:

    

"""
Show how to modify the coordinate formatter to report the image "z"
value of the nearest pixel given x and y
"""

def format_coord(x, y):
    col = int(x+0.5)
    row = int(y+0.5)
    if col>=0 and col<numcols and row>=0 and row<numrows:
        z = X[row,col]
        return 'x=%1.4f, y=%1.4f, z=%1.4f'%(x, y, z)
    else:
        return 'x=%1.4f, y=%1.4f'%(x, y)


    

In [201]:

    

## 1 Feature
device_type_name='car1'
key_for_model_name='dataid'
pi_prior[device_type_name]=np.array([0.9,0.1])
a_prior[device_type_name]=np.array([[0.95,0.05],[0.05,0.95]])
mean_prior[device_type_name]=np.array([[0],[3500]])
cov_prior[device_type_name]=np.tile(np.identity(1), (2, 1, 1))
devices_models[device_type_name]=fhmm.generate_HMMs_from_type(devices_types[device_type_name],key_for_model_name,pi_prior[device_type_name],a_prior[device_type_name],mean_prior[device_type_name],cov_prior[device_type_name])
best_model[device_type_name]=getBestInstanceModel(devices_models[device_type_name],devices_types[device_type_name],key_for_model_name)


    

    




---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
<ipython-input-201-386791df0739> in <module>()
      6 mean_prior[device_type_name]=np.array([[0],[3500]])
      7 cov_prior[device_type_name]=np.tile(np.identity(1), (2, 1, 1))
----> 8 devices_models[device_type_name]=fhmm.generate_HMMs_from_type(devices_types[device_type_name],key_for_model_name,pi_prior[device_type_name],a_prior[device_type_name],mean_prior[device_type_name],cov_prior[device_type_name])
      9 best_model[device_type_name]=getBestInstanceModel(devices_models[device_type_name],devices_types[device_type_name],key_for_model_name)

KeyError: 'car1'

In [196]:

    

list_pi=[devices_models[appliance][best_model[appliance]].startprob_ for appliance in best_model]
print appliance
print best_model
print list_pi


    

    




air1
OrderedDict([('air1', 26)])
[array([  1.00000000e+00,   2.22054605e-16,   2.22054605e-16])]

In [28]:

    

#Creates FHMM
list_pi=[pi_prior[appliance] for appliance in best_model]
list_A=[a_prior[appliance] for appliance in best_model]
list_means=[mean_prior[appliance].flatten().tolist() for appliance in best_model]
pi_combined=compute_pi_fhmm(list_pi)
A_combined=compute_A_fhmm(list_A)
[mean_combined, cov_combined]=compute_means_fhmm(list_means)
model_fhmm=create_combined_hmm(len(pi_combined),pi_combined, A_combined, mean_combined, cov_combined)

power_total_minus_bottom=[]
for i in power_total:
    power_total_minus_bottom.append(i-power_total.min())
learnt_states=model_fhmm.predict(power_total_minus_bottom)
[decoded_states, decoded_power]=decode_hmm(len(learnt_states), mean_prior, [appliance for appliance in best_model], learnt_states)


    

    




[(0,), (2000,), (2500,)]
3

In [191]:

    




    

    
Out[191]:





OrderedDict([('air1', 26)])

In [ ]:

    

def compute_pi_fhmm(list_pi):
    '''
    Input: list_pi: List of PI's of individual learnt HMMs
    Output: Combined Pi for the FHMM
    '''
    result=list_pi[0]
    for i in range(len(list_pi)-1):
        result=np.kron(result,list_pi[i+1])
    return result

def compute_A_fhmm(list_A):
    '''
    Input: list_pi: List of PI's of individual learnt HMMs
    Output: Combined Pi for the FHMM
    '''
    result=list_A[0]
    for i in range(len(list_A)-1):
        result=np.kron(result,list_A[i+1])
    return result

def compute_means_fhmm(list_means):  
    '''
    Returns [mu, sigma]
    '''
    
    #list_of_appliances_centroids=[ [appliance[i][0] for i in range(len(appliance))] for appliance in list_B]
    states_combination=list(itertools.product(*list_means))
    print states_combination
    num_combinations=len(states_combination)
    print num_combinations
    means_stacked=np.array([sum(x) for x in states_combination])
    means=np.reshape(means_stacked,(num_combinations,1)) 
    cov=np.tile(5*np.identity(1), (num_combinations, 1, 1))
    return [means, cov] 

def create_combined_hmm(n, pi, A, mean, cov):
    combined_model=hmm.GaussianHMM(n_components=n,covariance_type='full', startprob=pi, transmat=A)
    combined_model.covars_=cov
    combined_model.means_=mean
    return combined_model

def decode_hmm(length_sequence, centroids, appliance_list, states):
    '''
    Decodes the HMM state sequence
    '''
    power_states_dict={}    
    hmm_states={}
    hmm_power={}
    total_num_combinations=1
    for appliance in appliance_list:
        total_num_combinations*=len(centroids[appliance])  

    for appliance in appliance_list:
        hmm_states[appliance]=np.zeros(length_sequence,dtype=np.int)
        hmm_power[appliance]=np.zeros(length_sequence)
        
    for i in range(length_sequence):
        factor=total_num_combinations
        for appliance in appliance_list:
            #assuming integer division (will cause errors in Python 3x)
            factor=factor//len(centroids[appliance])
            
            temp=int(states[i])/factor
            hmm_states[appliance][i]=temp%len(centroids[appliance])
            hmm_power[appliance][i]=centroids[appliance][hmm_states[appliance][i]]
            
    return [hmm_states,hmm_power]


    

In [31]:

    

plt.figure()
plt.plot(power_total_minus_bottom)
plt.title('Aggregated Energy without constant power')
plt.ylabel('Energy (Wh)')
plt.xlabel('Time')

for i,device_type in enumerate(best_model):
    plt.figure()
    #plt.subplot(2,1,1)
    plt.plot(test_data[device_type],'g')
    plt.title('Ground Truth Energy for %s' %device_type)
    #plt.subplot(2,1,2)
    plt.plot(decoded_power[device_type],'b')
    plt.title('Predicted Energy for %s' %device_type)
    plt.ylabel('Energy (Wh)')
    plt.xlabel('Time')
    plt.ylim((np.min(test_data[device_type])-10, np.max(test_data[device_type])+10))
    plt.tight_layout()


    

In [30]:

    

for device_name in devices_types:
    if device_name is not 'use':
        truth_states=metric.guess_truth_from_power(test_data[device_name],2)
        eval_metrics=metric.get_positive_negative_stats(truth_states,decoded_states[device_name])
        print device_name
        print 'precision:' + str(metric.get_precision(eval_metrics['tp'],eval_metrics['fp'])*100)+'%'
        print 'recall:' + str(metric.get_sensitivity(eval_metrics['tp'],eval_metrics['fn'])*100)+'%'
        print 'diff in power:' + str(metric.sum_error(test_data[device_name],decoded_power[device_name]))+'Wh'
        print


    

    




air1
precision:61.9441127299%
recall:99.8613891884%
diff in power:26613064.0Wh

In [188]:

    

#Possibly add different states for night, day, and peak times for each appliance


    

In [188]:

    




    

In [ ]: