openmolecules.org Forum: Functionality » Using Set Value Range option

Home » DataWarrior » Functionality » Using Set Value Range option (How to use the "Set Value Range" option? )

Show: Today's Messages :: Polls :: Message Navigator

Using Set Value Range option [message #211]

Thu, 22 December 2016 11:22

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

Report message to a moderator

Re: Using Set Value Range option [message #213 is a reply to message #211]

Sat, 31 December 2016 17:05

thomas
Messages: 728
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.

Report message to a moderator

Re: Using Set Value Range option [message #216 is a reply to message #213]

Mon, 02 January 2017 05:04

jeetu270
Messages: 22
Registered: October 2015
Location: INDIA

Junior Member

Thanks for the explanation Thomas..

I will wait for your manual also..

Jitender

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Apr 04 17:12:48 CEST 2025

Total time taken to generate the page: 0.04428 seconds