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)
)
