Assigning color values in a range based on numberic values
By : Quinn Wolter
Date : March 29 2020, 07:55 AM
I hope this helps . Let's set some arbitrary starting and ending values, say, pure red (#FF0000) for high melting point, and pure blue (#00FF00) for low melting point. For the sake of simplicity, let's say that the periodic table only has melting point values between 10 and 500 (I know it doesn't but it shouldn't be a huge change). code :
$mp=440;
$max=500;
$min=10;
$position=($mp$min)/($max$min);
$highColor=hexdec("FF0000"); //converts to decimal for multiplication
$lowColor=hexdec("00FF00");
$newColor=intval($position*($highColor$lowColor)+$lowColor);
$newColorStr=dechex($newColor);

Finding a range of values two other columns from based on values in another column
By : William Black
Date : March 29 2020, 07:55 AM
Does that help I'm trying trying to use python to find value ranges in two columns (TableA) based on values from the first column of TableB. Column 1 and Column 2 in TableA represent ranges of values Whenever, a value from column 1 in TableB falls within a range, I want to extract such rows from TableA as shown in the output and also know how many they are. , You could try it this way: code :
tableBcol1=[int(i.split()[0]) for i in open('TableB.txt')]
tableA=[i.strip() for i in open('TableA.txt')]
count=0
for bcol1 in tableBcol1:
for line in tableA:
lbound,hbound=line.split()
if bcol1 in range(int(lbound),int(hbound)+1):
print(line.strip())
count+=1
print(count)

repeat each vector's values based on random values in an interval range
By : Yongmok Lee
Date : March 29 2020, 07:55 AM
I think the issue was by ths following , I have this data , Another approach... code :
reptime < sapply(1:length(data),function(x)
x < ceiling(runif(1, 0, 3)) );
dummy < rep(data , reptime );
sort(dummy)

How to replace 0 values in a numpy array to other values based on column range?
By : Bradley Soverns
Date : March 29 2020, 07:55 AM
will help you One way would be to use a masked array to find the minimum value along the columns masking those that are <=0. And replace the 0s in the array with the corresponding minimum using np.where: code :
min_gt0 = np.ma.array(r, mask=r<=0).min(0)
np.where(r == 0, min_gt0, r)
r = np.random.randint(0,5,(5,5))
print(r)
array([[2, 1, 3, 0, 4],
[0, 4, 4, 2, 2],
[4, 0, 0, 0, 1],
[1, 2, 2, 2, 2],
[2, 0, 4, 4, 2]])
min_gt0 = np.ma.array(r, mask=r<=0).min(0)
np.where(r == 0, min_gt0, r)
array([[2, 1, 3, 2, 4],
[1, 4, 4, 2, 2],
[4, 1, 2, 2, 1],
[1, 2, 2, 2, 2],
[2, 1, 4, 4, 2]])

How can I SUM values based om multiple criteria where one is a range (list of values)?
By : elring89
Date : March 29 2020, 07:55 AM
fixed the issue. Will look into that further I am using Google Sheets, but it looks like nowadays it supports most of Excel functions as well. , Try this: code :
=sumproduct(isnumber(match(F3:F9,B3:B7,0)),(E3:E9="X"),G3:G9)

