def check_covered_component(): ids = gbs.get_covered_set() f_ids = [x for x in ids if '0000' in x] b_ids = [x for x in ids if not '0000' in x] euas = gbs.get_all_building_set() print len(euas) print 'total {0}, facility {1}, building {2}'.format( len(ids), len(f_ids), len(b_ids)) for f in f_ids: dfs = [] df = uo.view_building(f, 'Electric_(kBtu)') bs = [ x for x in euas if '{0}0000{1}'.format(x[:2], x[-2:]) == f and not '0000' in x ] if len(bs) == 0: print 'no building under {0}'.format(f) continue dfs.append(df) for b in bs: df = uo.view_building(b, 'Electric_(kBtu)') dfs.append(df) df_all = pd.concat(dfs, ignore_index=True) df_all.sort(['year', 'month', 'Building_Number'], inplace=True) print 'write to {0}.csv'.format(f) df_all.to_csv(homedir + 'question/facility_building/{0}.csv'.format(f), index=False)
def show_covered_exception(b, **kwargs): euas = gbs.get_all_building_set() print b in euas bs = [x for x in euas if '{0}0000{1}'.format(x[:2], x[-2:]) == b] if 'bs' in kwargs: bs = kwargs['bs'] dfs = [] df = uo.view_building(b, 'Electric_(kBtu)') dfs.append(df) if 'year' in kwargs: year = kwargs['year'] df = df[(df['year'] == year) & (df['month'].isin([1, 2, 3]))] print b print df[['Region_No.', 'month', 'Electric_(kBtu)']] for x in bs[:3]: print x df = uo.view_building(x, 'Electric_(kBtu)') if 'year' in kwargs: year = kwargs['year'] df = df[(df['year'] == year) & (df['month'].isin([1, 2, 3]))] dfs.append(df) if 'year' in kwargs: print print df[['Region_No.', 'month', 'Electric_(kBtu)']] df_all = pd.concat(dfs, ignore_index=True) df_all.drop(['year', 'month'], axis=1, inplace=True) df_all.sort(['Fiscal_Year', 'Fiscal_Month', 'Building_Number'], inplace=True) print 'write to {0}.csv'.format(b) df_all.to_csv(homedir + 'question/facility_building/{0}.csv'.format(b), index=False) return
def check_covered_component(): ids = gbs.get_covered_set() f_ids = [x for x in ids if '0000' in x] b_ids = [x for x in ids if not '0000' in x] euas = gbs.get_all_building_set() print len(euas) print 'total {0}, facility {1}, building {2}'.format(len(ids), len(f_ids), len(b_ids)) for f in f_ids: dfs = [] df = uo.view_building(f, 'Electric_(kBtu)') bs = [x for x in euas if '{0}0000{1}'.format(x[:2], x[-2:]) == f and not '0000' in x] if len(bs) == 0: print 'no building under {0}'.format(f) continue dfs.append(df) for b in bs: df = uo.view_building(b, 'Electric_(kBtu)') dfs.append(df) df_all = pd.concat(dfs, ignore_index=True) df_all.sort(['year', 'month', 'Building_Number'], inplace=True) print 'write to {0}.csv'.format(f) df_all.to_csv(homedir + 'question/facility_building/{0}.csv'.format(f), index=False)