openmolecules.org

 
Home » DataWarrior » Cheminformatics » Mean value in category function
Mean value in category function [message #1347] Wed, 21 July 2021 20:06
chemtv is currently offline  chemtv
Messages: 18
Registered: February 2015
Location: Indianapolis
Junior Member
Hello,
I am using a calc'd column to obtain the mean of clogP (values) in a plate (category). In a dummy table with 25 cpds and the necessary info it works fine but I get 'NaN' for my large table of 525K cpds with clogP (float values from -2.6 to 11) and 209 PlateNo's (integers 1-209 category). There are no missing values, I use the drop-down menu to select columns and I am quoting both column identifiers in the formula below:

categoryMean("Plateno", "clogP")

Is there a size limit to the calculation?

Thanks for any help.

Greg
 
Read Message
Previous Topic: mean from 'n' in pKaInWater.dwar
Next Topic: Importing compounds with assay data from Pubchem into Datawarrior
Goto Forum:
  


Current Time: Sun Oct 24 08:35:08 CEST 2021

Total time taken to generate the page: 0.01681 seconds