def get_test_data(num_houses):
devices_types_unsampled={}
ids_for_devices={}
db_url='postgresql://*****:*****@db.wiki-energy.org:5432/postgres'
psda.set_url(db_url)
schema = 'shared'
tables= psda.get_table_names(schema)
print tables
table=tables[3]
ids_device_name='air1'
ids_for_devices[ids_device_name]=psda.get_dataids_with_real_values(schema,table,ids_device_name)
device_name='air1'
devices_types_unsampled[device_name]=psda.generate_type_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])
device_name='use'
devices_types_unsampled[device_name]=psda.generate_type_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])
#Resamples the data
devices_types={}
devices_types_unsplit={}
sample_rate='1T'
length='D'
for key in devices_types_unsampled:
devices_types_unsplit[key]=devices_types_unsampled[key].resample(sample_rate)
#devices_types[key]=devices_types_unsplit[key].split_by(length)
devices_types[key]=devices_types_unsplit[key]
print "Resampled " + str(key)
return devices_types
def get_test_data(num_houses):
devices_types_unsampled = {}
ids_for_devices = {}
db_url = 'postgresql://*****:*****@db.wiki-energy.org:5432/postgres'
psda.set_url(db_url)
schema = 'shared'
tables = psda.get_table_names(schema)
print tables
table = tables[3]
ids_device_name = 'air1'
ids_for_devices[ids_device_name] = psda.get_dataids_with_real_values(
schema, table, ids_device_name)
device_name = 'air1'
devices_types_unsampled[
device_name] = psda.generate_type_for_appliance_by_dataids(
schema, table, device_name,
ids_for_devices[ids_device_name][:num_houses])
device_name = 'use'
devices_types_unsampled[
device_name] = psda.generate_type_for_appliance_by_dataids(
schema, table, device_name,
ids_for_devices[ids_device_name][:num_houses])
#Resamples the data
devices_types = {}
devices_types_unsplit = {}
sample_rate = '1T'
length = 'D'
for key in devices_types_unsampled:
devices_types_unsplit[key] = devices_types_unsampled[key].resample(
sample_rate)
#devices_types[key]=devices_types_unsplit[key].split_by(length)
devices_types[key] = devices_types_unsplit[key]
print "Resampled " + str(key)
return devices_types
def get_type_from_dataset(device_name,schema,table_num,limit=0):
'''
Given the device name
'''
devices_types={}
devices_types_unsampled={}
db_url='postgresql://*****:*****@db.wiki-energy.org:5432/postgres'
psda.set_url(db_url)
table='group1_disaggregated_2013_0'+str(table_num)
ids_for_device=psda.get_dataids_with_real_values(schema,table,device_name)
if(limit>len(ids_for_device) or limit==0):
limit=len(ids_for_device)
device_type_orig=psda.generate_type_for_appliance_by_dataids(schema,
table,device_name,ids_for_device[:limit])
return device_type_orig
def get_type_from_dataset(device_name, table_num, limit=0):
"""
Given the device name
"""
devices_types = {}
devices_types_unsampled = {}
db_url = "postgresql://*****:*****@db.wiki-energy.org:5432/postgres"
psda.set_url(db_url)
schema = "shared"
table = "validated_0" + str(table_num) + "_2014"
ids_for_device = psda.get_dataids_with_real_values(schema, table, device_name)
if limit > len(ids_for_device) or limit == 0:
limit = len(ids_for_device)
device_type_orig = psda.generate_type_for_appliance_by_dataids(schema, table, device_name, ids_for_device[:limit])
return device_type_orig
def get_type_from_dataset(device_name, schema, table_num, limit=0):
'''
Given the device name
'''
devices_types = {}
devices_types_unsampled = {}
db_url = 'postgresql://*****:*****@db.wiki-energy.org:5432/postgres'
psda.set_url(db_url)
table = 'group1_disaggregated_2013_0' + str(table_num)
ids_for_device = psda.get_dataids_with_real_values(schema, table,
device_name)
if (limit > len(ids_for_device) or limit == 0):
limit = len(ids_for_device)
device_type_orig = psda.generate_type_for_appliance_by_dataids(
schema, table, device_name, ids_for_device[:limit])
return device_type_orig
