def sql_test(): user = os.environ['USER'].lower() do_test = False if user in ['lemiesim', 'simon']: user = '******' table = 'view_apr28_arch5' do_test = True elif user in ['hamelphi','phil']: user = '******' table = 'conv_filter1_view' do_test = True if do_test: data = H.sql2hyperdatabase(user = user, host = 'gershwin.iro.umontreal.ca', db = user + '_db', table = table) if user == 'lemiesim': data.add_filter('bestkendall', H.filtering.notnull()) H.hyperscatter(data, x=('poolingfactors', H.get_el(0,0)), y=('poolingfactors', H.get_el(1,0)), z='bestkendall', title='salut') elif user == 'hamelphi': data.add_filter('jobman_status', H.filtering.eq(2)) data.add_filter('validcost', H.filtering.notnull()) H.hyperscatter(data, x='lr', y = ('pcadim', lambda x : {80:0,120:1}[x]), c='validcost', title='scatterplot') print data._filters print data
def csv_test(): csv_file = os.path.join(os.path.split(H.__file__)[0],'test','csv_test.csv') data = H.csv2hyperdatabase(csv_file) # data.filter_all_null() for name in data.column_names: data.add_filter(name, H.filtering.notnull(name= 'notnull_' + name)) H.hyperscatter(data, x=('poolingfactors', H.get_el(0,0)), y=('poolingfactors', H.get_el(1,0)), c = 'bestkendall', title='csv1') # data.filter('bestkendall', filter_lt(.66)) data.add_filter('poolingfactors', H.filtering.outside(2,8, parse_func=H.get_el(0,0))) data.add_filter('poolingfactors', H.filtering.between(4,5, parse_func=H.get_el(1,0))) print data H.hyperscatter(data, x=('poolingfactors', H.get_el(0,0)), y=('poolingfactors', H.get_el(1,0)), c = 'bestkendall', title='csv2')
def hyper_test(): data = generate_data() # 2D H.hyperscatter(data, x = 'hyper_par1', y = 'cost', title='2d') # 2D + size H.hyperscatter(data, x = 'hyper_par1', y = 'cost', title='2d', s = ('cost', lambda x:abs(x)*10.)) # 2D + color H.hyperscatter(data, x = 'hyper_par1', y = 'cost', c = 'hyper_par2', title='2d + color') #fixed size H.hyperscatter(data, x = 'hyper_par1', y = 'cost', c = 'hyper_par2', s = 100, title='2d + color') # 3D H.hyperscatter(data, x = 'hyper_par1', y = 'hyper_par2', z = 'cost', title='3d') # 3D + color + parse_func H.hyperscatter(data, x = 'hyper_par1', y = 'hyper_par2', z = 'cost', c = ('couples', H.get_el(0)), title='3d + color + parse_func') # 2d + log + parse_func + color H.hyperscatter(data, x = ('log_1d', 'log'), y = 'autre_hyper', c = ('couples', H.get_el(0)), title='3d + log + parse_func + color') # 3D + log + parse_func H.hyperscatter(data, x = ('log_tuples', H.get_el(-1,-1), 'log'), y = 'hyper_par2', z = 'cost', c = ('couples', H.get_el(0)), title='3d log') # 3D + discrete H.hyperscatter(data, x = 'hyper_par1', y = 'hyper_par2', z = ('discrete', H.get_el(5)), title='3d discrete') # other args H.hyperscatter(data, x='hyper_par1', y='hyper_par2', title='titre au graph') # texte 2D H.hyperscatter(data, x='hyper_par1', y = 'hyper_par2', c = 'tzz', t='texte_texte2') # text 3D H.hyperscatter(data, x='hyper_par1', y = 'hyper_par2', z = ('discrete', H.get_el(5)), c = 'hyper_par2', t=('hyper_par2', lambda x : '%0.2f' % x)) # 3D + text + size + color H.hyperscatter(data, x = 'hyper_par1', y = 'hyper_par2', z = ('discrete', H.get_el(5)), c = 'cost', t = ('cost', lambda x : '%0.2f' % x), s = ('cost', lambda x : 5.*x*x) )