openmolecules.org

 
Home » DataWarrior » Functionality » Using Set Value Range option (How to use the "Set Value Range" option? )
Using Set Value Range option [message #211] Thu, 22 December 2016 11:22 Go to next message
jeetu270 is currently offline  jeetu270
Messages: 22
Registered: October 2015
Location: INDIA
Junior Member

Thanks for the great software..

I am not able to use the Set Value Range option. Even after defining the min and max values, nothing is happening..

Also is there any description for calculating selectivity score..

Please help..

Thanks
Re: Using Set Value Range option [message #213 is a reply to message #211] Sat, 31 December 2016 17:05 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 151
Registered: June 2014
Senior Member
The implicit value range of a numerical column is the span from the lowest existing to the highest existing value. It is mainly used to define the maximum visible range on axes in views. The value range option allows to extend this range, but not to reduce it, because a reduction would cause that some values would never be shown. On the other hand visible ranges on views can be achieved easily by the individual view sliders.

The selectivity score that is used is the Gini score described in Wikipedia and for instance used by P.P Graczyk as a compounds selectivity measure against a spectrum of kinases. The code used to calculate the score is simple (see below). If you have less than two columns containing valud numerical values the score is a NaN.

For every row the following is done:
A 'value' array contains the row values of the selected columns, a 'sum' array (same size) is provided:

Arrays.sort(value); // sort the value array in ascending order
int count = 0;
float area = 0; // to determine area of cumulative value sums

if (!Float.isNaN(value[0])) { // we skip not-a-number values
sum[0] = value[0];
count++;
while (count<columnCount && !Float.isNaN(value[count])) {
area += sum[count-1];
sum[count] = sum[count - 1] + value[count];
count++;
}
}

return (count <= 1) ? Double.NaN : 1.0 - 2.0 * area / (sum[count-1] * count);

Hope this explains it. I will describe it a little more detailled in the manual.
Re: Using Set Value Range option [message #216 is a reply to message #213] Mon, 02 January 2017 05:04 Go to previous message
jeetu270 is currently offline  jeetu270
Messages: 22
Registered: October 2015
Location: INDIA
Junior Member

Thanks for the explanation Thomas..

I will wait for your manual also..

Jitender
Previous Topic: Database Access
Next Topic: How to calculate selectivity score?
Goto Forum:
  


Current Time: Wed Sep 19 22:18:54 CEST 2018

Total time taken to generate the page: 0.00518 seconds