Qualities Query

[janvanrijn]

TODO to self: add this query to the test server reset script

INSERT INTO quality(`type`,`name`,`datatype`,`min`,`max`) VALUES
('DataQuality', 'pymfe.attr_conc.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.attr_conc.sd','numerical',0,NULL),
('DataQuality', 'pymfe.attr_ent.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.attr_ent.sd','numerical',0,NULL),
('DataQuality', 'pymfe.attr_to_inst','numerical',NULL,NULL),
('DataQuality', 'pymfe.cat_to_num','numerical',0,NULL),
('DataQuality', 'pymfe.cohesiveness.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.cohesiveness.sd','numerical',0,NULL),
('DataQuality', 'pymfe.cor.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.cor.sd','numerical',0,NULL),
('DataQuality', 'pymfe.cov.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.cov.sd','numerical',0,NULL),
('DataQuality', 'pymfe.eigenvalues.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.eigenvalues.sd','numerical',0,NULL),
('DataQuality', 'pymfe.g_mean.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.g_mean.sd','numerical',0,NULL),
('DataQuality', 'pymfe.h_mean.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.h_mean.sd','numerical',0,NULL),
('DataQuality', 'pymfe.inst_to_attr','numerical',NULL,NULL),
('DataQuality', 'pymfe.iq_range.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.iq_range.sd','numerical',0,NULL),
('DataQuality', 'pymfe.kurtosis.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.kurtosis.sd','numerical',0,NULL),
('DataQuality', 'pymfe.mad.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.mad.sd','numerical',0,NULL),
('DataQuality', 'pymfe.max.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.max.sd','numerical',0,NULL),
('DataQuality', 'pymfe.mean.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.mean.sd','numerical',0,NULL),
('DataQuality', 'pymfe.median.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.median.sd','numerical',0,NULL),
('DataQuality', 'pymfe.min.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.min.sd','numerical',0,NULL),
('DataQuality', 'pymfe.nr_attr','numerical',0,NULL),
('DataQuality', 'pymfe.nr_bin','numerical',0,NULL),
('DataQuality', 'pymfe.nr_cat','numerical',0,NULL),
('DataQuality', 'pymfe.nr_cor_attr','numerical',0,NULL),
('DataQuality', 'pymfe.nr_inst','numerical',0,NULL),
('DataQuality', 'pymfe.nr_norm','numerical',0,NULL),
('DataQuality', 'pymfe.nr_num','numerical',0,NULL),
('DataQuality', 'pymfe.nr_outliers','numerical',0,NULL),
('DataQuality', 'pymfe.num_to_cat','numerical',0,NULL),
('DataQuality', 'pymfe.one_itemset.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.one_itemset.sd','numerical',0,NULL),
('DataQuality', 'pymfe.range.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.range.sd','numerical',0,NULL),
('DataQuality', 'pymfe.sd.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.sd.sd','numerical',0,NULL),
('DataQuality', 'pymfe.skewness.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.skewness.sd','numerical',0,NULL),
('DataQuality', 'pymfe.sparsity.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.sparsity.sd','numerical',0,NULL),
('DataQuality', 'pymfe.t2','numerical',NULL,NULL),
('DataQuality', 'pymfe.t3','numerical',NULL,NULL),
('DataQuality', 'pymfe.t4','numerical',NULL,NULL),
('DataQuality', 'pymfe.t_mean.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.t_mean.sd','numerical',0,NULL),
('DataQuality', 'pymfe.two_itemset.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.two_itemset.sd','numerical',0,NULL),
('DataQuality', 'pymfe.var.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.var.sd','numerical',0,NULL),
('DataQuality', 'pymfe.wg_dist.mean','numerical',NULL,NULL),
('DataQuality', 'pymfe.wg_dist.sd','numerical',0,NULL);